Este post também está disponível em:
English
Durante a aplicação do datapatch, foi encontrado o seguinte erro ORA-01400: cannot insert NULL into (“DVSYS”.”REALM_OBJECT$”.”OWNER_UID#”):
Validating logfiles...done
Patch 35643107 apply: WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35643107/25405995/35643107_apply_SVHMBR01_2024Mar30_14_42_45.log (errors)
-> Error at line 239485: script rdbms/admin/catmacd.sql
- ORA-01400: cannot insert NULL into ("DVSYS"."REALM_OBJECT$"."OWNER_UID#")
- ORA-06512: at line 7
- ORA-06512: at line 2
Patch 35648110 apply: WITH ERRORS (PREV PATCH)
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35648110/25365038/35648110_apply_SVHMBR01_2024Mar30_14_42_45.log (no errors)De acordo com a nota Doc ID 2949214.1, podemos executar o datapatch com a opção de
-ignorable_errors ORA-01400
/u01/app/oracle/product/19.21.0.0/dbhome_1/OPatch/datapatch -verbose -ignorable_errors ORA-01400
SQL Patching tool version 19.21.0.0.0 Production on Sat Mar 30 14:47:55 2024
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_62981_2024_03_30_14_47_55/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 32399816 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)):
Binary registry: Not installed
SQL registry: Rolled back successfully on 30-MAR-24 02.42.39.165262 PM
Interim patch 35648110 (OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)):
Binary registry: Installed
SQL registry: Applied with errors on 30-MAR-24 02.46.38.920514 PM
Current state of release update SQL patches:
Binary registry:
19.21.0.0.0 Release_Update 230930151951: Installed
SQL registry:
Applied 19.21.0.0.0 Release_Update 230930151951 with errors on 30-MAR-24 02.46.38.915682 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
No interim patches need to be rolled back
Patch 35643107 (Database Release Update : 19.21.0.0.231017 (35643107)):
Apply from 19.12.0.0.0 Release_Update 210716141810 to 19.21.0.0.0 Release_Update 230930151951
The following interim patches will be applied:
35648110 (OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110))
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...done
Patch 35643107 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35643107/25405995/35643107_apply_SVHMBR01_2024Mar30_14_48_20.log (no errors)
Patch 35648110 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35648110/25365038/35648110_apply_SVHMBR01_2024Mar30_14_48_20.log (no errors)
SQL Patching tool complete on Sat Mar 30 14:52:34 2024
