Anuj Singh Oracle DBA

Wednesday, 7 January 2026

GI RELEASE UPDATE 21.20.0.0.0

KA958

Oracle Database Release Updates (RUs)

                         database   grid !!!
OCT2025 (21.20.0.0.0)	38371122	38370812	38273738

Tuesday, 6 January 2026

Patch 38068980 - Database Release Update 21.19.0.0.250715




Patch 38068980 - Database Release Update 21.19.0.0.250715

 
Patch 38068980

Simple Search  Advanced Search  Quick Links  Saved Searches 

Description	DATABASE RELEASE UPDATE 21.19.0.0.0
Product	Oracle Database Family
Release	
Oracle Database 21.0.0.0.0	
Platform or Language Click for more information about this option	
Linux x86-64
Last Updated	15-JUL-2025
Size	1.5G (1607637461 bytes)


For each Oracle RAC database home and the GI home that are being patched, as the home owner, 
extract the OPatch utility.

For exact instructions to install OPatch, follow the OPatch readme.

A new feature has been added to OPatch to increase performance by deleting inactive patches. 

See My Oracle Support document 2942102.1 OPatch 12.2.0.1.37+ 
Introduces a New Feature to Delete 

Inactive Patches in the ORACLE_HOME/.patch_storage directory.

For information about OPatch documentation, including any known issues, see My Oracle Support document 293369.1 
Primary Note For OPatch.



unzip p38068980__.zip
cd 38068980
opatch prereq CheckConflictAgainstOHWithDetail -ph ./


******************************************************

[oracle@oragrid 38068980]$ date
Tue  6 Jan 10:27:19 GMT 2026


/home/oracle/38068980

[oracle@oragrid 38068980]$ pwd
/home/oracle/38068980

 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch prereq CheckSystemSpace -ph ./


[oracle@oragrid 38068980]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/21.0.0/dbhome1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-25-39AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@oragrid 38068980]$




[oracle@oragrid 38068980]$ date
Tue  6 Jan 10:27:19 GMT 2026
[oracle@oragrid 38068980]$ opatch prereq CheckSystemSpace -ph ./

Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/21.0.0/dbhome1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-28-09AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.




