My Oracle Support Banner

EM 13c: Enterprise Manager 13c Cloud Control Fleet Maintenance UPDATE_RACDB Job Sets Wrong Path for Oracle Base Directory (Doc ID 2823064.1)

Last updated on APRIL 02, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manger (EM) 13.4 Cloud Control, the Fleet Maintenance Update RAC Database job sets the wrong path for the Oracle Base Directory, which should be the current path.

Job Step : Run Postswitch Updates

Final command line to execute is $PERL_HOME/perl "/DBS/tmp/JOB_C5863E10FDCE65FDE0530626410A5F28/runPostSwitchSql.pl" -oh "/DBS/TESTDBS/new" -ob "/DBS/TESTDBS/new" -ve "19.0.0.0.0" -os "<db_name>"
The output of the directive is:
Created the sql cmd successfully
Executing the command : /DBS/TESTDBS/new/bin/sqlplus / as sysdba /DBS/TESTDBS/new/rdbms/admin/utlfixdirs.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 24 16:32:17 2021
Version 19.11.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
Container: <db_name>
Current ORACLE_HOME: /DBS/TESTDBS/new
Original ORACLE_HOME: /DBS/TESTDBS/dest19
ORACLE_HOME
...OLD: /DBS/TESTDBS/dest19
...NEW: /DBS/TESTDBS/new
ORACLE_OCM_CONFIG_DIR
...OLD: /DBS/TESTDBS/dest19/ccr/state
...NEW: /DBS/TESTDBS/new/ccr/state
ORACLE_OCM_CONFIG_DIR2
...OLD: /DBS/TESTDBS/dest19/ccr/state
...NEW: /DBS/TESTDBS/new/ccr/state
XMLDIR
...OLD: /DBS/TESTDBS/dest19/rdbms/xml
...NEW: /DBS/TESTDBS/new/rdbms/xml
XSDDIR
...OLD: /DBS/TESTDBS/dest19/rdbms/xml/schema
...NEW: /DBS/TESTDBS/new/rdbms/xml/schema
Current ORACLE_BASE: /DBS/TESTDBS/new
Original ORACLE_BASE: /DBS/TESTDBS/orabase
DATA_PUMP_DIR
...OLD: /DBS/TESTDBS/orabase/admin/dest19/dpdump/
...NEW: /DBS/TESTDBS/new/admin/dest19/dpdump/
ORACLE_BASE
...OLD: /DBS/TESTDBS/orabase
...NEW: /DBS/TESTDBS/new
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
utlfixdir ran successfully!!!

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.