If you are in process of rotating listener log file and you receive TNS-12508 while disabling log_status, this means you have imposed admin restrictions in listener log file for this listener. Same error would be returned for any other settings you would want to change using “set” command from lsnrctl utility. In the following I have reproduced this error and explained how to set and unset admin restrictions in listner log file.
[grid: admin]$ lsnrctl TNS-12508: TNS:listener could not
resolve the COMMAND given
LSNRCTL for Linux: Version 19.0.0.0.0 - Production
on 09-MAY-2023 09:27:10
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> set log_status off
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
If
you look into listener.ora file, you will find following parameter set to “ON”.
This should be noted that this parameter is set for the default listener “listener”.
Like other parameters, _<listener_name> is appended at the end of each
parameter to specify which listener this parameter is for.
|
ADMIN_RESTRICTIONS_LISTENER=ON |
Set
above parameter to either “off” or alternatively comment out the parameter and
do a listener reload. After that you should be able to set log_status, as well
as other parameters.
|
[grid: admin]$ lsnrctl |
No comments:
Post a Comment