Database

Can’t Start Oracle Listener

Someone on indo-oracle mailing list ask why he/she can’t start his/her listener

LSNRCTL> START
Starting /oracle/app/oracle/product/920/bin/tnslsnr: please wait…

TNSLSNR for HPUX: Version 9.2.0.6.0 – Production
System parameter file is /oracle/app/oracle/product/920/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/920/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.177.6.32)(PORT=1521)))
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.177.6.32)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
HPUX Error: 13: Permission denied

Listener failed to start. See the error message(s) above…

For problem like this you may do several step below to solve the problem
– Check whether you use correct user or not.
– Check whether $ORACLE_HOME and others environment variable has been set or not ?
– Check whether there is TCP.VALIDNODE_CHECKING=YES on sqlnet.ora or not ?
If your sqlnet.ora contain TCP.VALIDNODE_CHECKING=YES, you can unset it or configure the TCP.INVITED_NODES list to include the ip address or hostname of the server where the listener is failing to start.

Advertisements

Discussion

No comments yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Archives

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

%d bloggers like this: