Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Client connectivity problem
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)
Example of my tnsnames.ora file:
DBNAME.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (Host = server1) (Port = 1111) )
--== 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