Bases de datos / Error Oracle / Oracle

Patch 35943157 apply: WITH ERRORS

- por JulianOrtiz0506 - Dejar un comentario
oracle-error

Tabla de contenido

Al momento de realizar el parchado de la BD a 19.22, obtenemos el siguiente error al ejecutar el comando
./datapatch -verbose

[oracle@soyundba OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.22.0.0.0 Production on Tue Jun 11 11:58:22 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.

Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3878659_2024_06_11_11_58_22/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 34086870 (OJVM RELEASE UPDATE: 19.16.0.0.220719 (34086870)):
  Binary registry: Not installed
  SQL registry: Rolled back successfully on 11-JUN-24 10.43.21.600784 AM
Interim patch 35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)):
  Binary registry: Not installed
  SQL registry: Rolled back successfully on 11-JUN-24 11.21.12.507543 AM
Interim patch 35926646 (OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)):
  Binary registry: Installed
  SQL registry: Applied with errors on 11-JUN-24 11.56.19.398989 AM

Current state of release update SQL patches:
  Binary registry:
    19.22.0.0.0 Release_Update 240104023954: Installed
  SQL registry:
    Applied 19.22.0.0.0 Release_Update 240104023954 with errors on 11-JUN-24 11.56.19.395578 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 35943157 (Database Release Update : 19.22.0.0.240116 (35943157)):
    Apply from 19.1.0.0.0 Feature Release to 19.22.0.0.0 Release_Update 240104023954
  The following interim patches will be applied:
    35926646 (OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646))

Installing patches...
Patch installation complete.  Total patches installed: 2

Validating logfiles...done
Patch 35943157 apply: WITH ERRORS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/35943157/25527362/35943157_apply_SOYUNDBA_2024Jun11_11_58_45.log (errors)
  -> Error at line 382440: script rdbms/admin/prvtsodautil.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382448: script rdbms/admin/prvtsodautil.plb
      - 10/5     PL/SQL: SQL Statement ignored
  -> Error at line 382450: script rdbms/admin/prvtsodautil.plb
      - 21/5     PL/SQL: SQL Statement ignored
  -> Error at line 382452: script rdbms/admin/prvtsodautil.plb
      - 34/7     PL/SQL: SQL Statement ignored
  -> Error at line 382454: script rdbms/admin/prvtsodautil.plb
      - 41/7     PL/SQL: SQL Statement ignored
  -> Error at line 382459: script rdbms/admin/prvtsodautil.plb
      - 63/5     PL/SQL: SQL Statement ignored
  -> Error at line 382461: script rdbms/admin/prvtsodautil.plb
      - 74/5     PL/SQL: SQL Statement ignored
  -> Error at line 382463: script rdbms/admin/prvtsodautil.plb
      - 87/5     PL/SQL: SQL Statement ignored
  -> Error at line 382468: script rdbms/admin/prvtsodautil.plb
      - 93/5     PL/SQL: SQL Statement ignored
  -> Error at line 382470: script rdbms/admin/prvtsodautil.plb
      - 107/5    PL/SQL: SQL Statement ignored
  -> Error at line 382472: script rdbms/admin/prvtsodautil.plb
      - 123/5    PL/SQL: SQL Statement ignored
  -> Error at line 382476: script rdbms/admin/prvtsodautil.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382735: script rdbms/admin/prvtsodadml.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382743: script rdbms/admin/prvtsodadml.plb
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 382744: script rdbms/admin/prvtsodadml.plb
      - 13/5     PL/SQL: SQL Statement ignored
  -> Error at line 382746: script rdbms/admin/prvtsodadml.plb
      - 33/5     PL/SQL: SQL Statement ignored
  -> Error at line 382748: script rdbms/admin/prvtsodadml.plb
      - 49/5     PL/SQL: SQL Statement ignored
  -> Error at line 382753: script rdbms/admin/prvtsodadml.plb
      - 58/5     PL/SQL: SQL Statement ignored
  -> Error at line 382755: script rdbms/admin/prvtsodadml.plb
      - 69/5     PL/SQL: SQL Statement ignored
  -> Error at line 382757: script rdbms/admin/prvtsodadml.plb
      - 103/5    PL/SQL: SQL Statement ignored
  -> Error at line 382759: script rdbms/admin/prvtsodadml.plb
      - 113/12   PLS-00341: declaration of cursor 'SODACUR' is incomplete or
  -> Error at line 382765: script rdbms/admin/prvtsodadml.plb
      - 114/20   PL/SQL: SQL Statement ignored
  -> Error at line 383336: script rdbms/admin/prvtsodacoll.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 383344: script rdbms/admin/prvtsodacoll.plb
      - 408/7    PL/SQL: SQL Statement ignored
  -> Error at line 383346: script rdbms/admin/prvtsodacoll.plb
      - 415/7    PL/SQL: SQL Statement ignored
  -> Error at line 383348: script rdbms/admin/prvtsodacoll.plb
      - 428/5    PL/SQL: SQL Statement ignored
  -> Error at line 383350: script rdbms/admin/prvtsodacoll.plb
      - 2548/5   PL/SQL: SQL Statement ignored
  -> Error at line 383355: script rdbms/admin/prvtsodacoll.plb
      - 2633/5   PL/SQL: SQL Statement ignored
  -> Error at line 383357: script rdbms/admin/prvtsodacoll.plb
      - 2647/9   PL/SQL: Statement ignored
  -> Error at line 383358: script rdbms/admin/prvtsodacoll.plb
      - 2647/41  PLS-00364: loop index variable 'COLLECTION_REC' use is invalid
  -> Error at line 383359: script rdbms/admin/prvtsodacoll.plb
      - 2652/9   PL/SQL: Statement ignored
  -> Error at line 383360: script rdbms/admin/prvtsodacoll.plb
      - 2652/40  PLS-00364: loop index variable 'COLLECTION_REC' use is invalid
  -> Error at line 384560: script rdbms/admin/prvtsodapls.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 384568: script rdbms/admin/prvtsodapls.plb
      - 55/9     PL/SQL: SQL Statement ignored
  -> Error at line 384570: script rdbms/admin/prvtsodapls.plb
      - 58/7     PL/SQL: Statement ignored
  -> Error at line 384571: script rdbms/admin/prvtsodapls.plb
      - 58/20    PLS-00364: loop index variable 'R' use is invalid
  -> Error at line 384756: script rdbms/admin/prvtgwm.sql
      - 55/9     PL/SQL: SQL Statement ignored
  -> Error at line 384758: script rdbms/admin/prvtgwm.sql
      - 58/7     PL/SQL: Statement ignored
  -> Error at line 384759: script rdbms/admin/prvtgwm.sql
      - 58/20    PLS-00364: loop index variable 'R' use is invalid
