Guide to Online Casinos - www.Casino.us.org
Cloud Computing Tutorials For Beginners Free: Oracle-Patching rollback

Sunday, 3 July 2016

Oracle-Patching rollback

Rollback :

Perform below steps incase the patch applied but database/application is not working as expected.

1. Open command prompt in Administrator mode and perform the below :
    7.1) SET ORACLE_HOME=<PATH_OF_ORACLE_HOME>
    7.2) SET PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\OPatch\;%ORACLE_HOME%\perl\bin;%PATH%
    7.3) sqlplus / as sysdba
    7.4) shutdown immediatae
    7.5) exit
    7.6) cd d:\patches\21821802\
    7.7) opatch rollback -id 21821802
        7.7.1) Most probably rollback may fail if any files related to oracle are in use. Kill them manually.
    7.8) Inspect the opatch<timestamp>.log file generated in %ORACLE_HOME%\cfgtoollogs\opatch for any errors.
    7.9) When rollback complete, connect to the database and start the database and listener services from start -> run -> services.msc
    7.10) Inspect the opatch<timestamp>.log file generated in %ORACLE_HOME%\cfgtoollogs\opatch for any errors.

No comments:

Post a Comment