The instructions for applying a one off patch are as follows:
- Once the patch is downloaded, extract the contents to a directory, for example E:\stage\12345678 where 12345678 is the no. of the patch
- Add an environment variable OPatch with value %ORACLE_HOME%\OPatch to the system advanced properties
- Add %ORACLE_HOME%\OPatch; to the Path variable
- Stop the runtime service by doing the following:
- Run a command prompt from folder %OWB_HOME%\rtp\sql
- Login to sqlplus, i.e run "sqlplus"
- Logon as "sys as sysdba" OR "owbsys" and enter password
- Execute "@stop_service.sql"
- Go to Oracle>WarehouseBuilder>Administration>Stop Control Center Service, log on to the Control Center and choose Stop.
- Ensure all Oracle programs are closed.
- Run the OPatch Utility in a command prompt from the folder in which it was saved in Step 1:
The patch will ask to rollback any other conflicting patches, when asked enter in 'y' to proceed.
If you encounter any errors - enter in 'y' to proceed and continue the installation, i.e. duplicate files exist or file cannot be found
- Restart the runtime service by following all the steps in step 4 except the final one which will be
- Execute "@start_service.sql"
- The patch should now be fully applied. If any problems are experienced after installing the patch, it can be removed by following steps 4-8 above, only in step 7 run the following in command prompt:
- Execute "opatch rollback -id 12345678" where 12345678 is the no. of the patch
- Pleas refer to the README.txt files for a more detailed version