Re: no permissions on tnsnames.ora

From: Frank van Bortel <>
Date: Wed, 04 Jun 2008 09:52:20 +0200
Message-ID: <5f221$484649b4$524b5c40$> 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?
> Kevin

Anyone which is member of the oradba group can alter this file Besides, should we interpret this a "the 3rd party did a lousy job"?

Maybe it's for the best you were not given the oracle password


Frank van Bortel
Received on Wed Jun 04 2008 - 02:52:20 CDT

Original text of this message