I found something like that,it looks like sqlnav is loosing connection while sql is using invalid dblink. Error occurs only when tns exists and representing database wich is down.
Here are the steps to reproduce this situation:
Lets add virtual database into tnsnames.ora:
–add this into tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST_HOST)(PORT = 1521))
(SERVICE_NAME = TEST)
Create DBLINK using this database connection:
—then create dblink
CREATE DATABASE LINK TEST_LINK
CONNECT TO A IDENTIFIED BY A
3. Try execute this sql:
select sysdate from dual@TEST_LINK
Afther that reconnect dialog is showed, but why? When you choose “not recconnect” your session is gone. Correct error message is showed afther reconnect.
Try execute following in sqlplus, here everything works fine.
Jaime I tasted FOSTERS beer - not too bad