Re: no permissions on tnsnames.ora
Date: Tue, 3 Jun 2008 17:47:45 -0700 (PDT)
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?
> 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. Received on Tue Jun 03 2008 - 19:47:45 CDT