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

 


4 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

Oracle DBA

anuj blog Archive