Hi, I have a somewhat "special" tnslistener file. Here it is:
SIS_SC1=
(DESCRIPTION =
(SOURCE_ROUTE = YES)
(ADDRESS =
(PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1620)
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sistest-db02.prod.umit.dk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SC1)
)
)
The special thing is the SOURCE_ROUTE tag I guess? I can connect to this via sqlplus using sqlplus USER/PASS@sis_sc1. But if I try to connect to either off the ip's it doesnt work: sqlplus USER/PASS@193.162.253.211:1620/SC1, or sqlplus USER/PASS@sistest-db02.prod.umit.dk:1521/SC1.
In SQL Developer, I have tried using the TNS connection. Doesnt work. And I tried using the ip's. Doesnt work.
A colleage can connect using toad. Is there something in that TNS, that sql developer cant find out how to use?
Any idea what to do?