My Oracle Support Banner

Invalid objects when run datapatch (Doc ID 2723786.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Goal

You were applying Oct PSU. When you run datapatch, you got the following errors:

Patch 31771877 apply: WITH ERRORS
logfile: /ora01/app/oracle/cfgtoollogs/sqlpatch/31771877/23869227/31771877_apply_DBA5_2020Oct23_06_49_06.log (errors)
-> Error at line 140322: script rdbms/admin/prvtgwm.sql
- Warning: Package Body created with compilation errors.
-> Error at line 140329: script rdbms/admin/prvtgwm.sql
- 68/3 PL/SQL: Statement ignored
-> Error at line 140330: script rdbms/admin/prvtgwm.sql
- 68/12 PLS-00201: identifier 'DBMS_LOB' must be declared
-> Error at line 140331: script rdbms/admin/prvtgwm.sql
- 72/5 PL/SQL: Statement ignored
-> Error at line 140332: script rdbms/admin/prvtgwm.sql
- 73/17 PLS-00201: identifier 'DBMS_LOB' must be declared
-> Error at line 140333: script rdbms/admin/prvtgwm.sql
- 86/9 PL/SQL: Statement ignored
-> Error at line 140334: script rdbms/admin/prvtgwm.sql
- 87/21 PLS-00201: identifier 'DBMS_LOB' must be declared
-> Error at line 140335: script rdbms/admin/prvtgwm.sql
- 94/11 PL/SQL: Statement ignored
-> Error at line 140339: script rdbms/admin/prvtgwm.sql
- 95/23 PLS-00201: identifier 'DBMS_LOB' must be declared
-> Error at line 140340: script rdbms/admin/prvtgwm.sql
- 98/11 PL/SQL: Statement ignored

1. select owner, object_name, object_type from dba_objects where status = 'INVALID'
SQL> /

OWNER OBJECT_NAME OBJECT_TYPE
-------------------- ---------------------------------------- -----------------------
GSMADMIN_INTERNAL DBMS_GSM_COMMON PACKAGE BODY
GSMADMIN_INTERNAL EXCHANGE PACKAGE BODY
GSMADMIN_INTERNAL DBMS_GSM_DBADMIN PACKAGE BODY
GSMADMIN_INTERNAL DBMS_GSM_POOLADMIN PACKAGE BODY
GSMADMIN_INTERNAL DBMS_GSM_CLOUDADMIN PACKAGE BODY
GSMADMIN_INTERNAL CAT_ROLLBACK_TRIGGER TRIGGER
GSMADMIN_INTERNAL REQUEST_DELETE_TRIGGER TRIGGER
GSMADMIN_INTERNAL DONE_TRIGGER TRIGGER
GSMADMIN_INTERNAL GSMLOGOFF TRIGGER

2. You used the commands below to compile the invalid objects.

alter package gsmadmin_internal.<object name> compile body;
alter trigger gsmadmin_internal.<trigger name> compile;
alter procedure gsmadmin_internal.<procedure name> compile;

But the compilation failed with the error below:

 

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid

Warning: Trigger created with compilation errors.

Errors for TRIGGER REQUEST_DELETE_TRIGGER:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00905: object GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN is invalid


 

Solution

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