Toad World® Forums

SQL Nav 7.2 installation problems

Hi

We’ve just received our new pcs and have some troubles installing SQL Navigator >=7.2

These pc run under Win 7, 64 bit.

Installation of v 6.7 (32 bit) have been made without any problems.

Installation of v 7.2 (64 bit) doesn’t find oracle/home, so we tried v 32 bit, and there we’ve this problem :

8473.unnamed.png

Any idea what’s wrong in our installation ?

Regards

Martin

Hi Martin,

I’m afraid you need to install the oracle client/server with 64bit, before you login the SQLNav (64bit).

Regards,

Alan

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

Sent: Thursday, October 29, 2015 5:27 PM

To: sqlnav@toadworld.com

Subject: [SQL Navigator - Discussion Forum] SQL Nav 7.2 installation problems

SQL Nav 7.2 installation problems

Thread created by martin_goblet

Hi

We’ve just received our new pcs and have some troubles installing SQL Navigator >=7.2

These pc run under Win 7, 64 bit.

Installation of v 6.7 (32 bit) have been made without any problems.

Installation of v 7.2 (64 bit) doesn’t find oracle/home, so we tried v 32 bit, and there we’ve this problem :

Any idea what’s wrong in our installation ?

Regards

Martin

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator - General
notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

Hi Alan

I can understand for the 64bit version, but it doesn’t work with the 32 bit too.

SQL + and SQL nav 6.7 work fine.

Regards

Martin

Hi Martin,

Can you show us all Oracle clients (both 32 and 64-bit) that are installed in the new PC? And what clients are picked up in the combo box of SQL Nav logon dialog? You can also click the … button on the right of the combo box to show more info of the clients.

In additional, the following information is helpful:

  1.  Do you have TNS_ADMIN set in system/user environment variables?
    
  2.  Do you have TNS_ADMIN set in registry under each Oracle client? (e.g., HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1: TNS_ADMIN)
    

Lastly, 7.3 beta works better in terms of making connection in complex Oracle client environment. You can have a try if possible.

Thanks,

Vincent

Hi Vincent

From my DBA :

I have only one oracle client installed on my pc .

Below , the logon window in SqlNav 7.2 (32bits) and the message received .

TNS_ADMIN was not set, I added it, no changes

All is ok in version 6.7 (32 bits)

In both version I see this :

Regards

Martin

Hi again

Just dowloaded the new beta version. The DBA was able to install this one. We will work with this one and wait for the commercial release. Big problem if the release runs out and a new beta version is not published before the end date.

Regards

Martin

Hi Alan / Vincent

Our DBA managed to install his pc (after a lot of tries), but on mine, nothing works. We tried version 6.7 and 7.3. We always get the same error then shown above.

Regards

Martin

Hi Martin,

I’m so sorry about your situation, I have tested a few case about SQLNav logon different oracle client in this morning, the version of 7.2 and 7.3beta are work fine.

Could you help me confirm the “tnsnames.ora” file have exist in “ORACLE_HOME\network\admin” ? if you pc have installed a few oracle clients, make sure that each of the clients have contained the tnsnames.ora file.

Regards,

Alan

Hi Alan

I’ve only one oracle client installed. SQL+ works fine, so I’m sure the client work well. It’s in 32 bit

I don’t understand what you mean with the Oracle_home. My tnsnames.ora contains only this type of lines :

D_plda.world =

(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = ip_adress)(Port = port_number)))
(CONNECT_DATA = (SID = dseabird)(GLOBAL_NAME = dseabird.world)(SERVICE_NAME = dseabird)(SERVER = DEDICATED))
)

It is the tnsname.ora file from my old pc where all SQLNavigator version work without any problem.

When I open SQLNavigator, I get this window :

with this detail :

and when I confirm, I get this error :

Regards

Martin

Martin, can you add the following entries to your existing tnsnames.ora (remember to replace the ip_adress with your real ip) and test these new entries from SQLNav logon window?

D_plda_1 =

(DESCRIPTION =

            (ADDRESS_LIST =

                            (ADDRESS =

                                            (PROTOCOL = TCP)

                                            (Host = *ip_adress*)

                                            (Port = 1521)

                            )

            )

            (CONNECT_DATA =

                            (SERVICE_NAME = dseabird)

                            (SERVER = DEDICATED)

            )

)

D_plda_2 =

(DESCRIPTION =

            (ADDRESS_LIST =

                            (ADDRESS =

                                            (PROTOCOL = TCP)

                                            (Host = *ip_adress*)

                                            (Port = 1521)

                            )

            )

            (CONNECT_DATA =

                            (SID = dseabird)

                            (SERVER = DEDICATED)

            )

)

D_plda_3 =

(DESCRIPTION =

            (ADDRESS_LIST =

                            (ADDRESS =

                                            (PROTOCOL = TCP)

                                            (Host = *ip_adress*)

                                            (Port = 1521)

                            )

            )

            (CONNECT_DATA =

                            (SERVICE_NAME = dseabird)

                            (GLOBAL_NAME = dseabird.world)

                            (SERVER = DEDICATED)

            )

)

If none of these work, please modify your sqlnet.ora with following details and try again:

use ‘#’ to comment the existing line and use the line below:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Let me know how it goes.

Thanks,

Vincent

Hi Vincent

Tried all 3 with and without the sqlnet.ora parameter. Same error all the time.

Regards

Martin

Hi Vincent/Alan

Finally found the problem.

If I install SQL Navigator in C:\Program Files… or C:\Program Files (x86)… it doesn’t work. If I install it in C:\Dell… it works perfectly !!!

I’ll wait until my DBA comes back from holiday to verify where he managed to install it.

Regards

Martin