Apply Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server. Check the status of Database [oracle@stagdb1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Wed May 15 01:11:01 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected… Read more..

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ———————— peptestdb 19.0.0.0.0 READ WRITE Verify… Read more..

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989) Check the status of Database [oracle@stagdb1 ~]$ sqlplus / as sysdba SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ————————— DBSTAGE … Read more..

APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE Check the status of Database SQL> select instance_name, version, open_mode from v$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ————————— testdb1 19.0.0.0.0 READ WRITE Check the last updated OPatch [oracle@testdb… Read more..

Export the data by using the where clause from Pluggable database in Oracle 19C Check the database status SQL> select instance_name,version, open_mode from V$instance, v$database; INSTANCE_NAME VERSION OPEN_MODE —————- ————————– prod1db 19.0.0.0.0 READ WRITE Check the CDB & PDB… Read more..