Problema
Tentativa de aplicar os patches de JAN/2021 em um banco de dados na versão 12.1.0.2 com patches de OCT/2019 sempre falha ao realizar rollback do patch “30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439”.
Patches carregados no banco de dados:
PATCH_ID DESCRIPTION ACTION STATUS ACTION_DATE
---------- ---------------------------------------------------------------------------------------------------- ------------ --------------- --------------------
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) APPLY SUCCESS 06/11/19 11:56:53
29972716 DATABASE BUNDLE PATCH 12.1.0.2.191015 APPLY SUCCESS 06/11/19 11:56:55
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 APPLY SUCCESS 06/11/19 11:56:56
Patches no ORACLE_HOME a serem carregados no banco de dados com datapatch:
$ORACLE_HOME/OPatch/opatch lspatches 30432084; 32119956;Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021) 32318174; 31629625; 31335037; 32298703; 31965033;Database Bundle Patch : 12.1.0.2.210119 (31965033) 31704029;OCW PATCH SET UPDATE 12.1.0.2.201020 (31704029) OPatch succeeded.
Instância reiniciada em modo upgrade para iniciar a sessão do datapatch (Devido ao OJVM):
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 3.0602E+10 bytes
Fixed Size 5301552 bytes
Variable Size 3959425744 bytes
Database Buffers 2.6575E+10 bytes
Redo Buffers 61804544 bytes
Database mounted.
Database opened.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 PRD MOUNTED
SQL> alter pluggable database PRD open upgrade;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 PRD MIGRATE YES
Datapatch iniciado:
$ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed Jun 2 16:15:58 2021
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_66425_2021_06_02_16_15_58/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 30128197 (Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019)):
Installed in CDB$ROOT PDB$SEED PRD only
Patch 30290077 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439):
Installed in CDB$ROOT PDB$SEED PRD only
Patch 31629625 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047):
Installed in the binary registry only
Patch 32119956 (Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021)):
Installed in the binary registry only
Patch 32298703 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586):
Installed in the binary registry only
Patch 32318174 (JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR):
Installed in the binary registry only
Bundle series DBBP:
ID 210119 in the binary registry and ID 191015 in PDB CDB$ROOT, ID 191015 in PDB PDB$SEED, ID 191015 in PDB PRD
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PRD
The following patches will be rolled back:
30128197 (Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019))
30290077 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439)
The following patches will be applied:
32119956 (Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021))
31965033 (DATABASE BUNDLE PATCH 12.1.0.2.210119)
31629625 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047)
32298703 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586)
32318174 (JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR)
Installing patches...
Patch installation complete. Total patches installed: 21
Validating logfiles...
Patch 30128197 rollback (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30128197/23089451/30128197_rollback_CDB1_CDBROOT_2021Jun02_16_16_28.log (no errors)
Patch 30290077 rollback (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_CDBROOT_2021Jun02_16_17_14.log (no errors)
Patch 32119956 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32119956/23939362/32119956_apply_CDB1_CDBROOT_2021Jun02_16_20_37.log (no errors)
Patch 31965033 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31965033/24005385/31965033_apply_CDB1_CDBROOT_2021Jun02_16_20_38.log (no errors)
Patch 31629625 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31629625/23710973/31629625_apply_CDB1_CDBROOT_2021Jun02_16_22_59.log (no errors)
Patch 32298703 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32298703/24007820/32298703_apply_CDB1_CDBROOT_2021Jun02_16_22_59.log (no errors)
Patch 32318174 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32318174/24008600/32318174_apply_CDB1_CDBROOT_2021Jun02_16_26_12.log (no errors)
Patch 30128197 rollback (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30128197/23089451/30128197_rollback_CDB1_PDBSEED_2021Jun02_16_26_13.log (no errors)
Patch 30290077 rollback (pdb PDB$SEED): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PDBSEED_2021Jun02_16_26_43.log (errors)
Error at line 11091: Warning: Package Body altered with compilation errors.
Patch 32119956 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32119956/23939362/32119956_apply_CDB1_PDBSEED_2021Jun02_16_30_58.log (no errors)
Patch 31965033 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31965033/24005385/31965033_apply_CDB1_PDBSEED_2021Jun02_16_30_58.log (no errors)
Patch 31629625 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31629625/23710973/31629625_apply_CDB1_PDBSEED_2021Jun02_16_32_23.log (no errors)
Patch 32298703 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32298703/24007820/32298703_apply_CDB1_PDBSEED_2021Jun02_16_32_24.log (no errors)
Patch 32318174 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32318174/24008600/32318174_apply_CDB1_PDBSEED_2021Jun02_16_35_35.log (no errors)
Patch 30128197 rollback (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30128197/23089451/30128197_rollback_CDB1_PRD_2021Jun02_16_26_13.log (no errors)
Patch 30290077 rollback (pdb PRD): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PRD_2021Jun02_16_26_44.log (errors)
Error at line 11091: Warning: Package Body altered with compilation errors.
Patch 32119956 apply (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32119956/23939362/32119956_apply_CDB1_PRD_2021Jun02_16_30_58.log (no errors)
Patch 31965033 apply (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31965033/24005385/31965033_apply_CDB1_PRD_2021Jun02_16_30_58.log (no errors)
Patch 31629625 apply (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31629625/23710973/31629625_apply_CDB1_PRD_2021Jun02_16_32_23.log (no errors)
Patch 32298703 apply (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32298703/24007820/32298703_apply_CDB1_PRD_2021Jun02_16_32_23.log (no errors)
Patch 32318174 apply (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32318174/24008600/32318174_apply_CDB1_PRD_2021Jun02_16_35_35.log (no errors)
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_66425_2021_06_02_16_15_58/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Wed Jun 2 16:35:55 2021
Todas as operações de Apply e Rollback concluiram com sucesso, com exceção do patch 30290077.
Mensagem de erro reportada no PDB Seed e PRD:
Patch 30290077 rollback (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PDBSEED_2021Jun02_16_26_43.log (errors) Error at line 11091: Warning: Package Body altered with compilation errors Patch 30290077 rollback (pdb PRD): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PRD_2021Jun02_16_26_44.log (errors) Error at line 11091: Warning: Package Body altered with compilation errors
Causa
Objetos do SYS inválidos no banco de dados.
Não haviam objetos inválidos antes do apply dos patches, eles ficaram inválidos após o apply de algum dos patches durante esta execução do datapatch.
Solução
Recompilar todos os objetos inválidos no banco de dados com script utlrp.sql e executar o datapatch novamente. No caso de um Container Database (como o deste exemplo), é necessário realizar o procedimento em cada PDB.
Abaixo uma demonstrção de um CDB com apenas um PDB (além do SEED).
1) Recompilar objetos inválidos no CDB$ROOT (se houver) e em todos os PDBs.
Checando no CDB$ROOT:
SQL> SET PAGESIZE 500
COL OWNER FORMAT A30
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'SYS'
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE
/
no rows selected
Tudo Ok no CDB$ROOT, checando no PDB$SEED:
SQL> alter session set container = PDB$SEED;
Session altered.
SQL> SET PAGESIZE 500
COL OWNER FORMAT A30
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'SYS'
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE
/
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ----------------------- ----------
SYS PACKAGE 7
SYS PACKAGE BODY 54
SYS PROCEDURE 4
Então recompilamos os objetos inválidos no PDB$SEED:
SQL> @?/rdbms/admin/utlrp.sql
Checando novamente:
SQL> SET PAGESIZE 500
COL OWNER FORMAT A30
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'SYS'
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE
/
no rows selected
Tudo ok agora, checando no PDB PRD:
SQL> alter session set container=PRD;
Session altered.
SQL> SET PAGESIZE 500
COL OWNER FORMAT A30
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'SYS'
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE
/
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ----------------------- ----------
SYS PACKAGE 7
SYS PACKAGE BODY 54
SYS PROCEDURE 4
Recompilando objetos inválidos no PDB PRD:
SQL> @?/rdbms/admin/utlrp.sql
Checando novamente:
SQL> SET PAGESIZE 500
COL OWNER FORMAT A30
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'SYS'
GROUP BY OWNER, OBJECT_TYPE
ORDER BY OWNER, OBJECT_TYPE
/
no rows selected
Após execução do utlrp, não restaram objetos inválidos (do owner SYS).
2) Executar o datapatch novamente, ele fará apenas o rollback com patch que falhou anteriormente:
$ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed Jun 2 16:47:36 2021
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_91655_2021_06_02_16_47_36/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 30128197 (Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019)):
Not installed in the binary or the SQL registry
Patch 30290077 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439):
PDB$SEED (ROLLBACK with errors) PRD (ROLLBACK with errors) only
Patch 31629625 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047):
Installed in the binary registry and CDB$ROOT PDB$SEED PRD
Patch 32119956 (Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021)):
Installed in the binary registry and CDB$ROOT PDB$SEED PRD
Patch 32298703 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586):
Installed in the binary registry and CDB$ROOT PDB$SEED PRD
Patch 32318174 (JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR):
Installed in the binary registry and CDB$ROOT PDB$SEED PRD
Bundle series DBBP:
ID 210119 in the binary registry and ID 210119 in PDB CDB$ROOT, ID 210119 in PDB PDB$SEED, ID 210119 in PDB PRD
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT
Nothing to roll back
Nothing to apply
For the following PDBs: PDB$SEED PRD
The following patches will be rolled back:
30290077 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439)
Nothing to apply
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...
Patch 30290077 rollback (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PDBSEED_2021Jun02_16_48_00.log (no errors)
Patch 30290077 rollback (pdb PRD): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30290077/23107526/30290077_rollback_CDB1_PRD_2021Jun02_16_48_00.log (no errors)
SQL Patching tool complete on Wed Jun 2 16:51:13 2021
Datapatch concluiu com sucesso, cheque no banco de dados:
set lin 1000
col patch_id form 99999999999
col action form a12
col description form a100
col action_date form a20
col status form a15
select
patch_id,
description,
action,
status,
to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date
from dba_registry_sqlpatch r
order by r.action_time;
PATCH_ID DESCRIPTION ACTION STATUS ACTION_DATE
---------- ---------------------------------------------------------------------------------------------------- ------------ --------------- --------------------
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) APPLY SUCCESS 06/11/19 11:56:53
29972716 DATABASE BUNDLE PATCH 12.1.0.2.191015 APPLY SUCCESS 06/11/19 11:56:55
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 APPLY SUCCESS 06/11/19 11:56:56
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) ROLLBACK SUCCESS 02/06/21 16:35:36
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 ROLLBACK SUCCESS 02/06/21 16:35:38
32119956 Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021) APPLY SUCCESS 02/06/21 16:35:38
31965033 DATABASE BUNDLE PATCH 12.1.0.2.210119 APPLY SUCCESS 02/06/21 16:35:40
31629625 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047 APPLY SUCCESS 02/06/21 16:35:40
32298703 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586 APPLY SUCCESS 02/06/21 16:35:42
32318174 JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR APPLY SUCCESS 02/06/21 16:35:42
10 rows selected.
SQL> ALTER SESSION SET CONTAINER = PRD;
Session altered.
SQL> select
patch_id,
description,
action,
status,
to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date
from dba_registry_sqlpatch r
order by r.action_time;
PATCH_ID DESCRIPTION ACTION STATUS ACTION_DATE
---------- ---------------------------------------------------------------------------------------------------- ------------ --------------- --------------------
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) APPLY SUCCESS 06/11/19 11:56:56
29972716 DATABASE BUNDLE PATCH 12.1.0.2.191015 APPLY SUCCESS 06/11/19 11:56:59
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 APPLY SUCCESS 06/11/19 11:57:00
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) ROLLBACK SUCCESS 02/06/21 16:35:48
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 ROLLBACK WITH ERRORS 02/06/21 16:35:51
32119956 Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021) APPLY SUCCESS 02/06/21 16:35:51
31965033 DATABASE BUNDLE PATCH 12.1.0.2.210119 APPLY SUCCESS 02/06/21 16:35:53
31629625 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047 APPLY SUCCESS 02/06/21 16:35:53
32298703 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586 APPLY SUCCESS 02/06/21 16:35:55
32318174 JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR APPLY SUCCESS 02/06/21 16:35:55
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 ROLLBACK SUCCESS 02/06/21 16:51:13
11 rows selected.
SQL> ALTER SESSION SET CONTAINER=PDB$SEED;
Session altered.
SQL> select
patch_id,
description,
action,
status,
to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date
from dba_registry_sqlpatch r
order by r.action_time;
PATCH_ID DESCRIPTION ACTION STATUS ACTION_DATE
---------- ---------------------------------------------------------------------------------------------------- ------------ --------------- --------------------
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) APPLY SUCCESS 06/11/19 11:56:56
29972716 DATABASE BUNDLE PATCH 12.1.0.2.191015 APPLY SUCCESS 06/11/19 11:56:59
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 APPLY SUCCESS 06/11/19 11:57:00
30128197 Database PSU 12.1.0.2.191015, Oracle JavaVM Component (OCT2019) ROLLBACK SUCCESS 02/06/21 16:35:42
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 ROLLBACK WITH ERRORS 02/06/21 16:35:44
32119956 Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021) APPLY SUCCESS 02/06/21 16:35:44
31965033 DATABASE BUNDLE PATCH 12.1.0.2.210119 APPLY SUCCESS 02/06/21 16:35:46
31629625 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047 APPLY SUCCESS 02/06/21 16:35:46
32298703 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.210119 FOR BUGS 32269583 32269586 APPLY SUCCESS 02/06/21 16:35:48
32318174 JAN2021 100% DROP WITH JAN21 OJVM DATAPATCH IS FAILING WITH ERROR APPLY SUCCESS 02/06/21 16:35:48
30290077 MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.191015 FOR BUGS 30209388 28538439 ROLLBACK SUCCESS 02/06/21 16:51:13
11 rows selected.
Note que a ação de ROLLBACK do patch 30290077 executou com erro em 16:35:44 e com sucesso na segunda execução, em 16:51:13
Atualização – 02/06/2021 23:14: Inaugurei esse post aplicando a solução em um novo apply.
