My Oracle Support Banner

Fleet : UPDATE_DB/UPDATE_RACDB Completes Successfully But Spliting DIRECTORY_PATH Values Into Two Lines For DBA_DIRECTORIES (Doc ID 2876344.1)

Last updated on OCTOBER 03, 2022

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, while running UPDATE_DB/ROLLBACK_DB using Fleet Maintenance,completes successful but updating the DIRECTORY_PATH Values Into Two Lines DBA_DIRECTORIES.

Command Snippet :
emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB -target_type=oracle_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN 

Job Steps Log for Job :Run Postswitch Updates :

Final command line to execute is $PERL_HOME/perl "/tmp/JOB_E06C89BB1F896714E053EE55C00A8D04/runPostSwitchSql.pl" -oh "/soft/oracle/product/19.15.0" -ob "/soft/oracle/product/19.15.0" -ve "19.0.0.0.0" -os "XXXX"

The output of the directive is:
ORACLE_BASE used from orabase output: /soft/oracle
Created the sql cmd successfully
Executing the command : /soft/oracle/product/19.15.0/bin/sqlplus / as sysdba @/soft/oracle/product/19.15.0/rdbms/admin/utlfixdirs.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 1 20:02:28 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
Container: CDB$ROOT

Current ORACLE_HOME: /soft/oracle/product/19.15.0
Original ORACLE_HOME: /soft/oracle/product/19.14.0

DATA_PUMP_DIR
...OLD: /soft/oracle/admin/cccdevlcdb/dpdump/
...NEW: /soft/oracle
/admin/cccdevlcdb/dpdump/
DATA_PUMP_DIR_CCCDEVL
...OLD: /soft/oracle/admin/cccdevlcdb/dpdump
...NEW: /soft/oracle
/admin/cccdevlcdb/dpdump
DBMS_OPTIM_ADMINDIR
...OLD: /soft/oracle/product/19.15.0/rdbms/admin
...NEW: /soft/oracle
/product/19.15.0/rdbms/admin

PL/SQL procedure successfully completed. 

 

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
Cause
Solution


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