Site icon IT Tutorial

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

Hi,

Sometimes You can get “TNS-12508: TNS:listener could not resolve the COMMAND given  ” error.

 

Details of error are as follows.

TNS-12508: TNS:listener could not resolve the COMMAND given
Cause: d by incompatible Oracle Net or Net8 versions. Do not include in error manual.
Action: This is not seen in normal use of Oracle Net.

This error is related with  the control parameter set in the listener.ora file.

ADMIN_RESTRICTIONS_<listener_name> = ON

ADMIN_RESTRICTIONS_LISTENER = ON

 

Setting ADMIN_RESTRICTIONS_<listener_name> = ON disables the “runtime” modification of parameters in the listener.ora file.
In other words, the listener refuses to accept SET commands that alter its parameters and states that it cannot “resolve the COMMAND given.

 

To solve this error, remove this parameter from listener.ora, or set this parameter to OFF, then reload the listener. 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version