Troubleshoot and fix TNS-12560 TNS-00583: Valid node checking: unable to parse configuration parameters

Error description: Getting the following error message during the listener startup
LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 15-JUL-2011 10:32:37

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Starting /data/oracle/product/11.1.0/bin/tnslsnr: please wait...


TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
System parameter file is /data/oracle/product/11.1.0/network/admin/listener.ora
Log messages written to /data/oracle/diag/tnslsnr/prodserv/listener_prmrdev/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=prodservdata.edc.diamond.net)(PORT=1522)(QUEUESIZE=300))
TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters
Problem Description:
1.   Oracle listener.ora or sqlnet.ora file contains special characters
2.   Oracle Listener.ora or sqlnet.ora file are in wrong format or syntax
3.   Oracle listener.ora or sqlnet.ora file have some left justified parenthesis which are not accepted by oracle parser.
Have a look at these files and check the proper syntax. If possible remove/rename sqlnet.ora and try to restart the listener. Or remove/rename both listener.ora or sqlnet.ora file and recreate it properly. These will defenitely resolve the issue.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google