ORA-12523: TNS:listener could not find instance appropriate for the client connection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

Hybrid View

  1. #1
    Join Date
    Apr 2006
    Posts
    24

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

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Are you trying to start the database on different machine? I mean are you trying to start the database from client machine.

  3. #3
    Join Date
    Apr 2006
    Posts
    24
    Thanks sharma for quick response.

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

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    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.

  5. #5
    Join Date
    Apr 2006
    Posts
    24
    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.

  6. #6
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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?

  7. #7
    Join Date
    Apr 2006
    Posts
    24
    Thanks bhattnirav
    I am using windows O/S its Windows 2003.
    and oracle_sid is there in registry.
    Thanks in advance.

  8. #8
    Join Date
    Apr 2006
    Posts
    24
    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.

  9. #9
    Join Date
    Mar 2011
    Posts
    1

    another cause of this

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width