DBA Hub

📋Steps in this guide1/10

Useful OPATCH commands - DBACLASS DBACLASS

1. list inventory details of patch. $ORACLE_HOME/OPatch/opatch lsinventory 2. list patchsets applied : $ORACLE_HOME/OPatch/opatch lspatches 3. Find opatch version: $ORACLE_HOME/OPatch/opatch version 4. Find details of a particular patch(before applying): $ORACLE_HOME/OPatch/opatch query -all {PATCH_PATH} $ORACLE_HOME/OPatch/opatch query -all /software/PSUPATCH/30089984 5. Apply a patch to RDBMS HO

oracle configurationintermediate
by OracleDba
12 views
1

1. list inventory details of patch.

Code/Command (click line numbers to comment):

1
$ORACLE_HOME/OPatch/opatch lsinventory
2

2. list patchsets applied :

Code/Command (click line numbers to comment):

1
$ORACLE_HOME/OPatch/opatch lspatches
3

3. Find opatch version:

Code/Command (click line numbers to comment):

1
$ORACLE_HOME/OPatch/opatch version
4

4. Find details of a particular patch(before applying):

Code/Command (click line numbers to comment):

1
2
3
$ORACLE_HOME/OPatch/opatch query -all {PATCH_PATH}

$ORACLE_HOME/OPatch/opatch query -all /software/PSUPATCH/30089984
5

5. Apply a patch to RDBMS HOME:

Code/Command (click line numbers to comment):

1
2
3
4
-- You may need to shutdown the database and listener services:

cd /SOFTWARE/PSUPATCH/30089984 -- Go to the patch path:
$ORACLE_HOME/OPatch/opatch apply
6

6. Rollback an patch from RDBMS HOME:

Code/Command (click line numbers to comment):

1
2
$ORACLE_HOME/OPatch/opatch rollback -id [patch_id]
$ORACLE_HOME/OPatch/opatch rollback -id 30089984
7

7. Apply one off patch in grid_home:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
root # $GI_HOME/crs/install/rootcrs.sh -prepatch. 


oracle$ cd /SOFTWARE/PSUPATCH/30089984 -- Go to the patch path:
oracle$ $GRID_HOME/OPatch/opatch apply


root# $GI_HOME/crs/install/rootcrs.sh -postpatch
8

8. Check conflict against ORACLE_HOME

Code/Command (click line numbers to comment):

1
2
3
4
- go to patch folder.
cd 27734982

[27734982]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
9

9.Check whether active executables are running:

Code/Command (click line numbers to comment):

1
2
3
4
5
- go to patch folder.
cd 27734982


[27734982]$ $ORACLE_HOME/OPatch/opatch prereq CheckActiveFilesAndExecutables -ph ./
10

10.Opatch command using different inventory location:

Code/Command (click line numbers to comment):

1
$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc /etc/orainv/orainventory

Comments (0)

Please to add comments

No comments yet. Be the first to comment!