Home » RDBMS Server » Server Administration » sqlplus error
sqlplus error [message #194276] Thu, 21 September 2006 06:43 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
SQL> connect sys/gateway@ncl.nctex.com as sysdba
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection

Listener is up and running
OracleServer is running
Tnsnames have configured with appropriate services

Can anybody help me in this regard
Thanks in advance
Re: sqlplus error [message #194307 is a reply to message #194276] Thu, 21 September 2006 07:58 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Make sure you have services configured in listener and they have correct name.
lsnrctl status

Sandeep
Re: sqlplus error [message #194316 is a reply to message #194276] Thu, 21 September 2006 08:19 Go to previous messageGo to next message
Shamsher
Messages: 18
Registered: September 2006
Junior Member
did u export SID before connecting to sqlplus.


Regards
Shamsheer
Re: sqlplus error [message #194398 is a reply to message #194307] Fri, 22 September 2006 00:13 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Listener is regitered with the service ,i am trying to connect
Re: sqlplus error [message #194399 is a reply to message #194316] Fri, 22 September 2006 00:14 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
yes i posted the sid before connecting to database
Previous Topic: How to change the usernames and passwords
Next Topic: Where i have see the Errors
Goto Forum:
  


Current Time: Mon Dec 05 05:05:22 CST 2016

Total time taken to generate the page: 0.11075 seconds