Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
    Bookmark Topic Watch Topic
  • New Topic

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

 
Aman Gupta
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • 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
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
Aman,

Please do not post the same question in multiple forums http://www.coderanch.com/t/415549/JDBC/java/ORA-TNS-no-listener-Please
 
    Bookmark Topic Watch Topic
  • New Topic