I have 2 databases on different machines - ORCL on 172.21.161.107 and scmb10g on 172.21.161.60. I tried to create a database link from ORCL on 172.21.161.107 to scmb10g on 172.21.161.60. The public db link is created successfully....but while trying to access it, I'm getting foll error .
SQL> create public database link fsnew10 connect to onsitedba identified by onsitedba using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.161.60)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCMB10g) ) )';
Database link created.
SQL> select * from SYG_SYSTEM_GLOBALS@fsnew10; select * from SYG_SYSTEM_GLOBALS@fsnew10 * ERROR at line 1: ORA-12541: TNS:no listener