tns Problem

[sujalgarevar512]

I am getting this "ORA -12154:TNS COULD NOT RESOLVE SERVICE NAME " ERROR WHEN I TRY TO LOGON USING PL/SQL DEVELOPER.I AM HAVING THE FOLLOWING ENTRIES IN MY TNSNAMES.ORA FILE:
stl_dr =
(DESCRIPTION=
(ADDRESS_LIST=

(ADDRESS=(PROTO COL=TCP)(HOST=m yhost)(PORT=152 1))
)
(CONNECT_DATA=
(SID=dr)(SRVR=D EDICATED)
)
)
The database I amtrying to connect is dr..

[frozenmist]

hI,
did you give
stl_dr
as connection string?

Please check it and reply.

Cheers

[jsmithstl]

Check the NAMES.DEFAULT_D OMAIN in your sqlnet.ora file. If for instance in the sqlnet.ora file you have:

NAMES.DEFAULT_D OMAIN= corp.company.co m

Then your tnsnames.ora entry should look like:

stl_dr.corp.com pany.com = ...

Additionally, I'm pretty certain Oracle recommends you use SERVICE_NAME instead of SID in the tnsnames.ora entry for 9i and up.

If you'll go to the command prompt and type:

lsnrctl services[listener name]

look for "service dr.corp.company .com has one instance" then you set the SERVICE_NAME parameter in tnsnames.ora to that value.

SERVICE_NAME = dr.corp.company .com