Issues with Oracle 9i Client

[asingh]

We have had PL/SQL Developer for a while now and it has been woring fine with our Oracle 7.3.4 databases. A user recently installed the Oracle 9i client on her system in preparation for an upgrade of the database to Oracle 9i and PL/SQL Developer would not let her connect to the database. We thought it might have been a problem with the Oracle Home setting which was not set to 'Oracle9i_Home'. We tried changing this to 'Default_Home' which a few users had, as well as checking the 'Force OCI7 mode on OCI8' check box. This allowed her to log in to the database however she could not see any objects.

Can anyone suggest how to get around this problem by changing the settings? Or do we need a patch of some sort for the application?

Thanks
Alvin

 

[Marco Kalter]

I don't think that the fact that the user cannot see any objects is related to the client version. Unless Oracle Net is connecting to a different database than you expected.

If you do not see any objects, then either:

1. You are using the wrong Oracle account (user or database).
2. You have set a Browser Filter that filters all objects.

Could any of this apply?

As for the 9i client: I can only assume that the aliases have not yet been configured. It depends on the actual error message of course.

------------------
Marco Kalter
Allround Automations

 

[asingh]

I do not think that the Oracle client has any problem. This is because other users who have the client can connect to it fine. Even the user who is having problems with it is able to connect to the database from other PCs.

It seems there is something in her settings which are not allowing her to connect. Even though the program appears to have let her in, our Oracle DBAs have confirmed that she has not made a connection. We have tried copying the exact settings from other users to her copy of the program however that does not seem to have helped. Since she is connecting to an Oracle 7 database, the DBAs have confirmed that the force OCI7 mode on OCI8 should be checked.

Our last option at this stage is to try and re-install the application and hope that it configures itself correctly.

 

[rbrooker]

try deleting the registry entries. this will force plsql developer to create new ones using the default settings...

HKEY_CURRENT_USER\Software\Allround Automations

------------------
richard.brooker@vuw.ac.nz

[This message has been edited by rbrooker (edited 16 April 2003).]

 

[asingh]

I have tried this prior to re-installing. I deleted all entries for PL-SQL Developer from the registry to ensure it is a 'clean' install.

The problem persisted after re-installation.

 

[Marco Kalter]

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and send this text to me by e-mail?

------------------
Marco Kalter
Allround Automations

 

[asingh]

Well the problem is solved. It seems that somehow, the registry settings for Oracle 7 and Oracle 8 had been deleted from the user's computer hence the application was unable to pick up the default Oracle home. Only Oracle 9 was still showing.

We simply copied the registry from another user and imported it into this user's PC and the problem was solved. Now the mystery is how these entries got deleted... curioser and curioser.

Thanks for all your help Marco and Richard!