My Oracle Support Banner

EM 13c: Fleet Update DB/RACDB Job Run Postswitch Updates Directory_Path Entries in Multiple Lines (Doc ID 2909222.1)

Last updated on DECEMBER 10, 2022

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, Fleet Update DB/RACDB Job Run Postswitch Updates Directory_Path Entries in Multiple Lines

Final command line to execute is $PERL_HOME/perl

"/tmp/JOB_DE9F67BDA236B394E0535E3A7D0A5FB1/runPostSwitchSql.pl" -oh "/u01/app/oracle/product/19.15.0/db_1" -ob "/u01/app/oracle/product/19.15.0/db_1"

-ve "19.12.0.0.0" -os "<DB_NAME>"

The output of the directive is:

comparing version 19 12 0 0 0 with 18 99 9 9 9

ORACLE_BASE used from orabase

output: /u01/app/oracle

Created the sql cmd successfully

Executing the command : /u01/app/oracle/product/19.15.0/db_1/bin/sqlplus / as sysdba

@/u01/app/oracle/product/19.15.0/db_1/rdbms/admin/utlfixdirs.sql

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 9 22:20:17 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

OPATCH_INST_DIR

...OLD: /u01/app/oracle/product/19.15.0/db_1/OPatch

...NEW:

/u01/app/oracle

/product/19.15.0/db_1/OPatch

OPATCH_LOG_DIR

...OLD: /u01/app/oracle/product/19.15.0/db_1/rdbms/log

...NEW:

/u01/app/oracle

/product/19.15.0/db_1/rdbms/log



select directory_path from dba_directories where directory_name like 'OPATCH%';

DIRECTORY_PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle
/product/19.15.0/db_1/OPatch

/u01/app/oracle
/product/19.15.0/db_1/rdbms/log

/u01/app/oracle
/product/19.15.0/db_1/QOpatch

 

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
References


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