TNS-12560: TNS:protocol adapter error, TNS 00583 Valid node checking unable to parse configuration parameters facing error while trying to start listener.
Fixing TNS 00583 configuration parameters.
Error: –
dbuatsrv$ lsnrctl start DBUAT
TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /dbuat/oracle/DBUAT/db/tech_st/19.3.0/network/admin/listener.ora
Log messages written to /dbuat/oracle/DBUAT/db/tech_st/19.3.0/log/diag/tnslsnr/dbuatsrv/dbuatc/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbuatsrv)(PORT=1590)))
TNS-12560: TNS: protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters.
Solution:-
In my case, I just remove the space and put comment on description then save the sqlnet.ora file and the error was removed.
Verification: –
$lsnrctl start DBUAT
LSNRCTL for Linux: Version 19.0.0.0 – Production on 20-JAN-2023 02:41:41
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /dbuat/oracle/DBUAT/db/tech_st/19.3.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /dbuat/oracle/DBUAT/db/tech_st/19.3.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dbuatsrv/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbuatsrv)(PORT=1590)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1590)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbuatsrv)(PORT=1590)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.3.0.0 – Production
Start Date 20-JAN-2023 02:41:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /dbuat/oracle/DBUAT/db/tech_st/19.3.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbuatsrv/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbuatsrv)(PORT=1590)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1590)))
The listener supports no services
The command completed successful.