SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Other Stuff Contact
Andy only 
 
ORA-12505: TNS:listener does not currently know of SID given in connect

Either the SID is misspelled in the tnsnames, or the listener isn't listening for it. Check the tnsnames.ora first. If it looks ok, do a 'lsnrctl status' on your server, to see what databases the listener is listening for.


Related article: Resolving Oracle networking problems.

For more useful DBA queries click here.
Copyright© 2007-2012 Andrew Barry