ORA - 12514 Could not resolve service name.

Please help!!

Problem:
When I created a service using Net8 Assistant on NT the first time, I was able to create it successfully. Then I deleted it and created another. Thereafter, all the other services that I've tried to created gave me this error msg.

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.

When I attempt to connect to the database, this error shows up.

SVRMGR> connect internal/oracle@oratest
ORA-12154: TNS:could not resolve service name

The paths for listener.ora, tnsnames.ora, and sqlnet.ora are correct and none of them have duplicates exist.

Does anyone know why? Any help is greatly appreciate!

Check the service name . Whether it is oratest or oratest.world

I am trying to connect to a second database called ORATEST. Should this name be the same as the service name?

I am using test8 as the service_name. Do I go to sqlnet.ora to verify ".world" exists or not? I am so new to this. Thanks for all the help!

Quote:

---

Originally posted by oraka6
Please help!!

Problem:
When I created a service using Net8 Assistant on NT the first time, I was able to create it successfully. Then I deleted it and created another. Thereafter, all the other services that I've tried to created gave me this error msg.

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.

When I attempt to connect to the database, this error shows up.

SVRMGR> connect internal/oracle@oratest
ORA-12154: TNS:could not resolve service name

The paths for listener.ora, tnsnames.ora, and sqlnet.ora are correct and none of them have duplicates exist.

Does anyone know why? Any help is greatly appreciate!

---

Hi
It is not recognising the sevice name...
ensure that sevice name, Sid(datrabase) host(server) and global_name (SID.world) are correct.If not correct it.Retry it will not throw error.
Thanks.
thanigaivasan

try changing Service_name to SID in your TNSnames.ora file to your SID, it should work

bye