Re: no permissions on tnsnames.ora

From: Frank van Bortel <>
Date: Wed, 04 Jun 2008 09:49:54 +0200
Message-ID: <8b2aa$48464922$524b5c40$>

rgvguplb wrote:

> On Jun 3, 10:22 am, wrote:

>> Hello Guys,
>> Have had a 9.2 client installed by a 3rd party on linux so pull some
>> data of the linux box and squirt it into a remote oracle db. However I
>> dont have permission to alter the tnsnames.ora file cos I dont have
>> the oracle or root password.
>> [user_at_server02 admin]$ ls -l tnsnames.ora
>> -rw-rw-r-- 1 oracle dba 337 Jun 3 13:36 tnsnames.ora
>> So I cannot connect to the remote service.
>> Or can I? Is there a workararound for connecting with sqlplus?
>> Would it be normal to ask the hosting team to alter the client config
>> as and when needed?
>> TIA
>> Kevin
>> ls -l
> Maybe you can try connecting using the username/password_at_host:port/sid
> format (or is that username/password_at_host:port/service format?). one
> or the other. the port bit is optional if it's the default one.

Only if sqlnet.ora contains EZCONNECT as an option


Frank van Bortel
Received on Wed Jun 04 2008 - 02:49:54 CDT

Original text of this message