| 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) |
|
|
|
|
|
|
|
|