Oracle SCN Verification & Recovery

1. Problem Identification

The following error occurs when attempting to bring a datafile online or open the database:

ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '+DATA/UGARY/DATAFILE/sysaux.3716.1204521933'

2. Diagnostic Analysis (Control File Dump)

To identify the exact SCN status from the control file, generate a trace file:

SQL> ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';
     
=========================


to find diag dir
====================================

set linesize 300 pagesize 300
col name    form a25
col value   form a80 wrap
select * from v$diag_info
where 1=1
and NAME='Diag Trace'
order by name
/

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

find /u01/app/oracle/diag/rdbms/ugary/ugary/trace -type f -exec grep -il "Controlfile Checkpointed" {} \;
/u01/app/oracle/diag/rdbms/ugary/ugary/trace/ugary_ora_14641.trc  <<<<<<<   file name 


cat ugary_ora_14641.trc| grep -i -A7 -A7  "DATA FILE"

====

If the Stop SCN is 0xffff.ffffffff, the database is in a consistent state and ready to be opened. 
However, if the Stop SCN is any other value,you must convert it from Hexadecimal to Decimal to determine the specific SCN required for recovery.


DATA FILE RECORDS
***************************************************************************
 (size = 520, compat size = 520, section max = 200, section in-use = 3,
  last-recid= 34, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 7, numrecs = 200)
DATA FILE #1:
  name #4: +DATA/UGARY/DATAFILE/system.3761.1204521925
creation size=384000 block size=8192 status=0xe flg=0x1 head=4 tail=4 dup=1
 pdb_id 0, tablespace 0, index=1 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
 Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
 Creation Checkpointed at scn:  0x0000.00000008 01/25/2022 05:22:48
--
DATA FILE #2:
  name #5: +DATA/UGARY/DATAFILE/sysaux.3716.1204521933
creation size=256000 block size=8192 status=0xe flg=0x1 head=5 tail=5 dup=1
 pdb_id 0, tablespace 1, index=2 krfil=2 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
 Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
 Creation Checkpointed at scn:  0x0000.00000a8b 01/25/2022 05:22:51
--
DATA FILE #3:
  name #6: +DATA/UGARY/DATAFILE/undotbs1.4734.1204521933
creation size=38400 block size=8192 status=0xe flg=0x1 head=6 tail=6 dup=1
 pdb_id 0, tablespace 2, index=3 krfil=3 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
 Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
 Creation Checkpointed at scn:  0x0000.00000de6 01/25/2022 05:22:52

         
    

Trace File Indicators:

• Stop Scn: 0xffff.ffffffff STILL FUZZY - Database crashed or is currently open. Recovery Required.
• Stop Scn: 0x0000.003A58D9 CLEAN - Database shut down normally. Ready to open.

3. SCN Conversion Table

Use these methods to convert Hexadecimal SCNs from trace files into Decimal values for recovery analysis.

Method	Command	Example Result
SQL*Plus	SELECT TO_NUMBER('3A58D9', 'XXXXXXXXXXXX') FROM DUAL;	3823833
Unix/Linux	echo "ibase=16; 3A58D9" | bc	3823833
Online	BinaryHexConverter.com	3823833

4. RMAN Recovery Procedure

Execute these commands in the RMAN prompt to resolve ORA-01113:

# Connect to RMAN
$ rman target /

# Run Recovery
RMAN> RECOVER DATAFILE 2;

# Bring File Online
RMAN> ALTER DATABASE DATAFILE 2 ONLINE;

5. Automated Monitoring Query

Run this query to check the consistency of all datafiles at once:

==================================
SET PAGESIZE 100 LINESIZE 300 FEEDBACK OFF
COLUMN name FORMAT a50
COLUMN status FORMAT a20
SELECT CON_ID, file#, name, checkpoint_change#, last_change#,
CASE
WHEN last_change# IS NULL THEN 'STILL FUZZY/OPEN'
ELSE 'CLEAN SHUTDOWN'
END AS status
FROM v$datafile; ----- ==================================
--Identifying the Required Archive Logs If RMAN asks for a specific log, you can use the Decimal SCN you calculated earlier (3823833) to find which log is needed: SQL SELECT THREAD#, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE# FROM V$ARCHIVED_LOG WHERE 3823833 BETWEEN FIRST_CHANGE# AND NEXT_CHANGE#; Complete Database Recovery (Alternative) If multiple files are "Fuzzy" (as seen in your v$datafile query), it is often better to recover the whole database: SQL # From RMAN target / STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN; set linesize 200 pagesize 200
column member format a50
column first_change# format 99999999999999999999
column next_change# format 99999999999999999999
select l.thread#,
lf.group#,
lf.member,
trunc(l.bytes/1024/1024) as size_mb,
l.status,
l.archived,
lf.type,
lf.is_recovery_dest_file as rdf,
l.sequence#,
l.first_change#,
l.next_change#
from v$logfile lf , v$log l
where l.group# = lf.group#
order by l.thread#,lf.group#, lf.member;

---

Internal Database Documentation - Generated for UGARY Environment

oracle impdp example for pdb

expdp with password !!!!

$expdp anuj directory=DP_EXP_DIR dumpfile=emp.dmp logfile=emp.log encryption=all encryption_mode=password encryption_password=vihaan123 tables=anuj.emp

