Search This Blog

Total Pageviews

Tuesday, 1 February 2011

How to check the Opatch version?

-bash-3.00$ pwd
/opt/oracle/product/10.2/OPatch
-bash-3.00$ ./opatch version
Invoking OPatch 10.2.0.4.3

OPatch Version: 10.2.0.4.3

OPatch succeeded.
-bash-3.00$ ./opatch -help
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Usage: opatch [ -help ] [ -r[eport] ] [ command ]

command := apply
lsinventory
napply
nrollback
rollback
query
version
prereq
util

:= -help Displays the help message for the command.
-report Print the actions without executing.

example:
'opatch -help'
'opatch apply -help'
'opatch lsinventory -help'
'opatch napply -help'
'opatch nrollback -help'
'opatch rollback -help'
'opatch prereq -help'
'opatch util -help'



OPatch succeeded.




Rolling back a patch

In case if a patch did not fix the issue or if you has applied wrong patch to oracle home, you can always rollback the patch using following comamnd.

opatch rollback -id


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



wget --http-user=oracle@***.com --http-password=****** --no-check-certificate --output-document=p6880880_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip"


wget --http-user=oracle@***.com --http-password=****** --no-check-certificate --output-document=p6880880_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip"
--2024-02-14 08:45:07--  https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip
Resolving updates.oracle.com (updates.oracle.com)... 2a02:26f0:fd00:d81::4425, 2a02:26f0:fd00:da5::4425, 23.64.16.120
Connecting to updates.oracle.com (updates.oracle.com)|2a02:26f0:fd00:d81::4425|:443... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to [updates.oracle.com]:443.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://aru-akam.oracle.com/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip?FilePath=/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip&File=p6880880_190000_Linux-x86-64.zip&params=YzJJaDdtRGpHb3l5WkpLQk1wYm9lQTphcnU9MjU1NDEzNjcmZW1haWw9bWFzdGVyYnJhbmQub2Vicy5tYWlsQHJhY2tzcGFjZS5jb20mZmlsZV9pZD0xMTIwMTQwOTAmcGF0Y2hfZmlsZT1wNjg4MDg4MF8xOTAwMDBfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9Ty1PUkFDTEVUQVJAUkFDS1NQQUNFLkNPTSZzaXplPTEyNzYyOTAzNCZjb250ZXh0PUFAMTArSEBwaHhwYWFydWxwcmRtdDAyLm10cHJvZGFlcGh4LnByb2RhcHBwaHhhZXYxLm9yYWNsZXZjbi5jb20rUEAmZG93bmxvYWRfaWQ9NDcyMTQ2ODgw&AuthParam=1707900432_f1301fcf05d1d8df2909dce6e2664958 [following]
--2024-02-14 08:45:12--  https://aru-akam.oracle.com/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip?FilePath=/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip&File=p6880880_190000_Linux-x86-64.zip&params=YzJJaDdtRGpHb3l5WkpLQk1wYm9lQTphcnU9MjU1NDEzNjcmZW1haWw9bWFzdGVyYnJhbmQub2Vicy5tYWlsQHJhY2tzcGFjZS5jb20mZmlsZV9pZD0xMTIwMTQwOTAmcGF0Y2hfZmlsZT1wNjg4MDg4MF8xOTAwMDBfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9Ty1PUkFDTEVUQVJAUkFDS1NQQUNFLkNPTSZzaXplPTEyNzYyOTAzNCZjb250ZXh0PUFAMTArSEBwaHhwYWFydWxwcmRtdDAyLm10cHJvZGFlcGh4LnByb2RhcHBwaHhhZXYxLm9yYWNsZXZjbi5jb20rUEAmZG93bmxvYWRfaWQ9NDcyMTQ2ODgw&AuthParam=1707900432_f1301fcf05d1d8df2909dce6e2664958
Resolving aru-akam.oracle.com (aru-akam.oracle.com)... 23.39.224.75
Connecting to aru-akam.oracle.com (aru-akam.oracle.com)|23.39.224.75|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 127629034 (122M) [application/zip]
Saving to: ‘p6880880_190000_Linux-x86-64.zip’

100%[================================================================================================================================================================================================>] 127,629,034 85.7MB/s   in 1.4s

2024-02-14 08:45:14 (85.7 MB/s) - ‘p6880880_190000_Linux-x86-64.zip’ saved [127629034/127629034]

[anuj@ ~]$ ls -ltr
total 1139892

-rw-------. 1 anuj2804  users  127629034 Jan 24 04:26 p6880880_190000_Linux-x86-64.zip




[anuj2804@cbast1 ~]$

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

 mv OPatch OPatch-14-06-2025
 echo $ORACLE_HOME
 unzip -qqd $ORACLE_HOME /home/oracle/p6880880_190000_Linux-x86-64.zip

[oracle@ora19 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46

OPatch succeeded.

=======




as root <<<<<<<<<<<<<<

+ASM1:/u01/app/19.0.0/grid
[root@ora-rac1 grid]# . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/grid


[root@ora-rac1 grid]# ls -ltr /home/grid
total 3561552
-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 Jan 20  2025 37257886
-rw-r--r--  1 grid oinstall  131979857 Jan 21  2025 p6880880_190000_Linux-x86-64.zip
-rw-rw-r--  1 grid oinstall    2654673 Jan 21  2025 PatchSearch.xml
-rw-r--r--  1 grid oinstall 3512303969 Dec 29 09:00 p37257886_190000_Linux-x86-64.zip

[root@ora-rac1 grid]# echo $ORACLE_HOME
/u01/app/19.0.0/grid
mv OPatch OPatch-29-12-2025


[root@ora-rac1 grid]# unzip -qqd $ORACLE_HOME /home/grid/p6880880_190000_Linux-x86-64.zip

[root@ora-rac1 grid]# pwd
/u01/app/19.0.0/grid
[root@ora-rac1 grid]# ls -ld O*
drwxr-x---  15 root root     4096 Dec 23  2024 OPatch
drwxrwxr-x. 14 grid oinstall 4096 Nov 29  2024 OPatch-29-12-2025


chown -R grid:oinstall $ORACLE_HOME/OPatch

[root@ora-rac1 grid]# chown -R grid:oinstall $ORACLE_HOME/OPatch
[root@ora-rac1 grid]# ls -ld O*
drwxr-x---  15 grid oinstall 4096 Dec 23  2024 OPatch
drwxrwxr-x. 14 grid oinstall 4096 Nov 29  2024 OPatch-29-12-2025



6 comments:

Anuj Singh said...

How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)

Anuj Singh said...

cp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0/db_1
cd /u01/app/oracle/product/11.2.0/db_1
mv OPatch OPatch_15032017
unzip p6880880_112000_Linux-x86-64.zip

echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/OPatch
$ORACLE_HOME/OPatch/opatch version

$ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.15
OPatch succeeded.

Anuj Singh said...

Quick Reference to Patch Numbers for Database/GI PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)

Anuj Singh said...

https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=185vnznvt3_1180&_afrLoop=35817960135843

Anuj Singh said...

[oracle@ora19 bin]$ cd ..
/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@ora19 dbhome_1]$ mv OPatch OPatch.`date +"%Y"-"%m"-"%d"`
[oracle@ora19 dbhome_1]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1

Anuj Singh said...

export PATH=$ORACLE_HOME/OPatch:$PATH

Oracle DBA

anuj blog Archive