Patch 35926646 apply: WITH ERRORS (PREV PATCH)
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/35926646/25513953/35926646_apply_SOYUNDBA_2024Jun11_11_58_45.log (no errors)

Adding patches to retry installation queue...done
Retry installation queue:
  No interim patches need to be rolled back
  Patch 35943157 (Database Release Update : 19.22.0.0.240116 (35943157)):
    Apply from 19.1.0.0.0 Feature Release to 19.22.0.0.0 Release_Update 240104023954
  The following interim patches will be applied:
    35926646 (OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646))

Installing patches...
Patch installation complete.  Total patches installed: 2

Validating logfiles...done
Patch 35943157 apply: WITH ERRORS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/35943157/25527362/35943157_apply_SOYUNDBA_2024Jun11_12_00_51.log (errors)
  -> Error at line 382440: script rdbms/admin/prvtsodautil.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382448: script rdbms/admin/prvtsodautil.plb
      - 10/5     PL/SQL: SQL Statement ignored
  -> Error at line 382450: script rdbms/admin/prvtsodautil.plb
      - 21/5     PL/SQL: SQL Statement ignored
  -> Error at line 382452: script rdbms/admin/prvtsodautil.plb
      - 34/7     PL/SQL: SQL Statement ignored
  -> Error at line 382454: script rdbms/admin/prvtsodautil.plb
      - 41/7     PL/SQL: SQL Statement ignored
  -> Error at line 382459: script rdbms/admin/prvtsodautil.plb
      - 63/5     PL/SQL: SQL Statement ignored
  -> Error at line 382461: script rdbms/admin/prvtsodautil.plb
      - 74/5     PL/SQL: SQL Statement ignored
  -> Error at line 382463: script rdbms/admin/prvtsodautil.plb
      - 87/5     PL/SQL: SQL Statement ignored
  -> Error at line 382468: script rdbms/admin/prvtsodautil.plb
      - 93/5     PL/SQL: SQL Statement ignored
  -> Error at line 382470: script rdbms/admin/prvtsodautil.plb
      - 107/5    PL/SQL: SQL Statement ignored
  -> Error at line 382472: script rdbms/admin/prvtsodautil.plb
      - 123/5    PL/SQL: SQL Statement ignored
  -> Error at line 382476: script rdbms/admin/prvtsodautil.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382735: script rdbms/admin/prvtsodadml.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 382743: script rdbms/admin/prvtsodadml.plb
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 382744: script rdbms/admin/prvtsodadml.plb
      - 13/5     PL/SQL: SQL Statement ignored
  -> Error at line 382746: script rdbms/admin/prvtsodadml.plb
      - 33/5     PL/SQL: SQL Statement ignored
  -> Error at line 382748: script rdbms/admin/prvtsodadml.plb
      - 49/5     PL/SQL: SQL Statement ignored
  -> Error at line 382753: script rdbms/admin/prvtsodadml.plb
      - 58/5     PL/SQL: SQL Statement ignored
  -> Error at line 382755: script rdbms/admin/prvtsodadml.plb
      - 69/5     PL/SQL: SQL Statement ignored
  -> Error at line 382757: script rdbms/admin/prvtsodadml.plb
      - 103/5    PL/SQL: SQL Statement ignored
  -> Error at line 382759: script rdbms/admin/prvtsodadml.plb
      - 113/12   PLS-00341: declaration of cursor 'SODACUR' is incomplete or
  -> Error at line 382765: script rdbms/admin/prvtsodadml.plb
      - 114/20   PL/SQL: SQL Statement ignored
  -> Error at line 383336: script rdbms/admin/prvtsodacoll.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 383344: script rdbms/admin/prvtsodacoll.plb
      - 408/7    PL/SQL: SQL Statement ignored
  -> Error at line 383346: script rdbms/admin/prvtsodacoll.plb
      - 415/7    PL/SQL: SQL Statement ignored
  -> Error at line 383348: script rdbms/admin/prvtsodacoll.plb
      - 428/5    PL/SQL: SQL Statement ignored
  -> Error at line 383350: script rdbms/admin/prvtsodacoll.plb
      - 2548/5   PL/SQL: SQL Statement ignored
  -> Error at line 383355: script rdbms/admin/prvtsodacoll.plb
      - 2633/5   PL/SQL: SQL Statement ignored
  -> Error at line 383357: script rdbms/admin/prvtsodacoll.plb
      - 2647/9   PL/SQL: Statement ignored
  -> Error at line 383358: script rdbms/admin/prvtsodacoll.plb
      - 2647/41  PLS-00364: loop index variable 'COLLECTION_REC' use is invalid
  -> Error at line 383359: script rdbms/admin/prvtsodacoll.plb
      - 2652/9   PL/SQL: Statement ignored
  -> Error at line 383360: script rdbms/admin/prvtsodacoll.plb
      - 2652/40  PLS-00364: loop index variable 'COLLECTION_REC' use is invalid
  -> Error at line 384560: script rdbms/admin/prvtsodapls.plb
      - Warning: Package Body created with compilation errors.
  -> Error at line 384568: script rdbms/admin/prvtsodapls.plb
      - 55/9     PL/SQL: SQL Statement ignored
  -> Error at line 384570: script rdbms/admin/prvtsodapls.plb
      - 58/7     PL/SQL: Statement ignored
  -> Error at line 384571: script rdbms/admin/prvtsodapls.plb
      - 58/20    PLS-00364: loop index variable 'R' use is invalid
  -> Error at line 384756: script rdbms/admin/prvtgwm.sql
      - 55/9     PL/SQL: SQL Statement ignored
  -> Error at line 384758: script rdbms/admin/prvtgwm.sql
      - 58/7     PL/SQL: Statement ignored
  -> Error at line 384759: script rdbms/admin/prvtgwm.sql
      - 58/20    PLS-00364: loop index variable 'R' use is invalid
