- 01 Dec, 2023
- 0 Comments
- 1 Min Read
Prereq Check Failed – The Database Must Be In Upgrade Mode
Solution :
We need to start the database in upgrade mode.SQL> startup upgrade ORACLE instance started. Total System Global Area 2.2280E+10 bytes Fixed Size 7676976 bytes Variable Size 1.2147E+10 bytes Database Buffers 1.0066E+10 bytes Redo Buffers 59428864 bytes Database mounted. Database opened.
Now run datapatch:
/oracle/app/oracle/product/12.1.0.2/dbhome_1/OPatch $ ./datapatch -verbose SQL Patching tool version 12.1.0.2.0 on Fri Sep 23 15:26:39 2023 Copyright (c) 2023, Oracle. All rights reserved. Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_16060_2023_09_23_15_26_39/sqlpatch_invocation.log Connecting to database...OK Bootstrapping registry and package to current versions...done Determining current state...done Current state of SQL patches: Patch 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2023)): Installed in the binary registry only Bundle series PSU: ID 160719 in the binary registry and not installed in the SQL registry Adding patches to installation queue and performing prereq checks... Installation queue: Nothing to roll back The following patches will be applied: 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2023)) 23054246 (Database Patch Set Update : 12.1.0.2.160719 (23054246)) Installing patches... Patch installation complete. Total patches installed: 2 Validating logfiles... Patch 23177536 apply: SUCCESS logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/23177536/20413866/23177536_apply_FINARCDB_2023Sep23_15_27_41.log (no errors) Patch 23054246 apply: SUCCESS logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/23054246/20284967/23054246_apply_FINARCDB_2023Sep23_15_27_43.log (no errors) SQL Patching tool complete on Fri Sep 23 15:27:50 2023