For Grid Infrastructure Home, as home user: |
|
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/patch/30501932/30593149 |
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/patch/30501932/30585969 |
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/patch/30501932/30591794 |
For Database home, as home user: |
|
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/patch/30501932/30593149 |
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/patch/30501932/30585969 |
Execute the following on each node of the cluster in non-shared CRS and DB home environment to apply the patch. |
|
1. Stop the CRS managed resources running from DB homes. |
|
If this is a GI Home environment, as the database home owner execute: |
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name> |
srvctl stop home -o $ORACLE_HOME -s /home/oracle/patch.txt -n vppracn1 |
|
srvctl stop home -o $ORACLE_HOME -s /home/oracle/patch.txt -n vppracn2 |
|
Note: |
|
You need to make sure that the Oracle ACFS file systems are unmounted (see Section 2.8) and all other Oracle processes are shutdown before you proceed. |
|
2. Run the pre root script. |
this is a GI Home, as the root user execute: |
# <GI_HOME>/crs/install/rootcrs.sh -prepatch |
$ORACLE_HOME/crs/install/rootcrs.sh -prepatch |
|
|
3. Patch GI home. |
|
As the GI home owner execute: |
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG% |
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/patch/30501932/30593149 |
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/patch/30501932/30585969 |
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/patch/30501932/30591794 |
|
|
4. Patch DB home. |
注意事項 |
因oracle的Inventory與grid的Inventory住在一起,所以下面路徑檔案在打第四步Patch DB home的時候記得要先改為oracle:oinstall |
打完DB的之後記得要改回來grid:oinstall,改完後才能在繼續往下 |
/u01/app/oraInventory/ContentsXML]$ ll |
total 6 |
-rw-rw---- 1 grid oinstall 329 Jun 15 13:41 comps.xml |
-rw-rw---- 1 grid oinstall 670 Jan 15 10:55 inventory.xml |
-rw-rw---- 1 grid oinstall 292 Jun 15 13:41 libs.xml |
|
As the database home owner execute: |
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME> |
/oracle/patch/30501932/30585969/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME |
|
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG% |
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/patch/30501932/30593149 |
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /oracle/patch/30501932/30585969 |
|
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME> |
/oracle/patch/30501932/30585969/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME |
|
5. Run the post script. |
|
As the root user execute: |
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh |
$ORACLE_HOME/rdbms/install/rootadd_rdbms.sh |
|
If this is a GI Home, as the root user execute: |
# <GI_HOME>/crs/install/rootcrs.pl -postpatch |
$ORACLE_HOME/crs/install/rootcrs.sh -postpatch |
|
If this is an Oracle Restart Home, as the root user execute: |
|
6. If the message, "A system reboot is recommended before using ACFS is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver. |
|
7. Start the CRS managed resources that were earlier running from DB homes. |
|
If this is a GI Home environment, as the database home owner execute: |
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name> |
srvctl start home -o $ORACLE_HOME -s /home/oracle/patch.txt -n vppracn1 |
|
srvctl start home -o $ORACLE_HOME -s /home/oracle/patch.txt -n vppracn2 |
|
|
8. For each database instance running on the Oracle home being patched, run the datapatch utility as described in next table. |
|
|
sqlplus / as sysdba |
startup |
quit |
cd $ORACLE_HOME/OPatch |
./datapatch -verbose |
|
如果datapatch是空的,not apply |
則需要手動處理 (請參考DOC 1955058.1) |
|
|
|
|
|
|
|
|