13.2 EM Fleet migrate_listener Does Not Update the ORACLE_HOME In The New listener.ora File
(Doc ID 2626368.1)
Last updated on NOVEMBER 30, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
When using Fleet Maintenance to patch/upgrade targets, and when the source LISTENER is either not running on default PORT# 1521 or is not static listener, then the ORACLE_HOME in the migrated (new) listener.ora file does not have its ORACLE_HOME parameter updated with the new oracle home.
The migrate job output shows it fails to start the migrated listener because of incorrect ORACLE_HOME in the listener.ora file.
The job output looks something like this:
Failed in config command , please check inputsCommand to start listener:/u01/app/oracle/product/12.2.0.1.1901/bin/lsnrctl start <listenername>
Result:
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-APR-2019 10:19:57
Copyright (c) 1991, 2016, Oracle. All rights reserved.
TNS-01106: Listener using listener name <listenername> already been started
Start listener <listenername> failed from destination Oracle home. Listener will be restored from source Oracle home.
Command to start listener:/u01/app/oracle/product/12.2.0.1/bin/lsnrctl start <listenername>
Result:
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-APR-2019 10:19:58
Copyright (c) 1991, 2016, Oracle. All rights reserved.
TNS-01106: Listener using listener name <listenername> has already been started
Restore of listener <listener name> to source Oracle home failed.Please try to start it manually.
Deleted temporary destination directory /tmp/JOB_85DE4BDA563DA6ABE053442C13AC71A7
Process returned : 1.
Result:
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-APR-2019 10:19:57
Copyright (c) 1991, 2016, Oracle. All rights reserved.
TNS-01106: Listener using listener name <listenername> already been started
Start listener <listenername> failed from destination Oracle home. Listener will be restored from source Oracle home.
Command to start listener:/u01/app/oracle/product/12.2.0.1/bin/lsnrctl start <listenername>
Result:
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-APR-2019 10:19:58
Copyright (c) 1991, 2016, Oracle. All rights reserved.
TNS-01106: Listener using listener name <listenername> has already been started
Restore of listener <listener name> to source Oracle home failed.Please try to start it manually.
Deleted temporary destination directory /tmp/JOB_85DE4BDA563DA6ABE053442C13AC71A7
Process returned : 1.
Changes
N/A
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 |