Export: Release 12.2.0.1.0 - Production on Tue Jan 20 07:17:17 2026

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
Password:




Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "ANUJ"."SYS_EXPORT_TABLE_01":  anuj/******** directory=DP_EXP_DIR dumpfile=emp.dmp logfile=emp.log encryption=all encryption_mode=password encryption_password=******** tables=anuj.emp
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "ANUJ"."EMP"                                145.2 MB 3670016 rows
Master table "ANUJ"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ANUJ.SYS_EXPORT_TABLE_01 is:
  /dumps/dp_exp_dir/emp.dmp
Job "ANUJ"."SYS_EXPORT_TABLE_01" successfully completed at Tue Jan 20 07:21:50 2026 elapsed 0 00:04:21


=====

only metadata 

expdp \'/as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=expdp_TST_FULL_DDL.log FULL=Y CONTENT=METADATA_ONLY PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS EXCLUDE=AUDIT_TRAILS

Export: Release 12.2.0.1.0 - Production on Tue Jan 20 08:56:28 2026

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=expdp_TST_FULL_DDL.log FULL=Y CONTENT=METADATA_ONLY PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS EXCLUDE=AUDIT_TRAILS
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABAS

Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /dumps/dp_exp_dir/expdp_TST_FULL_DDL_01.dmp
  /dumps/dp_exp_dir/expdp_TST_FULL_DDL_02.dmp
  /dumps/dp_exp_dir/expdp_TST_FULL_DDL_03.dmp
  /dumps/dp_exp_dir/expdp_TST_FULL_DDL_04.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Tue Jan 20 09:05:26 2026 elapsed 0 00:08:52

====

[oracle@ibrac01:~] $impdp \'/as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=impdp_TST_FULL_DDL.log sqlfile=full.sql

Import: Release 12.2.0.1.0 - Production on Tue Jan 20 09:30:05 2026

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_01":  "/******** AS SYSDBA" directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=impdp_TST_FULL_DDL.log sqlfile=full.sql
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
P

===

PDB 

nohup impdp system/vihaan@TESTORC1 directory=DATA_PUMP_EXP1 dumpfile=ANUJ_JAN071125.dmp logfile=impdp_CHECK_12JAN2025_.log  REMAP_TABLESPACE=USERS:ANUJTB schemas=ANUJ CLUSTER=N full=N status=10 metrics=Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y EXCLUDE=STATISTICS &

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

example !!!!!!!!!!!!!!!




w
expdp \'/ as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_tables.dmp logfile=expdp_tables.log INCLUDE=table:\"in \(select table_name from all_tables where table_name like \'IMG_%\' or table_name like \'%HIST%\'\)\"

w
expdp \'/ as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_tables.dmp logfile=expdp_tables.log schemas=DATA INCLUDE=table:\"in \(select table_name from all_tables where table_name like \'%TRACKER%\'\)\"

w
expdp \'/ as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_tables.dmp logfile=expdp_tables.log schemas=DATA INCLUDE=table:\"in \(select table_name from all_tables where table_name=\'CSI_TRACKER\'\)\"


 expdp \'/ as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_tables.dmp logfile=expdp_tables.log schemas=DATA INCLUDE=table:\"in \(select table_name from all_tables where table_name=\'C_TRACKER\'\)\"


w working Table 
expdp \'/ as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_tables2.dmp logfile=expdp_tables2.log  tables=DATA.CSI_TRACKER,DATA.T



w  ********************************
 expdp  vihaan/vihaan123@anujpdb directory=anujdp schemas=vihaan  dumpfile=vihaan.dmp  FLASHBACK_TIME=\"TO_TIMESTAMP\(\'20-05-2015 08:24:25\', \'DD-MM-YYYY HH24:MI:SS\'\)\"


expdp \'/as sysdba\' directory=DP_EXP_DIR  tables=scott.emp dumpfile=expdp_emp_%U.dmp logfile=expdp_emp.log estimate=STATISTICS PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS

Export: Release 12.2.0.1.0 - Production on Tue Apr 21 01:55:46 2026

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_TABLE_01":  "/******** AS SYSDBA" directory=DP_EXP_DIR tables=scott.emp dumpfile=expdp_emp_%U.dmp logfile=expdp_emp.log estimate=STATISTICS PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.  estimated "SCOTT"."EMP"                               4.683 KB
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                                   0 KB       0 rows
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TABLE
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
  /dumps/dp_exp_dir/expdp_emp_01.dmp
  /dumps/dp_exp_dir/expdp_emp_02.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Tue Apr 21 01:56:07 2026 elapsed 0 00:00:18

[oracle@ibrac01:~] $ls -ltr /dumps/dp_exp_dir/expdp_emp_01.dmp
-rw-r----- 1 oracle oinstall 8192 Apr 21 01:56 /dumps/dp_exp_dir/expdp_emp_01.dmp


Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
  /dumps/dp_exp_dir/expdp_emp_01.dmp
  /dumps/dp_exp_dir/expdp_emp_02.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Tue Apr 21 01:56:07 2026 elapsed 0 00:00:18




remap option !!!!

impdp \'/as sysdba\' REMAP_SCHEMA=SCOTT:SCOTT1 REMAP_TABLE=emp:emp2 directory=DP_EXP_DIR dumpfile=expdp_emp_%U.dmp logfile=impdp_emp1.log



[oracle@irac01:~] $sqlme

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 21 02:33:41 2026

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select count(*) from scott1.emp2;

  COUNT(*)
----------
         0

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

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]$

Oracle database Patch 38291812 - Database Release Update 19.29.0.0

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.

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>