SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

SQL Navigator
1

Hello,

I have installed Oracle client 11g (not instant) with administrator option in Windows 10. The oracle installation was successful, however when I tried launching SQL Navigator, it threw me an error that it could not find Oracle client.

Please see the attached screenshots.

Please advise.

sql.jpeg

Thanks.5657.error.jpeg

2

Your Oracle Client must match SQL/Nav … 32x or 64x.

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

From: srajaram [mailto:bounce-srajaram@toadworld.com]

Sent: Tuesday, May 9, 2017 1:52 PM

To: sqlnav@toadworld.com

Subject: X-Spam: [SQL Navigator - Discussion Forum] SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

Thread created by srajaram

Hello,

I have installed Oracle client 11g (not instant) with administrator option in Windows 10. The oracle installation was successful, however when I tried launching SQL Navigator, it threw me an error that it could not find Oracle client.

Please see the attached screenshots.

Please advise.

Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator Forum notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

3

It is a 32 bit installation of Oracle and so is SQL Navigator

4

Oracle and SQL Navigator is 32 bit.

5

If you installed the Oracle Client 32x and SQL/Navigator 32x, the SQL Navigator recognize Oracle Home correctly.

Also, you can check TNS_ADMIN

This Computer | Advanced system settings | Environment Variables ..

TNS_ADMIN under [User variables for {YourId} | System variables.

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

From: srajaram [mailto:bounce-srajaram@toadworld.com]

Sent: Tuesday, May 9, 2017 2:09 PM

To: sqlnav@toadworld.com

Subject: RE: [SQL Navigator - Discussion Forum] SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

RE: SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

Reply by srajaram

It is a 32 bit installation.

nam.kim

Your Oracle Client must match SQL/Nav .. 32x or 64x.

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

nam.kim

Your Oracle Client must match SQL/Nav .. 32x or 64x.

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator Forum notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

6

Did you installed Oracle client 32x first… and configured any tns entry?

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

From: srajaram [mailto:bounce-srajaram@toadworld.com]

Sent: Tuesday, May 9, 2017 2:12 PM

To: sqlnav@toadworld.com

Subject: RE: [SQL Navigator - Discussion Forum] SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

RE: SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

Reply by srajaram

Oracle and SQL Navigator is 32 bit.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator Forum notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

7

Thanks for your reply. I don’t have a variable named ‘TNS_ADMIN’ under System variables. Also, I am using ldap.ora file instead of tnsnames.ora file.

Thanks.

8

I do not know about how to using ldap.ora.

In our environment, we have one global TNSNAMES.OAR file in network and DBA control.

All company end user using the global tnanames.ora as default their connection.

            Of course, DBA control the user account and privilege on each database; we are not single sign on.

Good luck… maybe you can get good answer from other DBA who using ldap.ora.

Thanks,

Nam Kim – Oracle DBA. – Data Services

Desk: 209.341.7969 | Cell: 209.605.1151 | mailto:nam.kim@ejgallo.com

From: srajaram [mailto:bounce-srajaram@toadworld.com]

Sent: Tuesday, May 9, 2017 2:23 PM

To: sqlnav@toadworld.com

Subject: RE: [SQL Navigator - Discussion Forum] SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

RE: SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

Reply by srajaram

Thanks for your reply. I don’t have a variable named ‘TNS_ADMIN’ under System variables. Also, I am using ldap.ora file instead of tnsnames.ora file.

Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator Forum notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

9

I think the error at your point, the TNS_ADMIN, tnsnames.ora, ldap.ora are all not relevant.

It appears the error you are getting is Invalid Home (first pic).

Your home indicates that it has the “…/bin” directory as part of the home. Oracle_Home is generally set to the parent directory of “…/bin”.

If you have somehow got this mangled, to where you installed to two separate Oracle_Home directories, this could be causing your error.

I would suggest that you use the Oracle universal installer to de-install both packages, and then install the client using “Administrator” It’s only a little larger than a GB, and you will get SQL Developer and all the client pieces installed with one step.

You can run with two or more Oracle homes, but it does add to the confusion. I have two homes, one for 11.2.0.3 32-bit client and one for 11.2.0.3 64-bit client. TOAD-64 uses the 64-bit client, and SQL Developer (in the 32-bit client home) uses the 32-bit client. Using the “TNS_ADMIN” environment variable allows me to use just one “%ORACLE_HOME/network/admin” directory, so I have one sqlnet.ora, ldap.ora, and tnsnames.ora file for both clients and all Oracle related apps on my system.

10

Sorry- I was confusing SQL Navigator and SQL Developer. However, I still think the main point is the same. Your Oracle_Home indicated in the first dialog indicates the “…/bin” subdirectory, and generally the parent directory of that is the HOME. If the PATH has $ORACLE_HOME/bin in it, and your $ORACLE_HOME is set to \oracle\11.2.0\client\bin, then what is going in your path is : \oracle\11.2.0\client\bin\bin

check your path with from cmd:

echo %PATH%

also check oracle home:

echo %ORACLE_HOME%

11

Hello,

Make sure you have at least one version of Oracle Client installed.

  • First un-install SQL Navigator
  • System reboot
  • Install SQL Navigator
  • Find the location of OCI.dll (Windows+F on XP/7/Vista)
  • Copy that OCI.dll and paste it in your set up folder of SQL NAvigator, most probably “C:\Program Files\Quest Software\SQL Navigator 5.5”
  • You may still get some error like “Can’t initialise OCI.dll-Error 1”. Press OK
  • Also click on OK if any other messages prompt on the screen.
  • Test using connecting to any database you have known.
    Hope this helps, Thanks.