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

hari_om_at_hotmail.com (Hari Om) wrote in message news:<d1d5ebe4.0210281511.42e671ca_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
> 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!
Mr.Odd is right. Connect is a SQL*PLUS command. You can't go in directly as a sysdba. Do try like this,
Prompt> sqlplus <Enter>
Enter User-name: gauri/khar_at_gaurikits as sysdba.

Then definitely you can connect to the DB as sys.

Thanks Received on Thu Oct 31 2002 - 10:43:53 CET