ORA-12154: TNS:could not resolve service name
Date: 28 Oct 2002 15:11:23 -0800
Message-ID: <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:
Where->
My TNSNAMES.ORA file (on client) has following:
GAURIKITS =
ERROR: ORA-12154: TNS:could not resolve service name
Username=gauri
password=khar
SID = 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 - 00:11:23 CET