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

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/

 1,741 views last month,  1 views today