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