DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Problems With DATABASE LINK

  1. #1
    Join Date
    Aug 2001
    Posts
    15
    Hi,

    I'm facing problems whith DATABASE LINK.

    Check following files if there is any problems.

    File : listener.ora
    *******************
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    # )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /data1/oracle)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = condb)
    (ORACLE_HOME = /data1/oracle)
    (SID_NAME = condb)
    )
    )

    File: tnsnames.ora
    ******************

    remote_service_name =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = condb)
    )
    )
    ________________________________________________________________

    $ tnsping remote_service_name

    TNS Ping Utility for Solaris: Version 8.1.6.0.0 - Production on 02-AUG-2001 20:17:25

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.6)(PORT=1521)) OK (80 msec)

    ------------------------------------------------------

    $ trcroute remote_service_name

    Trace Route Utility for Solaris: Version 8.1.6.0.0 - Production on 02-AUG-2001 22:06:20

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Route of TrcRoute:
    ------------------

    Node: Client Time and address of entry into node:
    -------------------------------------------------------------
    02-AUG-2001 22:06:20 ADDRESS= PROTOCOL=TCP HOST=0.0.0.0 PORT=1521

    Node: Server Time and address of entry into node:
    -------------------------------------------------------------
    02-AUG-2001 22:06:21

    REMOTE DATABASE NAME : condb
    LOCAL DATABASE NAME : condb


    $ sqlplus username/password

    SQL> create public database link remote_link
    2 connect to username identified by password
    3 using 'remote_service_name';

    Database link created.

    SQL> select count(*)from emp@remote_link;
    select count(*)from bd_list_fplist@remote_link
    *
    ERROR at line 1:
    ORA-12154: TNS:could not resolve service name

    I tried with following also

    SQL> create public database link condb
    2 connect to username identified by password
    3 using 'remote_service_name';
    connect to username identified by password
    *
    ERROR at line 2:
    ORA-02082: a loopback database link must have a connection qualifier


    Please tellme me what is the exact problem, code and limitations.

    Thanks,

    Nilopher.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    can you:
    $ sqlplus username/password@condb
    from the SERVER?
    Jeff Hunter

  3. #3
    Join Date
    Dec 2000
    Posts
    138
    We faced some problem when the database was in NT and the other in Sun and the db_domain were different, metalink provided with some documents which of course were not of much help and we dropped the db link, and used table level exp with where clause and imported.
    I'm not sure if u are facing the same problem, check with the db_domain in initSID.ora in both systems and sqlnet.ora from where you are trying to access from.


    If u search metalink for 19307.1 they have explaind the problems clearly.

    HTH
    -Dharma

Posting Permissions

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


Click Here to Expand Forum to Full Width