[oracle@oragrid ~]$ cd 38068980
[oracle@oragrid 38068980]$ pwd
/home/oracle/38068980
[oracle@oragrid 38068980]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/21.0.0/dbhome1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-25-39AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@oragrid 38068980]$ date
Tue  6 Jan 10:27:19 GMT 2026
[oracle@oragrid 38068980]$ opatch prereq CheckSystemSpace -ph ./

Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/21.0.0/dbhome1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-28-09AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.
[oracle@oragrid 38068980]$
[oracle@oragrid 38068980]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/21.0.0/dbhome1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-29-03AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   38068980

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/21.0.0/dbhome1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '38068980' to OH '/u01/app/oracle/product/21.0.0/dbhome1'
ApplySession: Optional component(s) [ oracle.network.gsm, 21.0.0.0.0 ] , [ oracle.tfa, 21.0.0.0.0 ] , [ oracle.network.cman, 21.0.0.0.0 ] , [ oracle.precomp.companion, 21.0.0.0.0 ] , [ oracle.sdo.companion, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifxm, 21.0.0.0.0 ] , [ oracle.duma, 21.0.0.0.0 ] , [ oracle.rdbms.ic, 21.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 21.0.0.0.0 ] , [ oracle.pg4appc, 21.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 21.0.0.0.0 ] , [ oracle.sysman.ccr.client, 21.0.0.0.0 ] , [ oracle.oraolap.mgmt, 21.0.0.0.0 ] , [ oracle.net.cman, 21.0.0.0.0 ] , [ oracle.ons.cclient, 21.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 21.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 21.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 21.0.0.0.0 ] , [ oracle.oid.client, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 21.0.0.0.0 ] , [ oracle.jdk, 1.8.0.271.00 ] , [ oracle.pg4mq, 21.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 21.0.0.0.0...

Patching component oracle.network.rsf, 21.0.0.0.0...

Patching component oracle.rdbms.rsf, 21.0.0.0.0...

Patching component oracle.rdbms.util, 21.0.0.0.0...

Patching component oracle.blaslapack, 21.0.0.0.0...

Patching component oracle.buildtools.rsf, 21.0.0.0.0...

Patching component oracle.ctx, 21.0.0.0.0...

Patching component oracle.dbdev, 21.0.0.0.0...

Patching component oracle.dbjava.ic, 21.0.0.0.0...

Patching component oracle.dbjava.jdbc, 21.0.0.0.0...

Patching component oracle.dbjava.ucp, 21.0.0.0.0...

Patching component oracle.has.common.cvu, 21.0.0.0.0...

Patching component oracle.javavm.server, 21.0.0.0.0...

Patching component oracle.javavm.server.core, 21.0.0.0.0...

Patching component oracle.ldap.owm, 21.0.0.0.0...

Patching component oracle.ldap.rsf, 21.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 21.0.0.0.0...

Patching component oracle.ldap.security.osdt, 21.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 21.0.0.0.0...

Patching component oracle.oraml.server, 21.0.0.0.0...

Patching component oracle.perlint, 5.32.0.0.0...

Patching component oracle.python, 3.9.5.0.0...

Patching component oracle.rdbms.crs, 21.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 21.0.0.0.0...

Patching component oracle.rdbms.deconfig, 21.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 21.0.0.0.0...

Patching component oracle.rdbms.rman, 21.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 21.0.0.0.0...

Patching component oracle.sdo, 21.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 21.0.0.0.0...

Patching component oracle.sqlplus, 21.0.0.0.0...

Patching component oracle.tfa.db, 21.0.0.0.0...

Patching component oracle.rdbms.hs_common, 21.0.0.0.0...

Patching component oracle.ons.ic, 21.0.0.0.0...

Patching component oracle.xdk.xquery, 21.0.0.0.0...

Patching component oracle.assistants.deconfig, 21.0.0.0.0...

Patching component oracle.xdk.rsf, 21.0.0.0.0...

Patching component oracle.ons, 21.0.0.0.0...

Patching component oracle.network.listener, 21.0.0.0.0...

Patching component oracle.xdk, 21.0.0.0.0...

Patching component oracle.xdk.parser.java, 21.0.0.0.0...

Patching component oracle.precomp.rsf, 21.0.0.0.0...

Patching component oracle.ovm, 21.0.0.0.0...

Patching component oracle.assistants.acf, 21.0.0.0.0...

Patching component oracle.assistants.server, 21.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 21.0.0.0.0...

Patching component oracle.rdbms.oci, 21.0.0.0.0...

Patching component oracle.ctx.rsf, 21.0.0.0.0...

Patching component oracle.ctx.atg, 21.0.0.0.0...

Patching component oracle.odbc, 21.0.0.0.0...

Patching component oracle.ldap.client, 21.0.0.0.0...

Patching component oracle.oracore.rsf, 21.0.0.0.0...

Patching component oracle.sqlplus.ic, 21.0.0.0.0...

Patching component oracle.usm.deconfig, 21.0.0.0.0...

Patching component oracle.rdbms.lbac, 21.0.0.0.0...

Patching component oracle.rdbms.dv, 21.0.0.0.0...

Patching component oracle.ldap.ssl, 21.0.0.0.0...

Patching component oracle.sdo.locator, 21.0.0.0.0...

Patching component oracle.rdbms.scheduler, 21.0.0.0.0...

Patching component oracle.precomp.lang, 21.0.0.0.0...

Patching component oracle.precomp.common, 21.0.0.0.0...

Patching component oracle.jdk, 1.8.0.291.09...

Patching component oracle.precomp.common.core, 21.0.0.0.0...

Patching component oracle.rdbms.install.common, 21.0.0.0.0...
Patch 38068980 successfully applied.
Log file location: /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-29-03AM_1.log

OPatch succeeded.
[oracle@oragrid 38068980]$





SQL> alter pluggable database all open;



cd $ORACLE_HOME/OPatch



cd $ORACLE_HOME/OPatch
./datapatch -verbose
./datapatch -sanity_checks (optional)

Oracle 21c dbca



dbca create database !!!!


Update Kernel Parameters (as root)
Open /etc/sysctl.conf and set the following values. These are calculated to allow 
Oracle to use up to 16GB of your 18GB for shared memory (SGA):

kernel.shmmax: 17179869184 (16GB in bytes)

kernel.shmall: 4194304 (16GB / 4096 page size)

Bash

# Apply these commands as root or with sudo
echo "kernel.shmmax = 17179869184" >> /etc/sysctl.conf
echo "kernel.shmall = 4194304" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf

# Load the changes
sysctl -p



[root@oragrid ~]# ssh -X oracle@192.168.1.106
oracle@192.168.1.106's password:
Activate the web console with: systemctl enable --now cockpit.socket

Last login: Tue Jan  6 10:59:47 2026 from 192.168.1.106
[oracle@oragrid ~]$ /u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v16mpc -sid v16mpc -sysPassword sys \
> -systemPassword sys -createAsContainerDatabase true \
> -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba \
> -pdbAdminPassword password -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA \
> -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE \
> -totalmemory 26096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 \
> -automaticmemorymanagement FALSE \
> -templateName /u01/app/oracle/product/21.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[WARNING] [DBT-11209] Current available memory is less than the required available memory (26,096MB) for creating the database.
   CAUSE: Following nodes do not have required available memory :
 Node:oragrid           Available memory:13.6285GB (1.429052E7KB)


****************


reduce the sga !!!

/u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v16mpc -sid v16mpc -sysPassword sys \
> -systemPassword sys -createAsContainerDatabase true \
> -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba \
> -pdbAdminPassword password -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA \
> -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE \
> -totalmemory 26096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 \
> -automaticmemorymanagement FALSE \
> -templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc



[oracle@oragrid ~]$ /u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent -gdbName v16mpc -sid v16mpc -sysPassword sys -systemPassword sys -createAsContainerDatabase true -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba -pdbAdminPassword password -emConfiguration LOCAL -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE -totalmemory 4096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 -automaticmemorymanagement FALSE -templateName /u01/app/oracle/product/21.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc


[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
7% complete
Registering database with Oracle Restart
11% complete
Copying database files
33% complete
Creating and starting Oracle instance
35% complete
38% complete
45% complete
48% complete
Completing Database Creation
53% complete
55% complete
56% complete
Creating Pluggable Databases
60% complete
78% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/v16mpc.
Data
a.



[oracle@oragrid trace]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Tue Jan 6 12:35:09 2026
Version 21.19.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.19.0.0.0

SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/V16MPC/PARAMETERFILE/spf
                                                 ile.377.1221826957
SQL>



                                               ile.377.1221826957
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 V16MPCPDB                      READ WRITE NO
SQL>



[oracle@oragrid oracle]$ cd homes/
[oracle@oragrid homes]$ pwd
/u01/app/oracle/homes

[oracle@oragrid homes]$ ls -ltr
total 0
drwxr-x--- 14 oracle oinstall 172 Dec 24  2024 OraDB21Home1


[oracle@oragrid homes]$ cd OraDB21Home1/
[oracle@oragrid OraDB21Home1]$ ls -ltr
total 0



drwxr-x--- 4 oracle oinstall 30 Dec 24  2024 rdbms
drwxr-x--- 5 oracle oinstall 43 Dec 24  2024 network
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 mgw
drwxr-x--- 2 oracle oinstall  6 Dec 24  2024 install
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 hs
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 drdaas
drwxr-x--- 3 oracle oinstall 18 Dec 24  2024 assistants
drwxr-x--T 4 oracle oinstall 33 Dec 24  2024 log
drwxr-x--- 3 oracle oinstall 22 Dec 24  2024 cfgtoollogs
drwxr-x--- 2 oracle oinstall  6 Dec 30  2024 dbs
drwxr-x--- 3 oracle oinstall 22 Jan  6 11:58 sqlpatch
drwxr-xr-x 5 oracle asmadmin 49 Jan  6 12:24 admin
[oracle@oragrid OraDB21Home1]$


drwxr-x--- 4 oracle oinstall 30 Dec 24  2024 rdbms
drwxr-x--- 5 oracle oinstall 43 Dec 24  2024 network
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 mgw
drwxr-x--- 2 oracle oinstall  6 Dec 24  2024 install
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 hs
drwxr-x--- 3 oracle oinstall 19 Dec 24  2024 drdaas
drwxr-x--- 3 oracle oinstall 18 Dec 24  2024 assistants
drwxr-x--T 4 oracle oinstall 33 Dec 24  2024 log
drwxr-x--- 3 oracle oinstall 22 Dec 24  2024 cfgtoollogs
drwxr-x--- 2 oracle oinstall  6 Dec 30  2024 dbs
drwxr-x--- 3 oracle oinstall 22 Jan  6 11:58 sqlpatch
drwxr-xr-x 5 oracle asmadmin 49 Jan  6 12:24 admin
[oracle@oragrid OraDB21Home1]$

[oracle@oragrid OraDB21Home1]$ pwd
/u01/app/oracle/homes/OraDB21Home1

[oracle@oragrid OraDB21Home1]$

Monday, 5 January 2026

Oracle database Patch 38291812 - Database Release Update 19.29.0.0




Oracle database Patch 38291812 - Database Release Update 19.29.0.0


/home/oracle/38291812

38291812


export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@ora19 38291812]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-09-20AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812



===========

[oracle@ora19 38291812]$ opatch prereq CheckSystemSpace -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-32-06AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.
[oracle@ora19 38291812]$


******************
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812
[oracle@ora19 38291812]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-47-26AM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-49-40AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   38291812

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
y

Applying interim patch '38291812' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.blaslapack, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.rsf, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.tfa.db, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.network.aso, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.xdk.server, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.rat, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.rdbms.dm, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...

Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 38291812 successfully applied.
Sub-set patch [37960098] has become inactive due to the application of a super-set patch [38291812].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-49-40AM_1.log

OPatch succeeded.
[oracle@ora19 38291812]$ y
bash: y: command not found...
[oracle@ora19 38291812]$


*****************************************************************************************************

[oracle@ora19 38291812]$ sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:02:56 2026
Version 19.29.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup ;
ORACLE instance started.

Total System Global Area  910160856 bytes
Fixed Size                  9184216 bytes
Variable Size             578813952 bytes
Database Buffers          314572800 bytes
Redo Buffers                7589888 bytes
Database mounted.
Database opened.
SQL>  alter pluggable database all open;

Pluggable database altered.

SQL>


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 VIHAAN27                       READ WRITE NO
SQL>


 cd $ORACLE_HOME/OPatch

[oracle@ora19 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ora19 OPatch]$


[oracle@ora19 OPatch]$ ls -ltr data*
-rwxr-x--- 1 oracle oinstall 589 Oct  7 15:11 datapatch
[oracle@ora19 OPatch]$ ./datapatch -sanity_checks
SQL Patching sanity checks version 19.29.0.0.0 on Mon 05 Jan 2026 12:07:36 GMT
Copyright (c) 2021, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sanity_checks_20260105_120736_9801.log

Running checks
JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:

Check: Database component status - INFO
  There should be no INVALID components prior patching due to risk of potential errors.
  Listed components have a non-valid status.
  For INVALID components: Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects and restore component status.
  For other non-valid status, depending on patch content warnings may be returned.
  VIHAAN27:
    | COMPONENT | STATUS  |
    |-----------+---------|
    |    SDO    | LOADING |
    |-----------+---------|
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - ERROR
  Temp tablespaces must have sufficient space for patching. Minimum recommended space is 2GB.
  Tablespace is above 80% of used space or it has less than 2GB of space left.
  Ensure there is adequate tablespace for patching. Note suggested quantities are an estimated minimum size value, it is strongly recommended to adjust the data file maximum size as needed based on testing. Refer to the section "Managing Data Files and Temp Files" in the Oracle Database Administrator's Guide for details on managing data file operations.
  VIHAAN27:
    | TABLESPACE_NAME  | AUTO_EXTENSIBLE | TABLESPACE_SIZE | FREE_TABLESPACE | USAGE |
    |------------------+-----------------+-----------------+-----------------+-------|
    | ODITEST_ODI_TEMP |       YES       |      1000       |       999       |  .1   |
    |------------------+-----------------+-----------------+-----------------+-------|
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - WARNING
  Patching the database without recent data dictionary statistics gathered may lead to performance issues.
  Data dictionary statistics are older than 7 days.
  Run the following queries to start gathering the dictionary statistics:
    EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
    EXEC DBMS_SYSTEM.GATHER_FIXED_OBJECTS_STATS;
  Refer to MOS 457926.1 for more details.
  PDB$SEED:
    |     LATEST      |        OPERATION        |  STATUS   |
    |-----------------+-------------------------+-----------|
    | 25-JUN-25 10:56 | gather_dictionary_stats | COMPLETED |
    |-----------------+-------------------------+-----------|
Check: Scheduled Jobs - OK
Check: GoldenGate triggers - OK
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Java Virtual Machine Enable - OK
Check: Oracle Database Vault Enabled - OK
Check: Queryable Inventory database directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - OK
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OK

Refer to MOS Note 2975965.1 and debug log
/u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sanity_checks_debug_20260105_120736_9801.log

SQL Patching sanity checks completed on Mon 05 Jan 2026 12:07:42 GMT
[oracle@ora19 OPatch]$


**************************************************


[oracle@ora19 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.29.0.0.0 Production on Mon Jan  5 12:08:29 2026
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9824_2026_01_05_12_08_29/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

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 interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.29.0.0.0 Release_Update 251002005342: Installed
  PDB CDB$ROOT:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.28.02.803708
  PDB PDB$SEED:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.33.02.268396
  PDB VIHAAN27:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.32.54.258125

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED VIHAAN27
    No interim patches need to be rolled back
    Patch 38291812 (Database Release Update : 19.29.0.0.251021 (38291812)):
      Apply from 19.28.0.0.0 Release_Update 250705030417 to 19.29.0.0.0 Release_Update 251002005342
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 38291812 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_CDBROOT_2026Jan05_12_11_57.log (no errors)
Patch 38291812 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_PDBSEED_2026Jan05_12_13_00.log (no errors)
Patch 38291812 apply (pdb VIHAAN27): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_VIHAAN27_2026Jan05_12_13_00.log (no errors)
SQL Patching tool complete on Mon Jan  5 12:13:50 2026

[oracle@ora19 OPatch]$



 sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:22:48 2026
Version 19.29.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.29.0.0.0  <<<<<<





set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from dba_registry_sqlpatch  
order by 1




======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)

FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU

ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000


3 rows selected.



set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)||
'CON_ID.....................: '||CON_ID
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from cdb_registry_sqlpatch
 order by 1



