OraFAQ Forum: Server Administration » sqlplus error

Home » RDBMS Server » Server Administration » sqlplus error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus error [message #194276]

Thu, 21 September 2006 06:43

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

Report message to a moderator

Re: sqlplus error [message #194307 is a reply to message #194276]

Thu, 21 September 2006 07:58

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

Report message to a moderator

Re: sqlplus error [message #194316 is a reply to message #194276]

Thu, 21 September 2006 08:19

Shamsher
Messages: 18
Registered: September 2006

Junior Member

did u export SID before connecting to sqlplus.

Regards
Shamsheer

Report message to a moderator

Re: sqlplus error [message #194398 is a reply to message #194307]

Fri, 22 September 2006 00:13

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Listener is regitered with the service ,i am trying to connect

Report message to a moderator

Re: sqlplus error [message #194399 is a reply to message #194316]

Fri, 22 September 2006 00:14

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

yes i posted the sid before connecting to database

Report message to a moderator

Previous Topic:	How to change the usernames and passwords
Next Topic:	Where i have see the Errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:27:46 CDT 2024