DCS-10326:Failed to perform database upgrade prechecks for DB - PreCheck executePreReqs in OCI DBSystem
(Doc ID 2734535.1)
Last updated on FEBRUARY 29, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
Database Upgrade failed with below error :
1. dbcli Job:
Message: DCS-10326:Failed to perform database upgrade prechecks for DB: 1593951536 with error : Logs directory: /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-11-20_11-02-14PM
Performing Pre-Upgrade Checks...
============================
PRE- and POST- FIXUP ACT
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Database Service upgrade precheck November 20, 2020 10:54:01 PM UTC November 20, 2020 11:06:11 PM UTC Failure
Database Service upgrade precheck November 20, 2020 10:54:01 PM UTC November 20, 2020 11:06:11 PM UTC Failure
Database home creation November 20, 2020 10:54:02 PM UTC November 20, 2020 11:02:10 PM UTC Success
PreCheck executePreReqs November 20, 2020 11:02:11 PM UTC November 20, 2020 11:04:45 PM UTC Failure
2. DCS log:
2020-11-20 23:04:45,977 DEBUG [PreCheck executePreReqs : JobId=bb048f7b-ea89-445d-b324-1ba63099beec] [] c.o.d.a.z.DCSZooKeeper: DCS node id is - node_0
2020-11-20 23:04:45,977 DEBUG [PreCheck executePreReqs : JobId=bb048f7b-ea89-445d-b324-1ba63099beec] [] c.o.d.a.t.TaskZJsonRpc: Task[TaskZJsonRpcExt_117] RPC request 'Local:node_0@preCheck()' completed: Failure
2020-11-20 23:04:45,978 DEBUG [PreCheck executePreReqs : JobId=bb048f7b-ea89-445d-b324-1ba63099beec] [] c.o.d.a.t.TaskZJsonRpcExt: Task[id: TaskZJsonRpcExt_117, TaskName: PreCheck executePreReqs] got exception:
! com.oracle.dcs.commons.exception.DcsTaskFailureException: DCS-10326:Failed to perform database upgrade prechecks for DB: 1593951536 with error : Logs directory: /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-11-20_11-02-14PM
! Performing Pre-Upgrade Checks...
! ============================
! PRE- and POST- FIXUP ACTIONS
! =============================
! /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-11-20_11-02-14PM/cdb01_yyz1rb/upgrade.xml
! /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-11-20_11-02-14PM/cdb01_yyz1rb/preupgrade_fixups.sql
! /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-11-20_11-02-14PM/cdb01_yyz1rb/postupgrade_fixups.sql
! .
! at com.oracle.dcs.agent.task.TaskZJsonRpc.processJsonResponse(TaskZJsonRpc.java:62)
! at com.oracle.dcs.agent.task.TaskZJsonRpcExt.callInternal(TaskZJsonRpcExt.java:60)
! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:198)
! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:30)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:103)
! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:52)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:39)
3. Upgrade logs (/u01/app/oracle/cfgtoollogs/dbua/XXXXXXX)
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: RESULT: If the -T option is used to set user tablespaces to READ ONLY during the upgrade, user tables in those tablespaces, that are dependent on Oracle-Maintained types, will not be automatically upgraded. If a type is evolved during the upgrade, any dependent tables need to be re-validated and upgraded to the latest type version AFTER the database upgrade completes., STATUS: WARNING
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: RESULT: It is good practice to have the catalog schema the same or higher version than the RMAN client version you are using., STATUS: INFO
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: RESULT: Starting with Oracle Database 11.2, setting JOB_QUEUE_PROCESSES=0 will disable job execution via DBMS_JOBS and DBMS_SCHEDULER., STATUS: ERROR
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: Prereq to be taken care of : RESULT: Starting with Oracle Database 11.2, setting JOB_QUEUE_PROCESSES=0 will disable job execution via DBMS_JOBS and DBMS_SCHEDULER., STATUS: ERROR
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: RESULT: The recycle bin must be completely empty before database upgrade., STATUS: ERROR
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: RESULT: Oracle recommends upgrading to the desired (latest) version of the time zone file. For more information, refer to "Upgrading the Time Zone File and Timestamp with Time Zone Data" in the 19 Oracle Database Globalization Support Guide., STATUS: WARNING
INFO: Nov 20, 2020 11:04:44 PM oracle.assistants.dbua.prereq.StandalonePrereqExecutor shutdown
INFO: Custom Check Results:
Changes
Upgraded the Database through console.
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 |