11-26-08, 01:33 #1Registered User
- Join Date
- Nov 2008
Unanswered: ORA-12541: TNS:no listener.....Please Help
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
11-26-08, 12:34 #2Registered User
- Join Date
- Jul 2003
setup your tnsnames.ora file on each server.
verify you can sqlplus connect to each database from each server.
once done then just use the alias for each dblink.
CREATE DATABASE LINK fsnew10
CONNECT TO onsitedba
IDENTIFIED BY onsitedba
you can lead someone to something but they will never learn anything ...