======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: WITH ERRORS
ACTION TIME................: 14-JUN-25 11.05.28.279212

DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37642901

PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 25-JUN-25 11.12.32.980376
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0

SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY

STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.32.54.258125
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 3

======================================================

INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0

TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 4
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.13.29.590889
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)

FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 3


7 rows selected.

Sunday, 4 January 2026

Oracle database Patch 37960098 - Database Release Update 19.28.0.0.250715




Oracle database Patch 37960098 - Database Release Update 19.28.0.0.250715





Current oracle version 19.27.0.0.0
[anuj@ora19 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 4 15:37:51 2026
Version 19.27.0.0.0

Copyright (c) 1982, 2024, Oracle.  All rights reserved.






[oracle@ora19 dbhome_1]$
[oracle@ora19 dbhome_1]$
[oracle@ora19 dbhome_1]$

[oracle@ora19 dbhome_1]$ cd
[oracle@ora19 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@ora19 ~]$ ls -ltr
total 10505204
-rw-r--r--. 1 oracle oinstall 3059705302 Jun 14  2025 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 oracle oinstall   25093206 Jun 14  2025 p6880880_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall      19952 Jun 14  2025 db.rsp
-rw-r--r--. 1 oracle oinstall 2802140309 Jun 25  2025 V1045400-01.zip
-rw-r--r--. 1 oracle oinstall  242755651 Jun 25  2025 jdk-24_linux-x64_bin.rpm
-rw-r-----. 1 oracle oinstall       1188 Jun 25  2025 odi.rsp
drwxr-xr-x  5 oracle oinstall         81 Jul 15 12:45 37960098
drwxr-xr-x  5 oracle oinstall         81 Oct  6 18:36 38291812
-rw-rw-r--  1 oracle oinstall    2485534 Oct 21 16:37 PatchSearch.xml
-rw-r--r--  1 oracle oinstall 2295670251 Jan  4 16:14 p38291812_190000_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall 2256549942 Jan  4 16:17 p37960098_190000_Linux-x86-64.zip  <<<<<<<---- 
-rw-r--r--  1 oracle oinstall   72884918 Jan  4 16:40 p6880880_190000_Linux-x86-64.zip

[oracle@ora19 ~]$ cd 37960098
[oracle@ora19 37960098]$ pwd
/home/oracle/37960098
[oracle@ora19 37960098]$ pwd
/home/oracle/37960098
[oracle@ora19 37960098]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-04_16-52-31PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@ora19 37960098]$ ls -ltr
total 104
drwxr-x--- 48 oracle oinstall  4096 Jul 15 12:45 files
-rw-r--r--  1 oracle oinstall    21 Jul 15 12:49 README.txt
drwxr-x---  3 oracle oinstall    20 Jul 15 12:49 etc
drwxr-x---  3 oracle oinstall    21 Jul 15 12:49 custom
-rw-r--r--  1 oracle oinstall 97600 Jul 15 15:48 README.html

[oracle@ora19 37960098]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 4 16:55:48 2026
Version 19.27.0.0.0

Copyright (c) 1982, 2024, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0

SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
[oracle@ora19 37960098]$ pwd
/home/oracle/37960098



