Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-12541: TNS:no listener....Please Help

 
Aman Gupta
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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 .

Please Help.



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> commit;

Commit complete.

SQL> select * from SYG_SYSTEM_GLOBALS@fsnew10;
select * from SYG_SYSTEM_GLOBALS@fsnew10
*
ERROR at line 1:
ORA-12541: TNS:no listener
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think that you need to use the SERVICE_NAME, that you set up with the network config tool.

The syntax for creation of a database link is:

[ November 26, 2008: Message edited by: Rene Larsen ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic