Getting below TNS error while changing the trace level for the listener
LSNRCTL> set trc_level user
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCEBSSBX_SSL)))
TNS-12508: TNS:listener could not resolve the COMMAND given
Fix:
===
Turn off the ADMIN_RESTRICTIONS in listener.ora
cat listener.ora | grep -i restrictions
ADMIN_RESTRICTIONS_SHAIKDB = ON
change it to:
ADMIN_RESTRICTIONS_SHAIKDB = OFF
LSNRCTL> stop SHAIKDB
LSNRCTL> start SHAIKDB
or
[oracle@collabn1 ~]$ lsnrctl stop shaikdb
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-OCT-2015 10:51:24
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=collabn1.shaiksameer)(PORT=1522)))
The command completed successfully
[oracle@collabn1 ~]$ lsnrctl start shaikdb
Now try to reset the trace level:
=====================
LSNRCTL> set current_listener shaikdb
Current Listener is shaikdb
LSNRCTL> set trc_level off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=collabn1.shaiksameer)(PORT=1522)))
shaikdb parameter "trc_level" set to off
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=collabn1.shaiksameer)(PORT=1522)))
Saved shaikdb configuration parameters.
Listener Parameter File /u01/app/oracle/product/11.2.0.2/SHAIKPROD/network/admin/listener.ora
Old Parameter File /u01/app/oracle/product/11.2.0.2/SHAIKPROD/network/admin/listener.bak
The command completed successfully
No comments:
Post a Comment