There may be instances where you need to restart your Planning application. With our on premise environments, all we had to do was call our trusty IT department OR log into the server and run our EPM stop and startup scripts. When our servers are in the cloud, we don’t have an easy button to press for a reboot. Oracle has created steps for us to “reboot” (reset) our Planning environments.
Why would we ever need to do this? I’m glad you asked!
I’ve seen situations where a process shows to be still processing, when it’s actually complete. I’ve also seen situations where a reset has helped resolve some performance issues for environments. We had another isntance where a business rule stopped working. We couldn’t figure out why OR get it to work again.
Oracle recommends you use this command only when you observe severe performance degradation or if you receive error messages indicating that the instance is unusable. Service reset does not affect your application customization (for example, locale change, settings related to theme and currency, etc.) and it the Reset takes up to 15 minutes.
Now something you need to know. This completely RESETS your environment. So, it’s imperitive that you use LCM to get a full backup (data, metadata, security, ALL OF IT) before you perform these steps.
You can use EPMAutomate utility to restart services, using the resetservice command.
Be sure you have the latest EPMAutomate utility.
To install the latest EPMAutomate Utility, login to your PBCS Service and click on Navigator icon.
Under Install, select the EPM Automate link for your environment. In this example, we are using the EPM Automate for Windows.
Once the executable downloads, select Run to Install EPM Automate.
Select OK to run the EPM Automate.exe
When it’s done installing, you will get a message that it’s complete.
The EPM Automate in controlled via a command prompt.
Open Command Prompt and navigate to the install Location. I know I installed mine in the C drive.
Example: CD C:\Oracle\EPM Automate
Usage: epmautomate login username password/<password file> url identitydomain
Example: epmautomate login admin_user PasSw0Rd https://myservice-mydomain.pbcs.us2.oraclecloud.com mydomain
You can include comments to track the reasons for the retstart. The Comments must be enclosed in quotation marks.
It would look like this: epmautomate resetservice “comment”
Example: epmautomate resetservice “Import Metadata processing is stuck”
You don’t have to follow these steps every time you need to reset the environment. Use the section on EPM Automate to create batch script and run the batch as needed!