Re: Instance creation problem on Windows NT server

Judy Munn wrote:
>
> I have created a second instance on our Windows NT server. The instance
> manager shows that the instance is up. I have created a database alias for
> the instance using SQLNet easy configuration but when I try to login to the
> server using the database alias name in the service box, I get the error:
>
> ORA-12505: TNS:listener could not resolve SID given in connect descriptor.
>
> HELP!
Well I'm no expert as SQL*Net usually manages to catch me out too ;-), but I suggest you try the following:   1 Issue lsnrctl status - to see what the listener thinks it is doing.   2 Have a look in the log (you'll find out where it is in the output from step 1)   3 Check your entries in listener.ora and tnsnames.ora - maybe post them here if you can't see anything wrong.     Not sure if case may be a problem.
One other piece of advice - I don't know if it is the same as in Unix, but Solaris for example uses a hidden file (.tnsnames.ora) in $ORACLE_HOME/network/admin if it finds it. Check you have no hidden files with the same names (perhaps one of the Oracle NT sages who frequent this room can help out on this one). If you still can't get it to work, suggest you post listener.ora and tnsnames.ora here - maybe someone will spot something.
Hope this helps...regards...Richard

-- 
   \|||/
   (. .)
ooO-(_)-Ooo--------------------------------------------
   Name:   Richard Fisher    | Specialist MSE
   E-mail Address            | Richard_Fisher_at_amdahl.com
===========================================================
 Any opinions expressed above are mine and do not necessarily
 represent the  opinions or policies  of Amdahl Corporation
===========================================================
My opinions may have changed, but not the fact that I'm right! 
___________________________________________________________