Patch 35926646 apply: WITH ERRORS (PREV PATCH)
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/35926646/25513953/35926646_apply_SOYUNDBA_2024Jun11_12_00_51.log (no errors)

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

SQL Patching tool complete on Tue Jun 11 12:02:58 2024
[oracle@soyundba OPatch]$

Esto se debe a que hay objetos inválidos

SQL> select owner,object_name,object_type,status from dba_objects where status='INVALID';

OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE             STATUS
----------------------- -------
XDB
DBMS_SODA_USER_DML
PACKAGE BODY            INVALID

XDB
DBMS_SODA_DML
PACKAGE BODY            INVALID

XDB
DBMS_SODA_ADMIN
PACKAGE BODY            INVALID

SYS
DBMS_SODA
PACKAGE BODY            INVALID

Solucion ERROR

Nos conectamos a la base de datos y otorgamos permisos al usuario XDB, sobre el tablespace SYSAUX.

sqlplus / as sysdba

grant UNLIMITED TABLESPACE to XDB;
Grant succeeded.

alter user xdb quota unlimited on SYSAUX; -- assuming SYSAUX is XDB user's default tablespace

@?/rdbms/admin/catsodacoll.sql

Anexos

Bajo la nota de Oracle (Doc ID 2684626.1) de la cual tambien podremos obtener información.

Te invito a seguir consultando más errores relacionados a Oracle dando clic aquí.

 

Entradas relacionadas

oracle-error

error while loading shared libraries: libclntsh.so.19.1

oracle-error

PRKC-1033 : Executable /grid/app/oracle/product/19.0.0/gridhome/bin/olsnodes does not exist

oracle-error

ORA-20001: Latest xml inventory is not loaded into table

Acerca de JulianOrtiz0506

Soy administrador de bases de datos y desarrollador web, desde mis inicios en el mundo de la informática, he implementando proyectos personales y empresariales. Por consiguiente esto me ha permitido contar con una amplia calificación y destreza sobre mis áreas de conocimiento. Sobre todo suelo estar en constante aprendizaje, diariamente me estoy informando sobre nuevas tecnologías. Ya queme gusta estar actualizado en la tecnología de punta para todas las plataformas que me apasionan y con las cuales trabajo día a día.

Ver todas las entradas de JulianOrtiz0506 →

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *