When trying to login SQL*Nav5.5, get msg "Not connected to @DB reconnect?"

SQL Navigator
1

CLCS_UAT.world =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = clcs-uat-db-vip.na.gmacfs.com)(PORT = 1521))

)

(CONNECT_DATA =

(SID = CLCS_UAT)

)

)

Help please!

I am trying to login to SQL*Navigator 5.5 and get the message “Not connected to @DB reconnect?”.

I was able to connect via SQL*PLUS w/o any issues using the same TNSNAMES.

See below the TNSNAMES ennrty

2

Hello,

If you’re using multiple oracle homes (multiple versions of the oracle client software), you might want to check that the one used by SQL*Plus (the one it finds first in the path) is the same as the one used by SQL Navigator - you can find the latter at the top of the login dialog.

3

I tried, doing that and still the same error. If fact I am unable to use with our new client, I was using SQl Nav successfully with another client.

Thanks a lot for your suggestion!

Sree

4

What client and database version(s) are we talking about anyway?
There are some combinations that are not supported by Oracle - and most of those just do not work!

5

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Thanks

Sree

6

Hi Sree,

Connecting to 10G DB using 10G client should work. Did you use the Oracle logon or did you run a statement to connect?

Gwen

7

I have used the Oracle logon …

Thanks
Sree

8

I wouldn’t have a clue then. We never have problem with this combination. Maybe you can try uninstall, clear the environment and reinstall.

Gwen

9

(see below)

BTW: is there a way to remove a post - or attach images/files after posting? AFAICS, I can only edit the text now.

10

Hello,

Could your provide us with a screenshot as I attached? You can get the Oracle Home Editor dialog by pressing the button labeled "..." to the right of the "Oracle Home/Client" field in the login dialog. It will focus on the selected client.

B51_01.png
B51_01.png876×460 16.4 KB