My Oracle Support Banner

Datapatch fails With ORA-00904/00905: Objekt GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN (Doc ID 2780826.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

On : 19.10.0.0.0 version, Global Data Services

After applying the Jan RU, datapatch reported the following errors:

Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):
Apply from 19.1.0.0.0 Feature Release to 19.10.0.0.0 Release_Update 210108185017


Patch 32218454 apply: WITH ERRORS
logfile: /<Dir>/oracle/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_2021May25_07_31_09.log (errors)
-> Error at line 107408: script rdbms/admin/prvtgwm.sql
- 27/7 PL/SQL: SQL Statement ignored
-> Error at line 107409: script rdbms/admin/prvtgwm.sql
- 27/14 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID
-> Error at line 107410: script rdbms/admin/prvtgwm.sql
- 35/9 PL/SQL: Statement ignored
-> Error at line 107740: script rdbms/admin/prvtgwm.sql
- 950/10 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID
-> Error at line 107754: script rdbms/admin/prvtgwm.sql
- 950/3 PL/SQL: SQL Statement ignored
-> Error at line 107755: script rdbms/admin/prvtgwm.sql
- 950/10 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID
-> Error at line 108072: script rdbms/admin/prvtgwm.sql
- 0/0 PLS-00905: Objekt GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN ist
-> Error at line 112294: script rdbms/admin/prvtgwmcl.plb
- 27/7 PL/SQL: SQL Statement ignored
-> Error at line 112295: script rdbms/admin/prvtgwmcl.plb
- 27/14 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID
-> Error at line 112296: script rdbms/admin/prvtgwmcl.plb
- 35/9 PL/SQL: Statement ignored
-> Error at line 112626: script rdbms/admin/prvtgwmcl.plb
- 950/10 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID
-> Error at line 112640: script rdbms/admin/prvtgwmcl.plb
- 950/3 PL/SQL: SQL Statement ignored
-> Error at line 112641: script rdbms/admin/prvtgwmcl.plb
- 950/10 PL/SQL: ORA-00904: "DBMS_XDB_CONFIG"."GETHTTPPORT": ung▒ltige ID

Changes

Invalid objects owned by GSMADMIN_INTERNAL user gets reported after patching and running catalog and catproc does not validate them.

 

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
References


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