| tns 12154 could not resolve the service name [message #57911] |
Fri, 18 July 2003 05:42  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
i am getting an error message when i trying to connect thru a client machine to server.but i am gettin an error meessage
tns 12154 Tns couldnot resolve the service name
i am able to connect with client(sqlplus) in server
but unable to connect with another client on diffrent machine
my listener entries are
List1=
(address=(protocol=tcp)(host=indiaoption)(port=1521))
sid_list_List1=
(SID_LIST=
(sid_desc=
(sid_name=india))
and tnsnetries are
india =
(description=
(Address_list=
(Address =
(protocol=tcp)(host=indiaoption)(port=1521)))
(connect_data =
(service_name=india))
)
client tns have same entries for tns
why this iam able to ping
|
|
|
|
|
|
| Re: tns 12154 could not resolve the service name [message #57913 is a reply to message #57912] |
Fri, 18 July 2003 08:43  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
if the listener is running and supporting the database LIST1, make sure that the settings in your local tnsnames.ora match those of the listener.
lsnrctl status LIST1 - run from the db server may be helpful.
The local tnsnames.ora may have hidden control characters in it, or syntax errors which are preventing the oracle client from reading the file correctly. Often the brackets will get you.
Thats the most common issue.
Remedy - copy one from a computer that does connect correctly - confirm that all is well by running
tnsping LIST1
should return
ok (nnn msec)
Have fun!
|
|
|
|
| Re: tns 03505 erroe [message #57929 is a reply to message #57913] |
Sun, 20 July 2003 07:25 |
Raj Mathur
Messages: 11
Registered: April 2002
|
Junior Member |
|
|
when i using tnsping L1 i am getting this error but in listener staus using lsnrctl status L1
its working corectly
TNS-03505: Failed to resolve name
these r the entries in tnsnames.ora and listener.ora
raj =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(host =raj)(port = 1521))
(CONNECT_DATA = (SID = raj)))
Listener.ora
L1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = raj)(PORT = 1521))
SID_LIST_L1 =
(SID_List=
(SID_DESC =
(SID_NAME = raj)))
|
|
|
|
| Re: tns 12154 could not resolve the service name [message #62233 is a reply to message #57911] |
Tue, 06 July 2004 08:06 |
Shalini Ramachandran K
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
Re: tns 12154 could not resolve the service name
OS : win 2000 server, hope this will work with all OS
Install your Oracle8i then Oracle Developer 2000.
then copy tnsnames and listener file from Ora81.
paste them in orant/net80/admin. before pasting delete ur tnsnames and listener (notepad) files in orant/net80/admin folder. then in sqlnet.txt edit the statment and set directory path = (tnsnames, hostname) to
(tnsnames,"UR COMPUTER NAME")
delete
tnsnames and listener from orant/net80/tnsapi. replace with above(oracle tnsname and listener)
all the best.
Now u can work using any common oracle logins with ur database name.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
