DBUA Failure: 'Severe Errors Encountered During Listener Configuration' at 42% in RAC Environment
(Doc ID 3053093.1)
Last updated on OCTOBER 14, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.24.0.0.0 [Release 12.2 to 19]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
The Database Upgrade Assistant (DBUA) has encountered a failure from 12c to 19c during the upgrade process, specifically displaying the message 'Severe errors encountered during the execution of Listener Configuration'.
This issue arises within a Real Application Clusters (RAC) environment, indicating potential complications related to the Listener Configuration across the clustered database instances.
Group information is missing from the /etc/group file..
Example:
root:x:0:
daemon:x:1:
bin:x:2:
sys:x:3:
adm:x:4:user1,user2
wheel:x:10:user3
users:x:1000:user4
oinstall:!:212:
dba::8005:abc
Additionally noted in the DBUA trace logs
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:134] Running listener control: <SOURCE_DB_ORACLE_HOME>/bin/lsnrctl stop LISTENER_XYZ
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:135] Commandline lsnrctl <SOURCE_DB_ORACLE_HOME>/bin/lsnrctl stop LISTENER_XYZ
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:146] key= LD_LIBRARY_PATH=<SOURCE_DB_ORACLE_HOME>/lib:<TARGET_DB_ORACLE_HOME>/network/lib:
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:146] key= LD_LIBRARY_PATH_64=<SOURCE_DB_ORACLE_HOME>/lib:/opt/ORCLcluster/lib:<TARGET_DB_ORACLE_HOME>/network/lib:
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:154] oracle hme lsnrctl running<SOURCE_DB_ORACLE_HOME>
[Thread-465] [ <Date_Time> ] [ListenerControlImpl$StreamReader.run:315] line=LSNRCTL for Solaris: Version 12.2.0.1.0 - Production on <Date_Time>
[Thread-465] [ <Date_Time> ] [ListenerControlImpl$StreamReader.run:315] line=Copyright (c) 1991, 2005, Oracle. All rights reserved.
[Thread-465] [ <Date_Time> ] [ListenerControlImpl$StreamReader.run:315] line=Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Server123-vipXYZ)(PORT=1529)(IP=FIRST)))
[Thread-465] [ <Date_Time> ] [ListenerControlImpl$StreamReader.run:313] inside StreamReader run
[Thread-465] [ <Date_Time> ] [ListenerControlImpl$StreamReader.run:315] line=TNS-01190: The user is not authorized to execute the requested listener command
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:188] Listener control complete.
[Thread-347] [ <Date_Time> ] [ListenerControlImpl.runLsnrCtl:203] Is listener Control success: false
[Thread-347] [ <Date_Time> ] [MigrateListener.migrateListener:207] Failed to stop listener.
SEVERE: <Date_Time> oracle.assistants.dbua.backend.ListenerConfigurationStep executeImpl
SEVERE: Failed to stop listener.
[Thread-347] [ <Date_Time> ] [StepErrorHandler.collectFatalError:528] Collecting fatal error :[StepExecutionException: Failed to stop listener.]
[AWT-EventQueue-0] [ <Date_Time> ] [ProgressPane$RunNextStep.run:1533] Start time for this ProgressItem saved: 1727772015050
[AWT-EventQueue-0] [ <Date_Time> ] [ProgressPane$RunNextStep.run:1535] longTime 7356
"trace.log_<Date_Time>" 428
Upon reviewing Listener information from both nodes
On Node 1:
$[grid][+ASM1]$ ps -ef |grep tns
grid 5428 1 0 Aug 20 ? 5:27 /abc/xyz/19.0.0.0/grid/bin/tnslsnr ASMNET122LSNR_ASM -no_crs_notify -inherit
grid 18104 1 0 05:10:56 ? 0:00 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER_XYZ -no_crs_notify -inherit
grid 19101 1 0 05:10:55 ? 0:00 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 22206 12588 0 05:20:39 pts/2 0:00 grep tns
oracle 13209 1 0 05:04:01 ? 0:00 /<TARGET_RDBMS_ORACLE_HOME>/bin/tnslsnr LISTENER_XYZ -inherit
grid 2939 1 0 Aug 20 ? 0:31 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit
grid 2810 1 0 Aug 20 ? 0:29 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit
[grid][+ASM1]$
On Node 2:
$[grid][+ASM2]$ ps -ef |grep tns
grid 6672 1 0 Aug 20 ? 0:28 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
grid 6339 1 0 Aug 20 ? 5:13 /abc/xyz/19.0.0.0/grid/bin/tnslsnr ASMNET122LSNR_ASM -no_crs_notify -inherit
grid 14319 1 0 05:10:55 ? 0:00 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 12533 9198 0 05:20:55 pts/1 0:00 grep tns
grid 14222 1 0 05:10:55 ? 0:00 /abc/xyz/19.0.0.0/grid/bin/tnslsnr LISTENER_XYZ -no_crs_notify -inherit
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 |