Home » RDBMS Server » Networking and Gateways » TNS Listner
TNS Listner [message #326294] Wed, 11 June 2008 00:12 Go to next message
Messages: 29
Registered: May 2008
Junior Member
Hi all,

when i try to connect my oracle 9i in windows platform,
it gives me error as:--

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

I really don't know what is the exact problem behind this.

Please help me.
Thanks in advance
Re: TNS Listner [message #326301 is a reply to message #326294] Wed, 11 June 2008 00:39 Go to previous message
Michel Cadot
Messages: 61966
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12523: TNS:listener could not find instance appropriate for the client connection
 *Cause:  The listener could not find any available (database) instances,
 that are appropriate for the client connection.
 *Action: Run "lsnrctl services" to ensure that the instance(s) are
 registered with the listener, and have status READY.

Previous Topic: descriptor not valid
Next Topic: SQL plus connecting proble Oracle 9i
Goto Forum:

Current Time: Tue Oct 13 07:28:08 CDT 2015

Total time taken to generate the page: 0.11735 seconds