ORA-12154: TNS:could not resolve service name

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sheela
    #1

    ORA-12154: TNS:could not resolve service name

    I am trying to access the tables of a remote database(db2) from db1
    database. I am getting the following error: ORA-12154: TNS:could not
    resolve service name
    I tried tnsping the db2 service_name and it is working.


    I created a dblink like this at db1.


    CREATE DATABASE LINK db2.oracle.com
    CONNECT TO scott IDENTIFIED BY tiger
    USING 'db2servicename ';



    When I will tried to access the db2 database tables from db1, I am
    getting the above error.

    sqlselect sysdate from dual@db2.oracle .com ( from db1)
    ORA-12154: TNS:could not resolve service name

    The TNSNAMEs.ora file looks like this.

    db2.oracle.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 85))
    )
    (CONNECT_DATA =
    (SID = db2)
    (SERVER = DEDICATED)
    (SERVICE_NAME = db2servicename)

    Do I need to add anything else in the tnsnames.ora file?
    Tags: None
    • Jan
      #2
      Re: ORA-12154: TNS:could not resolve service name

      An entry for the 2-nd database has to be in the tnsnames.ora ON THE SERVER.

      Jan

      spathiyal@yahoo .ca (Sheela) wrote in message news:<678ae5f9. 0408160905.7e0a ac46@posting.go ogle.com>...
      I am trying to access the tables of a remote database(db2) from db1
      database. I am getting the following error: ORA-12154: TNS:could not
      resolve service name
      I tried tnsping the db2 service_name and it is working.
      >
      >
      I created a dblink like this at db1.
      >
      >
      CREATE DATABASE LINK db2.oracle.com
      CONNECT TO scott IDENTIFIED BY tiger
      USING 'db2servicename ';
      >
      >
      >
      When I will tried to access the db2 database tables from db1, I am
      getting the above error.
      >
      sqlselect sysdate from dual@db2.oracle .com ( from db1)
      ORA-12154: TNS:could not resolve service name
      >
      The TNSNAMEs.ora file looks like this.
      >
      db2.oracle.com =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 85))
      )
      (CONNECT_DATA =
      (SID = db2)
      (SERVER = DEDICATED)
      (SERVICE_NAME = db2servicename)
      >
      Do I need to add anything else in the tnsnames.ora file?

        Comment

        • sybrandb@yahoo.com
          #3
          Re: ORA-12154: TNS:could not resolve service name

          spathiyal@yahoo .ca (Sheela) wrote in message news:<678ae5f9. 0408160905.7e0a ac46@posting.go ogle.com>...
          I am trying to access the tables of a remote database(db2) from db1
          database. I am getting the following error: ORA-12154: TNS:could not
          resolve service name
          I tried tnsping the db2 service_name and it is working.
          >
          >
          I created a dblink like this at db1.
          >
          >
          CREATE DATABASE LINK db2.oracle.com
          CONNECT TO scott IDENTIFIED BY tiger
          USING 'db2servicename ';
          >
          >
          >
          When I will tried to access the db2 database tables from db1, I am
          getting the above error.
          >
          sqlselect sysdate from dual@db2.oracle .com ( from db1)
          ORA-12154: TNS:could not resolve service name
          >
          The TNSNAMEs.ora file looks like this.
          >
          db2.oracle.com =
          (DESCRIPTION =
          (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 85))
          )
          (CONNECT_DATA =
          (SID = db2)
          (SERVER = DEDICATED)
          (SERVICE_NAME = db2servicename)
          >
          Do I need to add anything else in the tnsnames.ora file?

          The tnsnames.ora *on the database server* must list the remote database.
          Database links are from server to server.

          Sybrand Bakker
          Senior Oracle DBA

            Comment

            Previous template Next
            Working...