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 laterInformation 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.
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 |