Pricey All,
On this submit i’m going to share Apply OCT-2024 RU patches on Oracle 19C Non-RAC Database step-by-step course of.
Oracle Database
19c Proactive Patch Info (Doc ID 2521164.1)
>>
downloaded newest OCT 2024 RU patch (36912597)
>>
downloaded newest Opatch utility .( 6880688)
Excessive degree steps
Ø Examine the prevailing patches.
Ø Obtain the patches from assist.oracle.com
Ø Copy to the database server and
unzip.
Ø Improve opatch utility to as
per beneficial degree ( readme file )
Ø Unzip the principle RU patch and do the
patch evaluation.
$cd 36912597
$/u01/app/oracle/product/19.0.0/db_home/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -ph ./
> Take downtime to use the RU patches. ( DEV >> TEST >> UAT >> PROD )
>Demo
occasion approvals not required ..
>>> Take database full backup and different essential configuration information backups.
Ex :: Rman / chilly
/ scorching
Ø Take Invalid rely ( full
invalid objects ).
Ø Ø Cease the db listener and database.9PM
IST 10PM IST )
Ø Ø Apply the patch utilizing opatch
command.
Ø Ø Begin the database and db listener.
Ø ØTake
invalid rely and examine earlier than patch and after patch, if any points compile
invalids.
Ø Ø Nonetheless extra invalids contact oracle
assist.
No invalids
..
Ø Run the datapatch verbose (* its
ought to run submit RU / CPU / main patches )
Ø Launch the occasion for enterprise.
>>> Click on on
the patch and obtain .. choose the OS as per your surroundings , right here im utilizing
Linux X86-64 bit ..for 19C database.
Click on on
obtain then
Click on on
Zip file .. 1.7G
As soon as its
downloaded add to database server and proceed additional steps as per the
readme file .
Oracle®
Database Patch 36912597 – Database Launch Replace 19.25.0.0.241015
Obtain
newest Opatch utility
After copy
the each patches to database server .. fist improve the opatch utility model
then begin apply the OCT-2024 CPU
unzip p36912597_
cd 36912597
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
unzip -d p36912597__
cd 36912597
opatch apply
Multitenant (CDB/PDB) Oracle Database
Sqlplus /
as sysdba
Startup
alter pluggable database all open;
cd $ORACLE_HOME/OPatch
./datapatch -sanity_checks
./datapatch -verbose
Notice :
- Any
(pluggable) database that has invalid objects after the execution of
datapatch ought to have catcon.pl run to revalidate
these objects. For instance:
2. export PATH=$PATH:$ORACLE_HOME/bin
3. cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b
utlrp -d
Excessive degree steps
Ø Examine the prevailing patches.
Ø Obtain the patches from assist.oracle.com
Ø Copy the patch zip file to the database server and
unzip.
Ø Improve opatch utility to as
per beneficial degree ( readme file )
Ø Unzip the principle RU patch and do the
patch evaluation.
$cd 36912597
/u01/app/oracle/product/19.0.0/db_home/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Ø Take downtime to use the RU patches. ( DEV >> TEST >> UAT >> PROD )
Demo occasion approvals not required ..
Ø Take database full backup and different essential configuration information backups.
ex: forms of backups in oracle database .. Rman / chilly/ scorching
Ø Take Invalid rely ( full invalid objects ).
Ø Cease the db listener and database.(9PM IST to 10PM IST )
Ø Apply the patch utilizing opatch command.
Ø Begin the database and db listener.
Take invalid rely and examine earlier than patch and after patch, if any points compile invalids.
Ø Nonetheless extra invalids contact oracle assist. No invalids
>>Ø Run the datapatch verbose (* its ought to run submit RU / CPU / main patches )
Ø Launch the occasion for enterprise.
If any invalids compile it utilizing beneath command.$ORACLE_HOME/rdbms/admin utlrp.sql
If any errors after apply the patch you may rollback the patch utilizing beneath command.opatch rollback -id 36912597
Thanks,
Srini
