Re: Oracle Client connectivity problem

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 27 May 1999 08:25:17 -0700
Message-ID: <374D63DD.C6BE96DB@us.oracle.com>

If your second example is connecting from the server via a loopback mechanism (i.e. you're on the server that contains dbname.world, then the problem is simply that the tnsnames.ora file on the server is either missing altogether, or doesn't have the dbname.world connect string defined, or doesn't have it defined properly.

HTH. Pete

amary_at_ncs.com.sg wrote:

> 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.---

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Thu May 27 1999 - 10:25:17 CDT