SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Other Stuff Contact
Andy only 
 
TNS-12541: TNS:no listener

The hostname was valid but the listener was not contactable. Things to check are that the tnsnames has the correct port (and hostname) specified, and that the listener is running on the server and using the correct port.


Related article: Resolving Oracle networking problems.

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