ORA-12523: TNS:listener could not find instance appropriate for the client connection

[smruti123]

Hi
I login my database as sysdba then I need to shutdown it and restart it,but when I restarted ,received this error message.

SQL> STARTUP
ORACLE instance started.
ORA-12523: TNS:listener could not find instance appropriate for the client connection

any help woluld be appreciated.
Thanks in advance

[Sharma]

Are you trying to start the database on different machine? I mean are you trying to start the database from client machine.

[smruti123]

Thanks sharma for quick response.

both (client as well as server)
Thanks in advance.

[Sharma]

I am not 100% sure about this, but try the following, it should not harm you. I hope someone can give you the exact solution to the problem. In the mean time you can do the following.

I guess the error you are getting is when startup process is registering the database with the listener.
Try to comment it out in the init.ora file and hopefully that should start your database normally. But then you have to register it using lsnrctl.

[smruti123]

Thnaks sharma.
Sorry I need to go in detail.
when I use these command I am able to restart it
I used this at cmp prompt--
Set oracle_sid=
sqlplus /nolog
connect /as sysdba
alter database mount;
alter database open;
and it works but every time I don't want to use this , I need automatic startup after issuing shutdown
Thanks in advance.

[bhattnirav]

Check following :

if you using windows NT/2000
check in registry for ORACLE_HOME
oracle_sid must be defined



if other than windows O/S then which O/S you are using?

[smruti123]

Thanks bhattnirav
I am using windows O/S its Windows 2003.
and oracle_sid is there in registry.
Thanks in advance.

[smruti123]

Thanks to all.
I fixed this error--
ORA-12523: TNS:listener could not find instance appropriate for the client connection
I found an extra bracket) in my listener.ora file, while I was trying to modify listener.ora file. now I am able to startup database after issuing shutdown command.


Thanks for everybody's help.

[montelgw]

For those of you have multiple listeners and different non-default ports (i.e. 1521), you may get this error to when creating a new db with dbca. The workaround is to shutdown non-asm listeners then run the installer. Hope it helps.