My Oracle Support Banner

EMN 13c: Enterprise Manager 13c Cloud Control Fleet Maintenance: UPDATE_DB Fails at Apply PSU / Patches on the Target Database (Doc ID 2649138.1)

Last updated on MARCH 08, 2022

Applies to:

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

Symptoms

Enterprise Manager (EM) 13.3.2 Cloud Control Fleet Maintenance:
The UPDATE_DB procedure fails.
Procedure Activity shows failure at "Apply PSU/Patches on the database" procedure step

Upgrading from 19.3 to 19.4

Patch = 29834717
Release = Oracle Database 19.0.0.0.0
Abstract = DATABASE RELEASE UPDATE 19.4.0.0.0

Fleet command is:
-----
emcli db_software_maintenance -performOperation -name="UPDATE DB on Host" -purpose=UPDATE_DB -target_type=oracle_database -target_list=<database_name> -normal_credential=HOST_ORACLE:SYSMAN -privilege_credential=HOST_ORACLE_SUDO:SYSMAN -input_file="data:<PATH>/UPDATE_DB.txt"

Procedure dump shows errors:

-> Error at line 2856: script rdbms/admin/prvtgwm.sql
- Warning: Package Body created with compilation errors.
-> Error at line 2862: script
rdbms/admin/prvtgwm.sql
- 3535/3 PL/SQL: SQL Statement ignored
-> Error at line 2864: script rdbms/admin/prvtgwm.sql
- 3867/5

Ends with:

1522/20 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
-> Error at line 3001: script rdbms/admin/prvtgwm.sql
- 1532/7 PL/SQL: SQL
Statement ignored
-> Error at line 3003: script rdbms/admin/prvtgwm.sql
- 1534/7 PL/SQL: Statement ignored
-> Error at line 3004: script
rdbms/admin/prvtgwm.sql
- 1534/10 PLS-00320: the declaration of the type of this expression is
-> Error at line 3010: script
rdbms/admin/prvtgwm.sql
- 2681/5 PL/SQL: SQL Statement ignored
-> Error at line 3012: script rdbms/admin/prvtgwm.sql
- 2694/5
PL/SQL: SQL Statement ignored
-> Error at line 3014: script rdbms/admin/prvtgwm.sql
- 2815/5 PL/SQL: SQL Statement ignored
-> Error at
line 3016: script rdbms/admin/prvtgwm.sql
- 2907/5 PL/SQL: SQL Statement ignored

Please refer to MOS Note 1609718.1 and/or the invocation
log
/u07/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_13949_2020_02_14_12_20_36/sqlpatch_invocation.log
for information on how to resolve the above
errors.

SQL Patching tool complete on Fri Feb 14 12:21:08 2020
Tried 5 times. Please rerun the patch sqls.

Datapatch execution failed with error
code 512[ERROR] - Datapatch execution failed with error code 512

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


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