[oracle@ora19 dbhome_1]$ cd
[oracle@ora19 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH



[oracle@ora19 37960098]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-04_16-57-47PM_1.log

Verifying environment and performing prerequisite checks...



--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-04_17-00-50PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   37960098

Do you want to proceed? [y|n]
Could not recognize input. Please re-enter.
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37960098' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.blaslapack, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.rsf, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.tfa.db, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.network.aso, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...

Patching component oracle.rdbms.rat, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.rdbms.dm, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...

Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.xdk.server, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 37960098 successfully applied.
Sub-set patch [37642901] has become inactive due to the application of a super-set patch [37960098].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-04_17-00-50PM_1.log

OPatch succeeded.
[oracle@ora19 37960098]$



[oracle@ora19 37960098]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 4 17:18:28 2026
Version 19.28.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup ;
ORACLE instance started.

Total System Global Area  910160856 bytes
Fixed Size                  9184216 bytes
Variable Size             524288000 bytes
Database Buffers          369098752 bytes
Redo Buffers                7589888 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;

Pluggable database altered.

SQL>


[oracle@ora19 OPatch]$ ./datapatch -sanity_checks
SQL Patching sanity checks version 19.28.0.0.0 on Sun 04 Jan 2026 17:20:47 GMT
Copyright (c) 2021, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260104_172047_39405/sanity_checks_20260104_172047_39405.log

Running checks
JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260104_172047_39405/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:

Check: Database component status - INFO
  There should be no INVALID components prior patching due to risk of potential errors.
  Listed components have a non-valid status.
  For INVALID components: Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects and restore component status.
  For other non-valid status, depending on patch content warnings may be returned.
  VIHAAN27:
    | COMPONENT | STATUS  |
    |-----------+---------|
    |    SDO    | LOADING |
    |-----------+---------|
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - ERROR
  Temp tablespaces must have sufficient space for patching. Minimum recommended space is 2GB.
  Tablespace is above 80% of used space or it has less than 2GB of space left.
  Ensure there is adequate tablespace for patching. Note suggested quantities are an estimated minimum size value, it is strongly recommended to adjust the data file maximum size as needed based on testing. Refer to the section "Managing Data Files and Temp Files" in the Oracle Database Administrator's Guide for details on managing data file operations.
  VIHAAN27:
    | TABLESPACE_NAME  | AUTO_EXTENSIBLE | TABLESPACE_SIZE | FREE_TABLESPACE | USAGE |
    |------------------+-----------------+-----------------+-----------------+-------|
    | ODITEST_ODI_TEMP |       YES       |      1000       |       999       |  .1   |
    |------------------+-----------------+-----------------+-----------------+-------|
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - OK
Check: Scheduled Jobs - OK
Check: GoldenGate triggers - OK
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Oracle Database Vault Enabled - OK
Check: Queryable Inventory dba directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - OK
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OK

Refer to MOS Note 2975965.1 and debug log
/u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260104_172047_39405/sanity_checks_debug_20260104_172047_39405.log

SQL Patching sanity checks completed on Sun 04 Jan 2026 17:21:08 GMT
[oracle@ora19 OPatch]$



[oracle@ora19 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.28.0.0.0 Production on Sun Jan  4 17:22:31 2026
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40030_2026_01_04_17_22_31/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

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 interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.28.0.0.0 Release_Update 250705030417: Installed
  PDB CDB$ROOT:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 14-JUN-25 11.00.09.198524
  PDB PDB$SEED:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 25-JUN-25 10.57.08.184703
  PDB VIHAAN27:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 25-JUN-25 11.12.32.980376

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED VIHAAN27
    No interim patches need to be rolled back
    Patch 37960098 (Database Release Update : 19.28.0.0.250715 (37960098)):
      Apply from 19.27.0.0.0 Release_Update 250406131139 to 19.28.0.0.0 Release_Update 250705030417
    No interim patches need to be applied

Installing patches...




Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 37960098 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37960098/27635722/37960098_apply_VIHAAN_CDBROOT_2026Jan04_17_26_19.log (no errors)
Patch 37960098 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37960098/27635722/37960098_apply_VIHAAN_PDBSEED_2026Jan04_17_28_52.log (no errors)
Patch 37960098 apply (pdb VIHAAN27): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37960098/27635722/37960098_apply_VIHAAN_VIHAAN27_2026Jan04_17_28_52.log (no errors)
SQL Patching tool complete on Sun Jan  4 17:34:55 2026




[oracle@ora19 OPatch]$ opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch  37960098     : applied on Sun Jan 04 17:08:29 GMT 2026
Patch  29585399     : applied on Thu Apr 18 08:21:33 BST 2019


[oracle@ora19 OPatch]$



 sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 4 17:38:40 2026
Version 19.28.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.28.0.0.0  <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  now .28

SQL>

Posted by Anuj Singh at Sunday, January 04, 2026 No comments:

Wednesday, 31 December 2025

Oracle Grid patch 19.27

Oracle Grid patch 19.27 19.27 Release Update ls -ltr /home/grid total 4000140 -rwxrwxrwx 1 root root 394 Nov 28 2024 asmdisk.sh -rwxr-xr-x 1 root root 33333 Nov 28 2024 sshUserSetup.sh -rw-r--r-- 1 grid oinstall 36664 Nov 29 2024 grid.rsp drwxr-x--- 15 grid oinstall 4096 Dec 23 2024 OPatch drwxr-x--- 8 grid oinstall 159 Apr 15 2025 37641958 -rw-rw-r-- 1 grid oinstall 2816591 Apr 16 2025 PatchSearch.xml -rw-r--r-- 1 grid oinstall 131979857 Dec 29 10:26 p6880880_190000_Linux-x86-64.zip -rw-r--r-- 1 grid oinstall 3961245851 Dec 30 09:13 p37641958_190000_Linux-x86-64.zip ---- patch No ###################################################################################################### $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37654975 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37643161 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37762426 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/36758186 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37642901 [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome1.txt Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_10-58-09AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37654975 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-04-01AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@ora-rac1 ~]$ cat /home/grid/patch_list_gihome1.txt /home/grid/37641958/37654975 /home/grid/37641958/37643161 /home/grid/37641958/37762426 /home/grid/37641958/36758186 /home/grid/37641958/37642901 [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37654975 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-05-18AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37643161 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-06-01AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37762426 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-06-46AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/36758186 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-07-29AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@ora-rac1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37642901 Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_11-08-12AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. ============ [grid@ora-rac1 ~]$ cat /home/grid/patch_list_gihome1.txt /home/grid/37641958/37654975 /home/grid/37641958/37643161 /home/grid/37641958/37762426 /home/grid/37641958/36758186 /home/grid/37641958/37642901 $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome1.txt Oracle Interim Patch Installer version 12.2.0.1.45 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.45 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-12-30_10-58-09AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. ========= analyze [root@ora-rac1 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze OPatchauto session is initiated at Tue Dec 30 11:31:01 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_11-31-22AM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_11-32-10AM.log The id for this session is 421F Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:ora-rac1 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log ============== as root export ORACLE_HOME=/u01/app/19.0.0/grid export GRID_HOME=/u01/app/19.0.0/grid export PATH=$ORACLE_HOME/OPatch:$PATH [root@ora-rac1 grid]# pwd /home/grid [root@ora-rac1 grid]# cd 37641958 [root@ora-rac1 37641958]# ls -ltr total 164 drwxr-x--- 5 grid oinstall 62 Apr 15 2025 37654975 drwxr-x--- 5 grid oinstall 62 Apr 15 2025 37643161 drwxr-x--- 4 grid oinstall 48 Apr 15 2025 37762426 drwxr-x--- 4 grid oinstall 48 Apr 15 2025 36758186 drwxr-x--- 4 grid oinstall 67 Apr 15 2025 37642901 -rw-r--r-- 1 grid oinstall 0 Apr 15 2025 README.txt drwxr-x--- 2 grid oinstall 4096 Apr 15 2025 automation -rw-r--r-- 1 grid oinstall 152522 Apr 15 2025 README.html -rw-rw-r-- 1 grid oinstall 5824 Apr 15 2025 bundle.xml [root@ora-rac1 37641958]# echo $GRID_HOME [root@ora-rac1 37641958]# ls -ltr $GRID_HOME/OPatch/opatchauto -rwxr-x--- 1 grid oinstall 1763 Dec 23 2024 /u01/app/19.0.0/grid/OPatch/opatchauto [root@ora-rac1 37641958]# pwd /home/grid/37641958 [root@ora-rac1 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze [root@ora-rac1 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze OPatchauto session is initiated at Tue Dec 30 11:31:01 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_11-31-22AM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_11-32-10AM.log The id for this session is 421F Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:ora-rac1 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-33-42AM_1.log OPatchauto session completed at Tue Dec 30 11:40:06 2025 Time taken to complete the session 8 minutes, 46 seconds [root@ora-rac1 37641958]# [root@ora-rac1 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ OPatchauto session is initiated at Tue Dec 30 11:53:42 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_11-54-05AM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_11-54-42AM.log The id for this session is IZ5I Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/ora-rac1/crsconfig/crs_prepatch_apply_inplace_ora-rac1_2025-12-30_12-04-45AM.log CRS service brought down successfully on home /u01/app/19.0.0/grid Start applying binary patch on home /u01/app/19.0.0/grid Binary patch applied successfully on home /u01/app/19.0.0/grid Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.0.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/ora-rac1/crsconfig/crs_postpatch_apply_inplace_ora-rac1_2025-12-30_12-30-58AM.log CRS service started successfully on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:ora-rac1 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_11-57-11AM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY applied: Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-08-20PM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-08-20PM_1.log Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-08-20PM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-08-20PM_1.log OPatchauto session completed at Tue Dec 30 12:41:46 2025 Time taken to complete the session 47 minutes, 43 seconds export ORACLE_HOME=/u01/app/19.0.0/grid export GRID_HOME=/u01/app/19.0.0/grid export PATH=$ORACLE_HOME/OPatch:$PATH opatch lspatches [grid@ora-rac1 ~]$ [grid@ora-rac1 ~]$ opatch lspatches [grid@ora-rac1 ~]$ opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) ============================================================================================ as grid [grid@ora-rac1 ~]$ scp p37641958_190000_Linux-x86-64.zip ora-rac2:~ p37641958_190000_Linux-x86-64.zip [grid@ora-rac2 ~]$ df -Ph Filesystem Size Used Avail Use% Mounted on devtmpfs 3.8G 0 3.8G 0% /dev tmpfs 3.8G 1.1G 2.7G 30% /dev/shm tmpfs 3.8G 9.4M 3.8G 1% /run tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup /dev/sda2 19G 7.0G 12G 38% / /dev/mapper/centos-tmp 4.7G 80M 4.6G 2% /tmp /dev/mapper/centos-home 75G 3.9G 71G 6% /home /dev/mapper/centos-u01 43G 13G 31G 30% /u01 tmpfs 768M 12K 768M 1% /run/user/42 tmpfs 768M 0 768M 0% /run/user/54323 [grid@ora-rac2 ~]$ still old --- [grid@ora-rac2 ~]$ opatch lspatches 37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387) 37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031) 37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638) 37260974;Database Release Update : 19.26.0.0.250121 (37260974) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) OPatch succeeded. ************************************************************************************************************************************************ now on node 2 as grid [grid@ora-rac1 ~]$ scp p37641958_190000_Linux-x86-64.zip ora-rac2:~ p37641958_190000_Linux-x86-64.zip [root@ora-rac2 grid]# export ORACLE_HOME=/u01/app/19.0.0/grid [root@ora-rac2 grid]# export GRID_HOME=/u01/app/19.0.0/grid [root@ora-rac2 grid]# export PATH=$ORACLE_HOME/OPatch:$PATH [root@ora-rac2 grid]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze^C [root@ora-rac2 grid]# cd /home/grid/37641958/ [root@ora-rac2 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze OPatchauto session is initiated at Tue Dec 30 12:54:42 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_12-55-23PM.log. [root@ora-rac2 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze OPatchauto session is initiated at Tue Dec 30 12:54:42 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_12-55-23PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_12-56-28PM.log The id for this session is MICW Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:ora-rac2 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log OPatchauto session completed at Tue Dec 30 13:04:09 2025 Time taken to complete the session 8 minutes, 49 seconds === [root@ora-rac2 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ OPatchauto session is initiated at Tue Dec 30 13:04:23 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_01-04-43PM.log. [grid@ora-rac1 ~]$ [grid@ora-rac1 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid [grid@ora-rac1 ~]$ export GRID_HOME=/u01/app/19.0.0/grid [grid@ora-rac1 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [grid@ora-rac1 ~]$ opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) OPatch succeeded. [grid@ora-rac1 ~]$ [grid@ora-rac1 ~]$ [grid@ora-rac1 ~]$ ssh ora-rac2 Last login: Tue Dec 30 12:45:53 2025 [grid@ora-rac2 ~]$ [grid@ora-rac2 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid [grid@ora-rac2 ~]$ export GRID_HOME=/u01/app/19.0.0/grid [grid@ora-rac2 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [grid@ora-rac2 ~]$ opatch lspatches 37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387) 37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031) 37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638) 37260974;Database Release Update : 19.26.0.0.250121 (37260974) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) OPatch succeeded. [grid@ora-rac2 ~]$ [grid@ora-rac2 ~]$ [grid@ora-rac2 ~]$ su Password: [root@ora-rac2 grid]# export ORACLE_HOME=/u01/app/19.0.0/grid [root@ora-rac2 grid]# export GRID_HOME=/u01/app/19.0.0/grid [root@ora-rac2 grid]# export PATH=$ORACLE_HOME/OPatch:$PATH [root@ora-rac2 grid]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze^C [root@ora-rac2 grid]# cd /home/grid/37641958/ [root@ora-rac2 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ -analyze OPatchauto session is initiated at Tue Dec 30 12:54:42 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_12-55-23PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_12-56-28PM.log The id for this session is MICW Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:ora-rac2 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_12-57-56PM_1.log OPatchauto session completed at Tue Dec 30 13:04:09 2025 Time taken to complete the session 8 minutes, 49 seconds [root@ora-rac2 37641958]# $GRID_HOME/OPatch/opatchauto apply /home/grid/37641958/ OPatchauto session is initiated at Tue Dec 30 13:04:23 2025 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-12-30_01-04-43PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-12-30_01-05-34PM.log The id for this session is 75RQ Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/ora-rac2/crsconfig/crs_prepatch_apply_inplace_ora-rac2_2025-12-30_01-13-38PM.log CRS service brought down successfully on home /u01/app/19.0.0/grid Start applying binary patch on home /u01/app/19.0.0/grid Binary patch applied successfully on home /u01/app/19.0.0/grid Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.0.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/ora-rac2/crsconfig/crs_postpatch_apply_inplace_ora-rac2_2025-12-30_01-34-58PM.log CRS service started successfully on home /u01/app/19.0.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:ora-rac2 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /home/grid/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_13-07-04PM_1.log Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid ==Following patches were SUCCESSFULLY applied: Patch: /home/grid/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_13-17-02PM_1.log Patch: /home/grid/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_13-17-02PM_1.log Patch: /home/grid/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_13-17-02PM_1.log Patch: /home/grid/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-12-30_13-17-02PM_1.log OPatchauto session completed at Tue Dec 30 13:45:03 2025 Time taken to complete the session 40 minutes, 22 seconds ========================================================== Last login: Tue Dec 30 14:48:40 2025 from 192.168.1.182 [oracle@ora-rac1 ~]$ su - grid Password: Last login: Tue Dec 30 14:51:18 GMT 2025 [grid@ora-rac1 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid [grid@ora-rac1 ~]$ export GRID_HOME=/u01/app/19.0.0/grid [grid@ora-rac1 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [grid@ora-rac1 ~]$ opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) OPatch succeeded. [grid@ora-rac1 ~]$ ssh ora-rac2 Last login: Tue Dec 30 14:41:45 2025 [grid@ora-rac2 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid [grid@ora-rac2 ~]$ export GRID_HOME=/u01/app/19.0.0/grid [grid@ora-rac2 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [grid@ora-rac2 ~]$ opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) OPatch succeeded. [grid@ora-rac2 ~]$ ====== As root: # cd Grid_home/crs/install # perl rootcrs.pl -unlock As the Oracle Grid Infrastructure for a Cluster owner: $ export ORACLE_HOME=Grid_home $ Grid_home/bin/relink As root again: # cd Grid_home/crs/install

Posted by Anuj Singh at Wednesday, December 31, 2025 No comments:

Sunday, 28 December 2025

Oracle Grid Infrastructure Upgrading Oracle Restart, 19c for Linux and Unix-Based Operating Systems

Oracle Grid Infrastructure Upgrading Oracle Restart, 19c for Linux and Unix-Based Operating Systems 1 Preparing to Upgrade Oracle Restart Before you upgrade Oracle Restart, determine the best upgrade path, and run the procedures that are described here to prepare for the upgrade. Oracle recommends that you test the upgrade process and prepare a backup strategy. • Options and Restrictions for Oracle Restart Upgrades Review these upgrade options and restrictions when you upgrade to Oracle Grid Infrastructure for a standalone server (Oracle Restart) 19c. • Checks to Complete Before Upgrading Oracle Restart Complete these preupgrade checks to avoid issues during the Oracle Restart upgrade process. • Installing the Oracle Database Preinstallation RPM Using ULN Use this procedure to subscribe to Unbreakable Linux Network (ULN) Oracle Linux channels for your Oracle software. • Creating a Copy of the Preinstallation Configuration File for the grid User Create a copy of the preinstallation configuration file for the grid user to set hard and soft limits for the operating system parameters. • Shutting Down the Database If your Oracle Database uses Oracle Automatic Storage Management (Oracle ASM) for storage, then shut down the database before upgrading Oracle Restart. • Upgrading Operating System for an Oracle Restart Server Complete this procedure on your Oracle Restart server to upgrade the operating system. Options and Restrictions for Oracle Restart Upgrades Review these upgrade options and restrictions when you upgrade to Oracle Grid Infrastructure for a standalone server (Oracle Restart) 19c. Supported upgrade paths for Oracle Restart for this release are: • Oracle Restart upgrade from 11g Release 2 (11.2.0.4) to Oracle Restart 19c. • Oracle Restart upgrade from 12c Release 1 (12.1.0.2) to Oracle Restart 19c. • Oracle Restart upgrade from 12c Release 2 (12.2) to Oracle Restart 19c. • Oracle Restart upgrade from 18c to Oracle Restart 19c. Restrictions for Oracle Restart Upgrades • Oracle Restart upgrades are always out-of-place upgrades. You cannot perform an inplace upgrade of Oracle Restart to an existing Grid home. • The same user that owned the earlier release of the Oracle Restart software must perform the Oracle Restart 19c upgrade. • Do not delete directories in the Grid home. For example, do not delete the directory Grid_home/OPatch. If you delete the directory, then the Oracle Restart installation owner 1-1 cannot use the OPatch utility to patch the Grid home, and OPatch displays the error message "'checkdir' error: cannot create Grid_home/OPatch". • The software in the 19c Oracle Restart home is not fully functional until the upgrade is complete. Running srvctl, crsctl, and other commands from the new Grid home are not supported until the rootupgrade.sh script is run and the upgrade is complete. • To manage databases in an existing earlier release database home during the Oracle Restart upgrade, use the srvctl utility from the existing database home. Checks to Complete Before Upgrading Oracle Restart Complete these preupgrade checks to avoid issues during the Oracle Restart upgrade process. 1. Review the new features for the Oracle Restart release to which you want to upgrade. 2. Ensure that you have all of the information you need for the upgrade. For example: • An Oracle base location for Oracle Restart. • An Oracle Restart home location that is different from your existing Oracle Restart home. • Privileged user operating system groups. • root user access, to run scripts as the root user during the upgrade. 3. Unset the $ORACLE_HOME, $ORACLE_BASE, and $ORACLE_SID environment variables because these environment variables are used during the upgrade. For example, as the grid user, run the following commands: For bash shell: $ unset ORACLE_HOME $ unset ORACLE_BASE $ unset ORACLE_SID For C shell: $ unsetenv ORACLE_HOME $ unsetenv ORACLE_BASE $ unsetenv ORACLE_SID 4. Ensure that the installation owner user profile, such as .profile or .cshrc, does not set any of these environment variables. 5. Unset any environment variables, such as ORA_NLS10 and TNS_ADMIN, set for the installation owner user that is connected with the Oracle software homes. 6. Ensure that the $ORACLE_HOME/bin path is removed from your PATH environment variable. Related Topics • Oracle Database New Features Guide Chapter 1 Checks to Complete Before Upgrading Oracle Restart 1-2 Installing the Oracle Database Preinstallation RPM Using ULN Use this procedure to subscribe to Unbreakable Linux Network (ULN) Oracle Linux channels for your Oracle software. To obtain Unbreakable Linux Network (ULN) support, subscribe to Oracle Linux channels, and to add the Oracle Linux channel that distributes the Oracle Database Preinstallation RPM: 1. Download the Oracle Linux ISO from one of the following websites: • Oracle yum https://yum.oracle.com/oracle-linux-isos.html • Oracle Software Delivery Cloud website: https://edelivery.oracle.com/linux Note: Ensure that you use the latest available update release for Oracle Linux. 2. Register your server with Unbreakable Linux Network (ULN). By default, you are registered for the Oracle Linux Latest channel for your operating system and hardware. • Oracle Linux 7 https://docs.oracle.com/en/operating-systems/oracle-linux/uln-user/ • Oracle Linux 8 and Oracle Linux 9 https://docs.oracle.com/en/operating-systems/oracle-linux/software-management/ 3. Log in to Unbreakable Linux Network: https://linux.oracle.com 4. Start a terminal session and enter the following command as root, depending on your platform. For example: • Oracle Linux 7 # yum install oracle-database-preinstall-19c Note: Use the -y option if you want yum to skip the package confirmation prompt. • Oracle Linux 8 and Oracle Linux 9 # dnf install oracle-database-preinstall-19c You should see output indicating that you have subscribed to the Oracle Linux channel, and that packages are being installed. Chapter 1 Installing the Oracle Database Preinstallation RPM Using ULN 1-3 The Oracle Database Preinstallation RPM automatically creates a standard (not roleallocated) Oracle installation owner and groups, and sets up other kernel configuration settings as required for Oracle installations. 5. Check the RPM log file to review the system configuration changes. For example: /var/log/oracle-database-preinstall-19c/backup/timestamp/orakernel.log 6. Repeat steps 1 through 4 on all other servers in your cluster. If you have a premier support subscription, you can enable Ksplice to provide zero downtime patching. Refer to the Ksplice User's Guide for installation instructions: https://docs.oracle.com/en/operating-systems/oracle-linux/ksplice-user/ Creating a Copy of the Preinstallation Configuration File for the grid User Create a copy of the preinstallation configuration file for the grid user to set hard and soft limits for the operating system parameters. 1. As the root user, go to the /etc/security/limits.d directory. # cd /etc/security/limits.d 2. Create a copy of the preinstallation configuration file for the grid user by replacing the oracle user with the grid user. # cat oracle-database-preinstall-19c.conf | sed 's/oracle /grid /g' > oracle-grid-user-preinstall-19c.conf 3. Delete the preinstallation configuration files for the earlier release. # rm -r -f oracle-database-preinstall-18c.conf oracle-grid-userpreinstall- 18c.conf Shutting Down the Database If your Oracle Database uses Oracle Automatic Storage Management (Oracle ASM) for storage, then shut down the database before upgrading Oracle Restart. 1. Log in as the oracle user. 2. Shut down the Oracle Database instance. $ Grid_home/bin/srvctl stop database –d database_unique_name 3. Ensure that your Oracle Database instance is shut down. $ Grid_home/bin/srvctl status database –d database_unique_name Database is not running. Chapter 1 Creating a Copy of the Preinstallation Configuration File for the grid User 1-4 Upgrading Operating System for an Oracle Restart Server Complete this procedure on your Oracle Restart server to upgrade the operating system. 1. As the root user, disable the automatic startup of Oracle High Availability Services, when the server reboots. # cd Grid_home/bin # ./crsctl disable has 2. Shut down the Oracle Restart stack on the server. # ./crsctl stop has 3. Verify all services are stopped before the operating system upgrade. # ./crsctl check has 4. Upgrade the operating system to a version that is supported for your Oracle Restart release. Refer to your operating system documentation for more information about upgrading the operating system. 5. Reboot your Oracle Restart server after the operating system upgrade is complete. 6. As the root user, add the Oracle Database libraries and lock the Oracle Restart installation. # cd Grid_home/rdbms/install/ # ./rootadd_rdbms.sh # cd Grid_home/crs/install # roothas.sh -lock 7. As the root user, enable the automatic startup of Oracle High Availability Services, when the server reboots. # cd Grid_home/bin # ./crsctl enable has 8. Start the Oracle Restart stack on the server. # ./crsctl start has 9. Connect to an SQL*Plus session and open the Pluggable Database (PDB). SQL> CONNECT / AS SYSDBA SQL> ALTER PLUGGABLE DATABASE pdb_name OPEN; 10. As the grid user, list all registered resources on your Oracle Restart server. $ Grid_home/bin/crsctl stat res -t Chapter 1 Upgrading Operating System for an Oracle Restart Server 1-5 2 Upgrading and Patching Oracle Restart Learn how to upgrade Oracle Restart to a later release using the out-of-place upgrade mode and install the patches. • Steps to Upgrade Oracle Restart Complete this procedure to upgrade Oracle Grid Infrastructure for a standalone server (Oracle Restart) from an earlier release. • Verifying the Oracle Restart Software Version After Upgrade Check the software release version of Oracle Restart after the upgrade. • Downloading Release Update Patches Download and install Release Updates (RU) and Monthly Recommended Patches (MRPs) patches for your Oracle software after you complete installation. • Patching Oracle Restart After you have upgraded to Oracle Grid Infrastructure for a standalone server (Oracle Restart) 19c, you can install individual software patches by downloading them from My Oracle Support. • Patching and Switching Oracle Grid Infrastructure Homes Perform an out-of-place Oracle Restart patching by switching from the current Oracle Grid Infrastructure home to a patched Oracle Grid Infrastructure home. • Unlocking and Deinstalling the Previous Release Grid Home After upgrading from previous releases, if you want to deinstall the previous release Grid home, then you must first change the permission and ownership of the previous release Grid home. Steps to Upgrade Oracle Restart Complete this procedure to upgrade Oracle Grid Infrastructure for a standalone server (Oracle Restart) from an earlier release. Be prepared to run root scripts before you start the upgrade. 1. As the grid user, download the Oracle Grid Infrastructure image files and extract the files to the Grid home. For example: mkdir -p /u01/app/grid/product/19.0.0/grid chown grid:oinstall /u01/app/grid/product/19.0.0/grid cd /u01/app/grid/product/19.0.0/grid unzip -q download_location/grid_home.zip download_location/grid_home.zip is the path of the downloaded Oracle Grid Infrastructure image file. 2-1 Note: • You must extract the image software into the directory where you want your new Grid home to be located. 2. Start the Oracle Grid Infrastructure wizard: $ /u01/app/grid/product/19.0.0/grid/gridSetup.sh 3. Select the Upgrade Oracle Grid Infrastructure option to upgrade Oracle Grid Infrastructure for a standalone server. 4. Select the installation options as prompted. 5. You can run root scripts, either automatically or manually. Oracle recommends that you configure root script automation, so that the rootupgrade.sh script can run automatically during the upgrade. At any time during the upgrade, if you have a question about what you are being asked to do, or what input you are required to provide during the upgrade, then click the Help button on the installer window. Verifying the Oracle Restart Software Version After Upgrade Check the software release version of Oracle Restart after the upgrade. 1. Log in as the grid user. 2. Verify that Oracle Restart 19c is in use after the upgrade. $ Grid_home/bin/crsctl query has releaseversion Oracle High Availability Services version on the local node is [19.0.0.0.0] Downloading Release Update Patches Download and install Release Updates (RU) and Monthly Recommended Patches (MRPs) patches for your Oracle software after you complete installation. Oracle provides quarterly updates in the form of Release Updates (RU) and Monthly Recommended Patches (MRPs). Oracle no longer releases patch sets. For more information, see My Oracle Support Note 2285040.1. Check the My Oracle Support website for required updates for your installation. 1. Use a web browser to view the My Oracle Support website: https://support.oracle.com 2. Log in to My Oracle Support website. Note: If you are not a My Oracle Support registered user, then click Register for My Oracle Support and register. Chapter 2 Verifying the Oracle Restart Software Version After Upgrade 2-2 3. On the main My Oracle Support page, click Patches & Updates. 4. In the Patch Search region, select Product or Family (Advanced). 5. On the Product or Family (Advanced) display, provide information about the product, release, and platform for which you want to obtain patches, and click Search. The Patch Search pane opens, displaying the results of your search. 6. Select the patch number and click ReadMe. The README page is displayed. It contains information about the patch and how to apply the patches to your installation. 7. Uncompress the Oracle patch updates that you downloaded from My Oracle Support. Related Topics • My Oracle Support note 888.1 • Patch Delivery Methods for Oracle Database Patching Oracle Restart After you have upgraded to Oracle Grid Infrastructure for a standalone server (Oracle Restart) 19c, you can install individual software patches by downloading them from My Oracle Support. 1. Download the patches that you want to apply from My Oracle Support: https://support.oracle.com Select the Patches and Updates tab to locate the patch. Oracle recommends that you select Recommended Patch Advisor, and enter the product group, release, and platform for your software. Place the patches in a shared directory that is accessible to all users. 2. Review the README file for the patch that you want to apply, and complete all of the required steps before installing the patch. 3. As the root user, go to the /OPatch directory in the Grid home. # cd /u01/app/grid/product/19.0.0/grid/OPatch 4. Install the version of the OPatch utility that is recommended in the README file for the patch. 5. Follow the instructions in the README file for the patch to apply the patch. # opatchauto apply patch_directory_location/patch_ID 6. As the grid user, verify the release patch number for your Oracle Restart. $ Grid_home/bin/crsctl query has releasepatch The release patch number changes only for Release Update (RU) and Release Update Revision (RUR) patches. Chapter 2 Patching Oracle Restart 2-3 Patching and Switching Oracle Grid Infrastructure Homes Perform an out-of-place Oracle Restart patching by switching from the current Oracle Grid Infrastructure home to a patched Oracle Grid Infrastructure home. 1. Download the 19.3 Oracle Grid Infrastructure base release image files. https://www.oracle.com/database/technologies/oracle-database-softwaredownloads. html#19c 2. As the grid user, extract the downloaded image files into a new Oracle Grid Infrastructure home directory. $ mkdir -p /u01/app/oracle/product/19.17.0/grid $ chown grid:oinstall /u01/app/oracle/product/19.17.0/grid $ cd /u01/app/oracle/product/19.17.0/grid $ unzip -q download_location/grid.zip Here: • /u01/app/oracle/product/19.17.0/grid is the new Grid home. • /u01/app/oracle/product/19.16.0/grid is the old Grid home. 3. As the grid user, download and install the latest version of the OPatch utility in the new Grid home. https://updates.oracle.com/download/6880880.html $ mv /u01/app/oracle/product/19.17.0/grid/OPatch /u01/app/oracle/product/ 19.17.0/grid/bak_OPatch $ unzip latest_Opatch.zip -d /u01/app/oracle/product/19.17.0/grid/ 4. Download the Oracle Database RU version that you want to apply from My Oracle Support. In this example, Oracle Database 19.17 RU. For more information, see, Downloading Release Update Patches 5. Start the Oracle Grid Infrastructure installer to perform a software-only Oracle Restart installation. You can apply the optional -applyRU or -applyOneOff flags to apply Release Updates (RUs) during the installation. $ /u01/app/oracle/product/19.17.0/grid/gridSetup.sh [-applyRU patch_directory_location] [-applyOneOffs comma_separated_list_of_patch_directory_locations] 6. Follow the steps in the configuration wizard to complete the Oracle Grid Infrastructure installation. 7. As the root user, run the following command to prepare the new home for the out-of-place patching: # /u01/app/oracle/product/19.17.0/grid/crs/install/roothas.sh -prepatch - dstcrshome /u01/app/oracle/product/19.17.0/grid This command does not shut down any services. Chapter 2 Patching and Switching Oracle Grid Infrastructure Homes 2-4 8. Run the following command to switch to the new Oracle Grid Infrastructure home and perform the out of place patching: # /u01/app/oracle/product/19.17.0/grid/crs/install/roothas.sh -postpatch - dstcrshome /u01/app/oracle/product/19.17.0/grid This command shuts down the old Oracle Grid Infrastructure home and starts resources from the new Oracle Grid Infrastructure home. All Oracle Grid Infrastructure services start running from the new Grid home. 9. Update the Oracle central inventory (oraInventory). $ /u01/app/oracle/product/19.17.0/grid/oui/bin/runInstaller - updateNodeList ORACLE_HOME=/u01/app/oracle/product/19.17.0/grid CRS=TRUE $ /u01/app/oracle/product/19.16.0/grid/oui/bin/runInstaller - updateNodeList ORACLE_HOME=/u01/app/oracle/product/19.16.0/grid CRS=FALSE 10. To switch back to the old Grid home: a. As the root user, run the prepatch script. # Old_GI_Home/crs/install/roothas.sh -prepatch -dstcrshome Old_GI_Home b. As the grid user, run the postpatch script. # Old_GI_Home/crs/install/roothas.sh -postpatch -dstcrshome Old_GI_Home c. Update the Oracle central inventory (oraInventory). $ /u01/app/oracle/product/19.16.0/grid/oui/bin/runInstaller - updateNodeList ORACLE_HOME=/u01/app/oracle/product/19.16.0/grid CRS=TRUE $ /u01/app/oracle/product/19.17.0/grid/oui/bin/runInstaller - updateNodeList ORACLE_HOME=/u01/app/oracle/product/19.17.0/grid CRS=FALSE Unlocking and Deinstalling the Previous Release Grid Home After upgrading from previous releases, if you want to deinstall the previous release Grid home, then you must first change the permission and ownership of the previous release Grid home. 1. As the root user, unlock the previous release Grid home. # /u01/app/oracle/product/18.0.0/grid/crs/install/roothas.sh -unlock - dstcrshome previous_release_Grid_home 2. After you change the permissions and ownership of the previous release Grid home, log in as the Oracle Grid Infrastructure installation owner (grid, in the preceding example), and use the deinstall command from the previous release Grid home $ORACLE_HOME/ deinstall directory. Chapter 2 Unlocking and Deinstalling the Previous Release Grid Home 2-5 Caution: You must use the deinstall command from the same release to remove Oracle software. Do not run the deinstall command from a later release to remove Oracle software from an earlier release. For example, do not run the deinstall command from the 19.0.0.0.0 Grid home to remove Oracle software from an existing 18.0.0.0.0 Grid home. Chapter 2 Unlocking and Deinstalling the Previous Release Grid Home 2-6 3 Downgrading Oracle Restart You can restore Oracle Grid Infrastructure for a standalone server (Oracle Restart) to the previous release after a successful or a failed upgrade. • Options and Restrictions for Oracle Restart Downgrades Review these downgrade options and restrictions when you downgrade Oracle Restart to an earlier release after a successful or a failed upgrade. • Downgrading Oracle Restart Use this procedure to deconfigure and downgrade Oracle Restart, or to troubleshoot Oracle Restart installation errors. Options and Restrictions for Oracle Restart Downgrades Review these downgrade options and restrictions when you downgrade Oracle Restart to an earlier release after a successful or a failed upgrade. Downgrade options include the following earlier releases: • Oracle Restart downgrade to Oracle Restart 18c. • Oracle Restart downgrade to Oracle Restart 12c Release 2 (12.2). • Oracle Restart downgrade to Oracle Restart 12c Release 1 (12.1.0.2). • Oracle Restart downgrade to Oracle Restart 11g Release 2 (11.2.0.4). Restrictions for Oracle Restart Downgrades • You can downgrade Oracle Restart to an earlier release only if you did not make any configuration changes after the upgrade. • You can only downgrade to the Oracle Restart release you upgraded from. For example, if you upgraded from Oracle Restart 18c to Oracle Restart 19c, then you can only downgrade to Oracle Restart 18c. Downgrading Oracle Restart Use this procedure to deconfigure and downgrade Oracle Restart, or to troubleshoot Oracle Restart installation errors. Running roothas.sh with the command flags -deconfig -force enables you to deconfigure Oracle Restart without removing the installed binaries. This feature is useful if you encounter an error during an Oracle Grid Infrastructure for a standalone server installation. For example, when you run the root.sh command, and find a missing operating system package. By running roothas.sh -deconfig -force, you can deconfigure Oracle Restart, correct the cause of the error, and then run root.sh again. 3-1 1. As the oracle user, create a backup of the SPFILE to a PFILE. CREATE PFILE='/u01/app/oracle/product/19.0.0/dbhome_1/dbs/test_init.ora' FROM SPFILE='/u01/oracle/dbs/test_spfile.ora'; 2. List all the Oracle Databases on the server with their version, unique name of the database, and Oracle home information. $ srvctl config database -home 3. Downgrade Oracle Database. Refer to Oracle Database Upgrade Guide for more information about required pre-downgrade tasks, downgrade tasks, post-downgrade tasks, and compatibility information. Note: Downgrade Oracle Database only if the Oracle Database version is higher than the Oracle Restart version to which you are downgrading Oracle Restart. 4. As the oracle user, downgrade the Oracle Restart resources corresponding to the Oracle Database, only if you have downgraded your Oracle Database. $ srvctl downgrade database -d db_unique_name -oraclehome $ORACLE_HOME -t to_version 5. Inspect the Oracle Restart configuration of each database, service, and listener. $ srvctl config database -db db_unique_name $ srvctl config service -db db_unique_name $ srvctl config listener -listener listener_name Make a note of the configuration information and use this information when adding the components back to Oracle Restart. 6. Stop all databases and listeners that are running before you deconfigure or downgrade Oracle Restart. $ srvctl stop database -db db_unique_name $ srvctl stop listener [-listener listener_name] 7. As the root user, run roothas.sh with the -deconfig -force flags to deconfigure Oracle Restart. # /u01/app/oracle/product/19.0.0/grid/crs/install/roothas.sh -deconfig - force 8. As the grid user, update the Oracle central inventory (oraInventory). $ /u01/app/oracle/product/19.0.0/grid/oui/bin/runInstaller -updateNodeList -silent ORACLE_HOME=upgraded_Grid_home -local CRS=false Chapter 3 Downgrading Oracle Restart 3-2 9. As the root user, run roothas.sh with the -unlock flag to unlock the previous release Oracle Restart home. # /u01/app/oracle/product/18.0.0/grid/crs/install/roothas.sh -unlock - dstcrshome previous_release_Grid_home 10. As the grid user, reconfigure the previous release Oracle Restart home using the gridSetup.sh command. $ /u01/app/oracle/product/18.0.0/grid/gridSetup.sh 11. As the oracle user, add the components back to Oracle Restart with the same attributes that you noted down before deconfiguring Oracle Restart. a. Add Oracle Database to the Oracle Restart configuration. $ srvctl add database -db db_unique_name -oraclehome Oracle_home b. Add the listener to the Oracle Restart configuration. $ srvctl add listener -listener listener_name -oraclehome Oracle_home For the -oraclehome parameter, provide the Oracle home path from which the listener was running before the downgrade. c. Add each service to the database, using the srvctl add service command. $ srvctl add service -db db_unique_name -service service_name_list Related Topics • Oracle Database Upgrade Guide Chapter 3 Downgrading Oracle Restart 3-3

Posted by Anuj Singh at Sunday, December 28, 2025 No comments:

Anuj Singh Oracle DBA

Search This Blog

Total Pageviews

Wednesday, 7 January 2026

GI RELEASE UPDATE 21.20.0.0.0

Tuesday, 6 January 2026

Patch 38068980 - Database Release Update 21.19.0.0.250715

Oracle 21c dbca

Monday, 5 January 2026

Oracle database Patch 38291812 - Database Release Update 19.29.0.0

Sunday, 4 January 2026

Oracle database Patch 37960098 - Database Release Update 19.28.0.0.250715

Wednesday, 31 December 2025

Oracle Grid patch 19.27

Sunday, 28 December 2025

Oracle Grid Infrastructure Upgrading Oracle Restart, 19c for Linux and Unix-Based Operating Systems

Oracle DBA

anuj blog Archive