ORA-12505: TNS:listener could not resolve SID given

[l-ellison]

Using Oracle 8.0.5 in Windows 2000 Server.

I created a DB, and I check it correctly by using SQL*Plus with my user/password.

But I've got a problem when trying to create a service.

I modified LISTENER.ORA, adding:
(ADDRESS = (PROTOCOL = IPC)(KEY = MY_SID))
and
(SID_DESC = (SID_NAME = MY_SID))

I modified TNSNAMES.ORA, adding:
MY_SERV.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = MY_SID))
)

But when trying to connect this service (for instance, using 'TORA' or testing with 'Oracle Net8 Easy Config') I get this error message:
******
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
******

If I type in MSDOS, I get
> echo %ORACLE_SID%
MY_SID

And I'm able to connect via SQL*Plus... what am I doing wrong?

Any suggestion is apreciated. Regards and thank you very much.

[aarroyob]

Look for all the tnsnames.ora in your machine and add the entry for your db.

If you have only one tnsnames.ora, probably you have to check your NAMES.DEFAULT_DOMAIN = world parameter in the sqlnet.ora same as you put on your tnsnames.ora.

Do you understand?

Hope that helps

Angel

[l-ellison]

Thank you, aarroyob, for answering.

I've just checked my TNSNAMES.ORA and it was included:

MY_SERVICE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = MY_SID))
)

And I also checked my SQLNET.ORA and it includes:

names.default_domain = world

The name of my SID is MY_SID and the service is MY_SERVICE. I'm able to connect it via SQL*Plus, but it's impossible to connect it as a service.

[anandharaj]

Hi,

As per my understanding, If you have one more TNSNAME.ORA in C:\ root directory, Oracle will try to refer this TNANAME file everytime...Not in Oracle_home\Network directory.

So, Please check you have only one TNSNAMES.ORA in ORACLE_HOME\network Directory. If you have any more, please delete it and try out.

[sambavan]

Insted of SID change that to SERVICE_NAME = MY_SERVICE and try. Also make sure that you have this change in all the tnsnames.ora files.

Sam