Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    16

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

    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 .

    Pls 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

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    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.
    PHP Code:
    CREATE DATABASE LINK fsnew10
     CONNECT TO onsitedba 
     IDENTIFIED BY onsitedba 
     USING 
    'scmb10g'
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •