Re: database link

Posted by Roshan on Jul 18, 2017; 11:39am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/database-link-tp2964p2985.html

Thanks for update.

I checked the link.

I have setup intermediate database as 10g. I have created the database link which points source(9i) to 10g database.

select * from dual@abcd
                   *
ERROR at line 1:
ORA-12537: TNS:connection closed

I am able to tnsping the intermediate DB.

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.29.228)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PMTCC01)))
OK (0 msec)