Re: ORA-12154: TNS:could not resolve service name

"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0210281510.190d9c57_at_posting.google.com...
> Hi Experts:
>
> I have installed Oracle DB on my IBM AIX 5.1 Server. On my Client
> machines (which are windows ofcourse!) I have installed Oracle Client.
>
> Later when I start my SQLPLUS and enter following:
> connect gauri/khar_at_gaurikits as sysdba

You're tryng to log on as a privileged user (one who is able to startup, shutdown, backup or recover) remotely. In the first place, that's not a particularly good idea. But, in the second, you might want to look at the remote_os_authent parameter in your db's init.ora. It needs to be true.

Regards
HJR
> I get following error:
> ERROR: ORA-12154: TNS:could not resolve service name
>
> Where->
> Username=gauri
> password=khar
> SID = gaurikits
>
> My TNSNAMES.ORA file (on client) has following:
>
> GAURIKITS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (HOST=my_domain_name)(POSRT=1521)))
> (CONNECT_DATA =
> (SID = gaurikits)
> (SERVER = DEDICATED))
> )
>
> Can anyone tell me how to eliminate that Error? However, when I
> connect with following String, I DO NOT get any Error. It just works
> fine:
> connect gauri/khar_at_gaurikits
>
> THANKS!
Received on Tue Oct 29 2002 - 02:05:03 CST