Re: Tnsnames.ora - Strange Connectivity problem

Hi,

There are no duplicate tnsnames.ora files on any disk (I have searched). The tns file is also in the correct location (see below). Also, I tried making the changes to the tnsnames.ora file (i.e. changingh service name to SID) but again no success.

Thanks for the assistance

-bash-2.05b$ echo $TNS_ADMIN

/u01/oracle/ora92/network/admin

OUTPUT FROM TNSPING

TNS Ping Utility for Linux: Version 9.2.0.7.0 - Production on 04-MAY-2006 07:06:49 Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias  )CONNECT_DATA = (SERVICE_NAME = oranc1.osg.com))(PORT = 1521)) OK (190 msec) Received on Thu May 04 2006 - 05:07:00 CDT