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
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
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:
Do you have TNS_ADMIN set in system/user environment variables?
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:
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