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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: