如何使用oplan？

什么是oplan？

OPlan是一个很有用的工具，她会自动收集客户系统的信息，并够针对客户的环境，生成一个非常详细的应用补丁/回滚补丁的操作手册。和传统的应用补丁方式相比，她很大程度上简化了DBA的工作量，还能给出多种方案：包含'In place','out-of-place', rolling, non-rolling等。

A.'Out-of-Place'：通过clone一个ORACLE_HOME，然后再应用

[oracle@ohs1 ~]$ $ORACLE_HOME/OPatch/oplan/oplan
from oplan /pgold/ordb/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.oplan.core.classpath.jar:/pgold/ordb/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.osys.core.classpath.jar:/pgold/ordb/oracle/product/121/OPatch/oplan/../auto/core/bin/../../database/modules/oplan_db.jar
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128M; support was removed in 8.0

Error: Invalid or insufficient command line argument. 0

usage: oplan  [-h] [-v] { generateSteps <patch> | generateApplySteps
             <patch> | generateRollbackSteps <patch> |
             saveConfigurationSnapshot <configXML> | configurationCompare
             <configXML1> [<configXML2>] } [-RACPatches <Comma separated
             list of patches to be applied to Database Homes>] [-GIPatches
             <Comma separated list of patches to be applied to Grid
             Infrastructure Homes>] [-NodeNumberPerReadme <Node Number for
             each readme file for a execution plan>]
 -customLogPath <customLogPath>               Location for OPatch core
                                              logs. Pass parameter as
                                              $ORACLE_HOME/path if to be
                                              logged inside OH
 -GIPatches <gipatches>                       Comma separated list of
                                              patches to be applied to
                                              Grid Infrastructure Homes
 -h,--help                                    Prints help message.
 -logDir <logDir>                             Directory for logging and
                                              output
 -MoveConfigToOH <MoveConfigToOH>             Database Home to migrate the
                                              config
 -NodeNumberPerReadme <NodeNumberPerReadme>   Node Number for each readme
                                              file for a execution plan
 -RACPatches <racpatches>                     Comma separated list of
                                              patches to be applied to
                                              Database Homes
 -v,--version                                 Prints OPlan's version
                                              information.

generateSteps
    - Generate apply and rollback instructions for the patch
generateApplySteps
    - Generate apply instructions for the patch
generateRollbackSteps
    - Generate rollback instructions for the patch
saveConfigurationSnapshot
    - Save current configuration information to XML file
configurationCompare
    - Compares two system configurations for any changes

Examples:
    
# Note: Always set ORACLE_HOME environment variable to Grid Infrastructure
    home before executing oplan command
export ORACLE_HOME=<path to GI home>

# Generate steps to apply and rollback patch
oplan generateSteps <path to GI bundle patch>

# Save the configuration of the system running from ORACLE_HOME to XML
oplan saveConfigurationSnapshot <path to save configuration xml file>

# Compare given configuration xml with the current configuration
oplan configurationCompare <configuration.xml>

# Compare two configuration xmls
oplan configurationCompare <configuration1.xml> <configuration2.xml>

# Generate steps to apply and rollback bundle patch with RAC/GI one-off
    patches
oplan generateSteps <path to GI bundle patch> -RACPatches <path to patch
    one>,....,<path to patch x> -GIPatches <path to patch one>,....,<path
    to patch x>
[oracle@ohs1 ~]$

[oracle@ohs1 ~]$ /pgold/orgrid/oracle/product/121/OPatch/oplan/oplan -v
from oplan /pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.oplan.core.classpath.jar:/pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.osys.core.classpath.jar:/pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../database/modules/oplan_db.jar
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128M; support was removed in 8.0

oplan version: 12.2.0.1.8

Minimum OPatch version required for 11.2 targets: 11.2.0.3.0
Minimum OPatch version required for 12.1 targets: 12.1.0.1.0

[oracle@ohs1 ~]$

[root@ohs1 121]# /pgold/orgrid/oracle/product/121/OPatch/oplan/oplan generateApplySteps /mnt/24448103
from oplan /pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.oplan.core.classpath.jar:/pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.osys.core.classpath.jar:/pgold/orgrid/oracle/product/121/OPatch/oplan/../auto/core/bin/../../database/modules/oplan_db.jar
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128M; support was removed in 8.0

Processing request...

Review the log messages captured in the following file: /pgold/orgrid/oracle/product/121/cfgtoollogs/oplan/2017-01-03-19-56-31/log.txt

Success!

Follow the instructions outlined in the following Installation Instructions document and patch your system:  

Apply Instructions (HTML)    : /pgold/orgrid/oracle/product/121/cfgtoollogs/oplan/2017-01-03-19-56-31/ApplyInstructions.html
Apply Instructions (TEXT)    : /pgold/orgrid/oracle/product/121/cfgtoollogs/oplan/2017-01-03-19-56-31/ApplyInstructions.txt

[root@ohs1 121]#

点击浏览oplan样例