Lsnrctl Save_config can Overwrite Parameters Cached
(Doc ID 390213.1)
Last updated on JANUARY 21, 2025
Applies to:
Oracle Net Services - Version 9.2.0.1.0 to 10.2.0.1.0 [Release 9.2 to 10.2]Oracle Database - Enterprise Edition - Version 19.5.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
Listener.ora parameters are overwritten when second save_config command has been run, for another listener stored in the same listener.ora file.
Example: ListenerA and ListenerB have log_files values set to logA and logB respectively:
LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 08-NOV-2006 15:54:07
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener listenerA
Current Listener is listenerA
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myhostname>)(PORT=1525)))
listenerA parameter "log_file" set to logA.log
The command completed successfully
LSNRCTL> set log_file new.log
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myhostname>)(PORT=1525)))
listenerA parameter "log_file" set to new.log
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myhostname>)(PORT=1525)))
Saved listenerA configuration parameters.
ListenerA Parameter File /u01/Software/Oracle/64/10g/network/admin/listener.ora
Old Parameter File /u01/Software/Oracle/64/10g/network/admin/listener.bak
The command completed successfully
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myhostname>)(PORT=1525)))
listenerA parameter "log_file" set to new.log
The command completed successfully .]
Now change the second listener log_file value:
LSNRCTL> set current_listener ListenerB
Current Listener is ListenerB
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
ListenerB parameter "log_file" set to logB.log
The command completed successfully
LSNRCTL> set log_file new2.log
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
ListenerB parameter "log_file" set to new2.log
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Saved ListenerB configuration parameters.
Listener Parameter File /u01/Software/Oracle/64/10g/network/admin/listener.ora
Old Parameter File /u01/Software/Oracle/64/10g/network/admin/listener.bak
The command completed successfully
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
ListenerB parameter "log_file" set to new2.log
The command completed successfully
Exit and check the listener.ora file:
#----ADDED BY TNSLSNR 08-NOV-2006 15:30:10---
LOG_FILE_listenerA = logA.log
#--------------------------------------------
#----ADDED BY TNSLSNR 08-NOV-2006 15:30:34---
LOG_FILE_listenerB = new2.log
#--------------------------------------------
ListenerA still has its old value for log_file
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |