Re: Tnsnames.ora - Strange Connectivity problem

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 3 May 2006 08:32:17 -0700
Message-ID: <1146670337.848592.99520@y43g2000cwc.googlegroups.com>

Hi,

I'm connecting to a remote instance called oranc1 using sqlplus as below (enter password manually).

sqlplus osgdba_at_oranc1

The tns entries for oranc1 are below (2 entries - one includes the global name). They are in network/admin as per default and worked prior to applying patch.

ORANC1 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ncluxora1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.191.10.61)(PORT = 1521))

    )
(CONNECT_DATA = (SERVICE_NAME = oranc1.osg.com))
  )

ORANC1.OSG.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ncluxora1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.191.10.61)(PORT = 1521))

    )
(CONNECT_DATA = (SERVICE_NAME = oranc1.osg.com))
  )

There is actually no sqlnet.ora file specified although I did try tinkering on with a few test values.

Thanks

OUTPUT from connecting :-

-bash-2.05b$ sqlplus osgdba_at_oranc1

SQL*Plus: Release 9.2.0.7.0 - Production on Wed May 3 12:35:06 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name Received on Wed May 03 2006 - 10:32:17 CDT