Essbase 21c as a Windows Service
Oracle recently updated their on-premises EPM offering to leverage Essbase21c and the new EPM installer now drops Essbase 21c during install and the configuration process sets up Essbase. As part of the configuration, on a windows server, Essbase is configured in a Weblogic Domain, the repository is setup and if everything is going well, a Windows Service is created to stop and start the Essbase components. In a recent distributed install, we had a glitch that resulted in a working Essbase Weblogic instance and no Essbase Service.
There should be a new service named "EssbaseService" in the Registry that can be seen as "Oracle Essbase Service" in the service control panel. In our case, this was not there. We want to be able to automate startup and shutdown, so we needed to figure out how to manually get the service installed and working.
There are pieces provided to build the service. They are located in the %ORACLE_HOME%\essbase\modules\oracle.essbase.sysman\scripts directory. You will need to find and update the PowerShell script EssbaseService.ps1.
Open the script in a text editor.
The first update is to find and replace the string "ESSBASE_DOMAIN_HOME_DIR" with the path to the WebLogic domain created for Essbase with by default %ORACLE_HOME%\user_projects\domains\essbase_domain.
I found and replaced the strings on lines 125 and 129:
Secondly find and replace "ESSBASE_DOMAIN_HOME" with the same path as above %ORACLE_HOME%\user_projects\domains\essbase_domain
I found and replaced the strings on lines 256 and 293:
Make sure to preserve the "\\" when updating the path….
Once these edits have been made you install the service using a PowerShell command prompt:
Open PowerShell and navigate to the folder that contains the EssbaseService.ps1 script, %ORACLE_HOME%\essbase\modules\oracle.essbase.sysman\scripts.
Type the PowerShell command> .\EssbaseService.ps1 -Setup
The script will install the service for you in the windows registry at HKLM\System\CurrentControlSet\Services as "EssbaseService"
If you look in the domain folder at %ORACLE_HOME%\user_projects\domains\essbase_domain\servers\essbase_server1 you will find two files: EssbaseService.exe and EssbaseService.ps1.
You can now Stop and Start Essbase using the Windows Service "Oracle Essbase Service" in the services control panel.
If you are using on-premise EPM and have not migrated to 11.2 or if you are on an EPM release prior to 11.2.15 and need help moving to the latest version and converting your legacy Essbase or Planning applications to Essbase 21c, please contact iArchSolutions and we will be happy to help.