You can patch and roll back an Oracle Essbase cloud instance on Oracle Cloud Infrastructure.
For version 18.104.22.168.3 and earlier.
- Access the Essbase node using SSH, as described Access Oracle Essbase Using SSH.
- Stop Essbase instance, as user opc user.
sudo systemctl stop essbase.service
- Set environment variables, as user oracle.
export ORACLE_HOME=/u01/oracle export OPATCH_NO_FUSER=true
- Download the OPATCH patch file from My Oracle Support.
- Copy the downloaded patch zip file to cloud instance, using a tool such as WinSCP, SCP, Filezilla, and others. If you use WinSCP, for example, on the WinSCP Login page, under Session, enter the Host name, Port number, User name opc, Private key file, and click Login. The file is copied.
- Ensure that user oracle has read access to the OPATCH file.
- Apply OPATCH, as user oracle. You can apply OPATCH directly while in zip format. Provide the absolute path of the zip file.
Note: If you want, you can optionally unzip the zip file and apply the patch. Provide the absolute path of the unzipped folder.
$ORACLE_HOME/OPatch/opatch apply /tmp/Marketplace/<OPATCH_ID>.zip
unzip ./<OPATCH_ID>.zip $ORACLE_HOME/OPatch/opatch apply /tmp/Marketplace/<OPATCH_ID>/
- Start the Essbase cloud instance, as user opc.
Verify the log to see that all binaries patched successfully. Log in to Essbase instance and verify the build number in admin→About.
sudo systemctl start essbase.service
- [OPTIONAL] If you need to roll back the applied patch, do the following steps.
- If the Essbase instance is running, first stop Essbase system service, as user opc, as described above.
- Run the rollback command:
$ORACLE_HOME/OPatch/opatch rollback -id <OPATCH_ID>
$ORACLE_HOME/OPatch/opatch rollback -id 30081463
- Restart the Essbase instance after rollback. If you're unable to login in, clear the Essbase related browser cache or open a new browser.