Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, October 14, 2015

TNS-12508: TNS:listener could not resolve the COMMAND given



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: