Discoverer Desktop Issues Options

[mstarks]

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

[burleson]

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

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;

[michaelasc]

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 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

[balanced]

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

[michaelasc]

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

Michael

[balanced]

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

[burleson]

Hi,

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

Please open a new thread on this!