Re: no permissions on tnsnames.ora
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 04 Jun 2008 09:49:54 +0200
Message-ID: <8b2aa$48464922$524b5c40$25250@cache2.tilbu1.nb.home.nl>
>> 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
Date: Wed, 04 Jun 2008 09:49:54 +0200
Message-ID: <8b2aa$48464922$524b5c40$25250@cache2.tilbu1.nb.home.nl>
rgvguplb wrote:
> On Jun 3, 10:22 am, kbloomfi..._at_yahoo.com 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
-- Regards, Frank van BortelReceived on Wed Jun 04 2008 - 02:49:54 CDT