My Oracle Support Banner

OCI Database Upgrade Failed on prechecks operation - Information to collect (Doc ID 2748449.1)

Last updated on SEPTEMBER 10, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Please gather below diagnostic information in case of database upgrade failed on prechecks operation in OCI DB system.

1.curl -s http://169.254.169.254/opc/v1/instance/ | egrep -v "user_data|ssh_authorized_keys|timeCreated"
2.dbcli list-jobs
3.dbcli describe-job -i <Failed DB upgrade job>
4.Upload all DCS agent log generated during the time frame of database upgrade.
5.Upload all logs in the folder /u01/app/oracle/cfgtoollogs/dbua/upgrade*
6.The database alert log file
7.The output of below SQL queries
      sqlplus " / as sysdba"
      show pdbs  (For version > 12.1)
      show parameter job_queue_processes

8. The output of below SQL queries on each PDB. 
            alter session set container=<PDB> (For version > 12.1)
            set linesize 1000
            column property_name format a30
            column property_value format a30
            select count(*) from dba_recyclebin;
            select count(*) from dba_objects where status='INVALID' and owner in ('SYS','SYSTEM');
            select property_name,property_value from database_properties where property_name like '%DST%'

 

The below is an example of pre-check failed due to pending DST issue in one of the pluggable database / JOB_QUEUE_PROCESSES is set to zero / Recyclebin was not not empty.

 

dbcli list-jobs

fa30b540-c8e5-4f90-badd-2891464ae329 Database upgrade precheck with dbResId : 0e7eda39-12e3-445c-abb0-1d14368eea90 Tuesday, January 26, 2021, 22:25:16 UTC Failure

 

dbcli describe-job -i fa30b540-c8e5-4f90-badd-2891464ae329

Job details
----------------------------------------------------------------
ID: fa30b540-c8e5-4f90-badd-2891464ae329
Description: Database upgrade precheck with dbResId : 0e7efa39-12e3-445c-abb0-1d14368eea80
Status: Failure
Created: January 26, 2021 10:25:16 PM UTC
Progress: 78%
Message: DCS-10326:Failed to perform database upgrade prechecks for DB: 3823840268 with error : Logs directory: /u01/app/oracle/cfgtoollogs/dbua/upgrade2021-01-26_10-29-36PM
Performing Pre-Upgrade Checks...
============================
PRE- and POST- FIXUP ACT
Cause: Failed to perform prechecks for the DB Upgrade.
Action: Contact Oracle support for assistance.

Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Database Service upgrade precheck January 26, 2021 10:25:16 PM UTC January 26, 2021 10:31:26 PM UTC Failure
Database Service upgrade precheck January 26, 2021 10:25:16 PM UTC January 26, 2021 10:31:26 PM UTC Failure
Database home creation January 26, 2021 10:25:16 PM UTC January 26, 2021 10:29:35 PM UTC Success
PreCheck executePreReqs January 26, 2021 10:29:36 PM UTC January 26, 2021 10:30:59 PM UTC Failure

 

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
Cause
Solution


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