Expensive All,
apply
Jul-2024 RU patches on Oracle 19C :
1.
We have to test current opatch patch model
& final utilized RU
patches and database variations.
2.
Obtain the most recent RU patch from
steel ink/ assist.oracle.com
Oracle Database
19c Proactive Patch Info (Doc ID 2521164.1)
>> downloaded newest Jul 2024 RU patch (36582781 )
>> downloaded newest Opath utility .( 6880688)
set up the utility: Opatch
utility set up/ improve
———————————————————–
To put in this patch, Please extract
the file “zipped file” utilizing unzip or winzip,
relying upon the platform. It’s best to
extract the zip file instantly below the
ORACLE_HOME. Please comply with the
following steps for extracting the zip file of OPatch.
(1)
Please take a backup of ORACLE_HOME/OPatch right into a devoted backup
location.
(2) Please be sure no listing
ORACLE_HOME/OPatch exist.
(3) Please unzip the OPatch downloaded
zip into ORACLE_HOME listing.
To test the model of the opatch
utility put in within the above step,
go to the OPatch listing and run
“opatch model”.
Current : opatch model is : 12.2.0.1.17
After improve :
opatch model >> 12.2.0.1.43
3.
Copy the obtain patch to oracle
database server.
Through the use of Winscp I’ve copied the patches to my
database server.
4. Interim Patch
Battle Detection and Decision.
unzip p36582781_190000_Linux-x86-64.zip
cd 36582781
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Test the invalids earlier than patch apply
SQL> choose rely(*) from dba_objects the place standing="INVALID";
COUNT(*)
----------
0
SQL> present pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL> alter session set container=pdb;
Session altered.
SQL> choose rely(*) from dba_objects the place standing="INVALID";
COUNT(*)
----------
0
Take database residence and
orainventory backups .. ****
5.
Shutdown the database occasion and listener
companies ..
lsnrctl cease LISTENER
6.
Apply JUL 2024 RU patch utilizing opatch utility
./opatch apply
7.
Begin database and listener
8.
Run datapatch verbose
9.
Launch the occasion .
Test the database open or not and ship communication
mail to staff…
Thanks,
Srinivas
