Sunday, 25 June 2017

Generate Patch Steps with Oplan

Oplan is a utility that facilitates the patch installation process by providing you with step-by-step patching instructions specific to your environment. 

      Oplan comes with latest OPatch
1.  As Oracle Home owner, run the following command
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>
For example: $ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /tmp/1277345
2.   Patch installation instructions specific to your target will be available as HTML and text format in these locations:
$ORACLE_HOME/cfgtoollogs/oplan/<TimeStamp>/InstallInstructions.html
$ORACLE_HOME/cfgtoollogs/oplan/<TimeStamp>/InstallInstructions.txt
3.    Rollback steps
 $ORACLE_HOME/OPatch/oplan/oplan RollbackSteps <bundle patch location>  
4.  Oplan Output:
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /u01/12c_BP/25433352
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /u01 /12c_BP/25433352
from oplan /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.oplan.core.classpath.jar:/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.osys.core.classpath.jar:/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/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: /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/log.txt

Could not generate patching steps for the following databases as they do not run from the current host.
        Database Name: EMREP
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:  vnupoidb02
        Database Name: JAYABPM
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:
        Database Name: JAYFET
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:
To generate the patching steps for the above databases, execute it on host where the databases are running.
Success!
Follow the instructions outlined in the following Installation Instructions document and patch your system:
Apply Instructions (HTML)    : /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/ApplyInstructions.html
Apply Instructions (TEXT)    : /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/ApplyInstructions.txt
[oracle@vnupoidb01 2017-06-26-04-48-43]$ pwd
/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43

5.  [oracle@vnupoidb01 2017-06-26-04-48-43]$ ls -ltr
total 6884
-r--r----- 1 oracle oinstall       0 Jun 26 04:48 log.txt.lck
dr-xr-x--- 3 oracle oinstall    4096 Jun 26 04:50 machine-readable
-r--r----- 1 oracle oinstall  112032 Jun 26 04:50 README.html
-r--r----- 1 oracle oinstall  338935 Jun 26 04:50 OplaceSwitchbackRolling.txt
-r--r----- 1 oracle oinstall  332425 Jun 26 04:50 OplaceApplyRolling.txt
-r--r----- 1 oracle oinstall  208814 Jun 26 04:50 InplaceApplyRollingManual.txt
-r--r----- 1 oracle oinstall  112631 Jun 26 04:50 InplaceApplyRollingAuto.txt
-r--r----- 1 oracle oinstall  201561 Jun 26 04:50 InplaceApplyNonRollingManual.txt
-r--r----- 1 oracle oinstall  200174 Jun 26 04:50 InplaceApplyNonRollingDcli.txt
-r--r----- 1 oracle oinstall   12903 Jun 26 04:50 ApplyInstructions.txt
-r--r----- 1 oracle oinstall   24107 Jun 26 04:50 configuration.png
-r--r----- 1 oracle oinstall     393 Jun 26 04:50 README
-r--r----- 1 oracle oinstall 3171001 Jun 26 04:50 log.txt
-r--r----- 1 oracle oinstall 2266059 Jun 26 04:50 ApplyInstructions.html

No comments:

Post a Comment