How did I even get into this ?
I just happen restart my web server which is connected to oracle 10g many time. Suddently this issue came out.
But how to get out ?
If you try to look for this solution over the web you would certainly have many suggestion among them, the most common is:
Do this.
Check the listener status:
cmd> set oracle_sid = yourSid
cmd> lsnrctl status
If it is successful withou any error, your half blessed.
Stop all programs currently running in your PC, and RESTART IT
Then after restarting:
cmd> set oracle_sid = yourSid
cmd> sqlplus /nolog
sql> connect username/password@yourSid
Congratulation you should now be in...otherwise throw me some comments.
I just happen restart my web server which is connected to oracle 10g many time. Suddently this issue came out.
But how to get out ?
If you try to look for this solution over the web you would certainly have many suggestion among them, the most common is:
But please don't turn everything upside down. Cool down and especially don't change any thing.
- Check if a database instance up and running
- Check the output of the
lsnrctl servicecommand and see what services are registered.- Check if you has
SERVICE_NAMEcorrectly specified when connecting to the instance.- If it happens that database instance stared before listener did sometimes you just need to wait a little or you can execute
alter system registerin order to register the instance.
Do this.
Check the listener status:
cmd> set oracle_sid = yourSid
cmd> lsnrctl status
If it is successful withou any error, your half blessed.
Stop all programs currently running in your PC, and RESTART IT
Then after restarting:
cmd> set oracle_sid = yourSid
cmd> sqlplus /nolog
sql> connect username/password@yourSid
Congratulation you should now be in...otherwise throw me some comments.
No comments:
Post a Comment