Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Discoverer Desktop Issues
mstarks
post Apr 27 2012, 12:57 PM
Post #1


Newbie
*

Group: Possible Spammers
Posts: 1
Joined: 27-April 12
Member No.: 47,147



I know this may be a shot in the dark, but the folks at Oracle are less than forthcoming with any form of assistance.

I am trying to install Discoverer Desktop 9.0.4 on a windows 7 x86 machine. I know the product is obsolete, but this is only temporary as we transition to a new platform.

I am able to install the software just fine; what I cannot do is log in. I keep getting

Unable to connect to: discov_user@op012
Failed to connect to database - ORA-02248: invalid option for ALTER SESSION

The NLS_LANG for the database is at AMERICAN.AMERICA.WE8MSWIN1252
I have set it on the client to match
I have deleted it from the registries
I have created a system variable

Nothing works. I know the tnsnames.ora file is correct as the exact same load works fine on a XP machine.

Does anyone have any tips or ideas that may help?

Thanks in advance,
Mike
Go to the top of the page
 
+Quote Post
burleson
post Apr 27 2012, 03:56 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,614
Joined: 26-January 04
Member No.: 13



Hi Mike,

Can this user connect to SQL*Plus OK?


*****************************************
>> Failed to connect to database - ORA-02248: invalid option for ALTER SESSION

This is a DBA forum, but I found this may be a known bug in your elderly release of Discoverer, see MOSC Note 418951.1

http://support.oracle.com


See same issue here:

https://forums.oracle.com/forums/thread.jsp...hreadID=2212516

QUOTE
We have solved the problem with upgrading discoverer.



It might also be a missing privilege issue. Try temporarily granting DBA role to the user ID.
Also try this command

CODE
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
michaelasc
post Apr 28 2012, 01:05 AM
Post #3


Advanced Member
***

Group: Members
Posts: 189
Joined: 5-May 05
From: Cookeville, Tennessee
Member No.: 2,014



Hello
As you yourself say, Discoverer 9.0.4 is long de-supported and is not certified on Windows 7. So when you say the folks at Oracle are less than forthcoming that is a little unfair as a) you are using an obsolete product, and cool.gif you are attempting to install it on a platform for which it is not certified.

Did you try installing it into XP Mode of Windows 7? If you tried it in the native OS I don't think there is any way that it will work. Even though it is not supported on Windows 7 it was supported in XP so that is, I believe, your only chance of getting it to work.

Also, what version of the database are you trying to connect to? Discoverer 9.0.4 came out long before some of the newer versions so it does not come with the install scripts for the EUL user like the newer ones do.

For an Administrator the newer editions, aka newer databases, need these privileges:

create user &username identified by &password;
grant connect, resource to &&username;
grant alter any materialized view to &&username;
grant analyze any, create any materialized view to &&username;
grant create procedure, create role, create sequence to &&username;
grant create session, create table, create view to &&username;
grant drop any materialized view, execute any procedure to &&username;
grant global query rewrite to &&username;
grant select any table, unlimited tablespace to &&username;
grant execute on sys.dbms_job to &&username;
grant select on sys.v_$parameter to &&username;

Can you check what was granted to your user and see if any of the above might help?

Best wishes
Michael
Go to the top of the page
 
+Quote Post
balanced
post May 24 2012, 03:57 PM
Post #4


Newbie
*

Group: Members
Posts: 3
Joined: 24-May 12
Member No.: 47,230



Hi,

I thought to write this issue since I have a simliar issue with Oracle 11g running on my local java developers labtop. My case, I believe, I gave myself all privileges, and can connect to my database and do selects from tables. Yet, with a prepared statement in java I am not able to do an insert, all the error messages are resolved and when I do an insert no error occur and no new rows are inserted into tables? I have check everything I can assume to check. So, I need some professional advice about this?

J
Go to the top of the page
 
+Quote Post
michaelasc
post May 24 2012, 04:12 PM
Post #5


Advanced Member
***

Group: Members
Posts: 189
Joined: 5-May 05
From: Cookeville, Tennessee
Member No.: 2,014



Hello
Is your question related to Oracle Discoverer? It looks like you are having trouble with something else.

Michael
Go to the top of the page
 
+Quote Post
balanced
post May 24 2012, 04:25 PM
Post #6


Newbie
*

Group: Members
Posts: 3
Joined: 24-May 12
Member No.: 47,230



QUOTE (michaelasc @ May 24 2012, 05:12 PM) *
Hello
Is your question related to Oracle Discoverer? It looks like you are having trouble with something else.

Michael



No, it is not specific to Oracle Discoverer. It is about Oracle 11g running on my local labtop and java code accessing the tables? I thought it was similar in nature. Did you get my attachement code?

J
Go to the top of the page
 
+Quote Post
burleson
post May 25 2012, 08:51 AM
Post #7


Advanced Member
***

Group: Members
Posts: 11,614
Joined: 26-January 04
Member No.: 13



Hi,

>> is about Oracle 11g running on my local labtop and java code accessing the tables?

Please open a new thread on this!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd October 2014 - 11:29 PM