At the server machine, it is not necessary to specify service name when
using
sqpplus. Oracle uses the Bequeath (local database) protocals when connecting
locally.
amary_at_ncs.com.sg wrote in message <7ijjh0$m91$1_at_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 - 12:18:14 CDT
