Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Client connectivity problem

Oracle Client connectivity problem

From: <amary_at_ncs.com.sg>
Date: Thu, 27 May 1999 14:06:27 GMT
Message-ID: <7ijjh0$m91$1@nnrp1.deja.com>


dOES ANYONE KNOWS THE FOLLOWING ERROR MESSAGE? I can ping * tnsping from my client side and I would sqlplus system/manager from my server end. However if I used sqlplus system/manager_at_dbname.world I'm unable to access the database from the server end.

Please provide some pointers.

Thanks

SQL*Plus: Release 3.3.4.0.0 - Production on Thu May 27 21:53:35 1999

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Enter user-name:

Example of my listener.file
LISTRITA =
(ADDRESS_LIST =

        (ADDRESS= (PROTOCOL= TCP)(Host= server1)(Port= 1111))   )
SID_LIST_LISTENER =
(SID_LIST =

    (SID_DESC =

      (ORACLE_HOME= /oracle01/oracle73/app/oracle/product/7.3.4)
      (SID_NAME = DBNAME)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
~
~

Example of my tnsnames.ora file:

DBNAME.world =
(DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = server1)
          (Port = 1111)
        )

    )
    (CONNECT_DATA =
       (SID = DBNAME)
    )
  )

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 27 1999 - 09:06:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US