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

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


    I have 2 databases on different machines - ORCL on and scmb10g on
    I tried to create a database link from ORCL on to scmb10g on
    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 = = 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
    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:
     CONNECT TO onsitedba 
     IDENTIFIED BY onsitedba 
    - 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