OAC Quick Tip: Manually Restarting Essbase Cloud

Yesterday, our team encountered an unfortunate situation. Our OAC – Essbase Cloud environment started acting “funny.” We were unable to create new applications nor start existing applications. Here is what some of those error messages looked like:

This was the first time we’ve encountered this situation in our public GA environment, so a group of us all emailed each other for ideas on what to do. Remember that OAC is PaaS, not SaaS. In a PaaS environment, the customer controls the patches/upgrades/maintenance/administration. So how do you troubleshoot Essbase Cloud when something goes wrong? Well, that is a set of thoughts for a different day…

Luckily, newly minted Oracle ACE Wayne Van Sluys pointed us to some real-world answers. He’s been getting his hands dirty configuring and setting up OAC instances for our customers.  After we tested the issues thoroughly and confirmed that “something is wrong”, he suggested that we move straight to a service instance restart. We also logged an SR to find out more about why our environment hiccuped.

So, how does one restart the Essbase Cloud service?

First, anticipate that this process will take 10-15 minutes from start to finish. It took ~5-7 minutes for the service to fully restart, then another ~5-7 minutes for the Essbase Cloud website to come back up. These were the stats on our interRel environment, which has a single Essbase Cloud OCPU licensed for Enterprise Edition.

In addition, you will need to have administration rights in My Services to perform this type of action.

Finally, I’ll demonstrate how to do this manually through My Services. However, automated options are possible as well.

Part I: Navigation

Log into My Services (which you can access from cloud.oracle.com if you know a few key items about your environment – read this blog post here). This will probably land you on the Dashboard. Navigate down to the OAC instance and click on Action Menu >> Open Service Console:

OAC Restarting Service-Dashboard Nav 01

 

Part IIa: Restart – Simple Option

Once you go into the OAC screen, you can directly restart the service from here by selecting Manage this service >> Restart next to the service instance name that applies to the one you wish to restart:

OAC Restarting Service-Dashboard Nav 02

If you choose to go this route, expect to see that the request was accepted. The service  icon will change to show a yellow triangle to indicate that it is being restarted:

OAC Restarting Service-Restart 01

It’s important to know that this screen refreshes manually. Therefore, use the refresh button generously:OAC Restarting Service-Restart 02

When the service is back up, the service icon will change back to normal:

OAC Restarting Service-Restart 03

 

Part IIb: Restart – Detailed Option

There is another route for restarting services. I prefer to go into the detailed service screen, as there is a bit more information provided about the current status and other important elements. So instead of using the Manage this service icon to restart, I’ll click on the service instance name directly:

OAC Restarting Service-Dashboard Nav 03

This will take you to the detailed service instance screen. Here, you’ll find a series of buttons in the upper right hand corner. They correspond to Start Service, Stop Service, Restart Service, and Display monitoring information:

OAC Restarting Service-Buttons

At this point, one can just press Restart Service. However, I am curious by default and want to try it another way, so I will first manually stop the service and then restart it. Press Stop Service and the following message asks if you really want to stop it:

OAC Restarting Service-Dashboard Nav 05

Next, the screen changes to indicate that the service is in the process of stopping. Notice that the service icon has changed to display a yellow triangle:

OAC Restarting Service-Stop Request

So apparently this screen requires a manual refresh as well. I sat there for 10 minutes wondering why it was taking so long. The refresh button highlighted below is important – use it generously:

OAC Restarting Service-Dashboard Nav 04

Once the service is stopped, the service icon shows a red triangle.

Next, start the service and press OK when you’re asked to confirm the action:

OAC Restarting Service-Dashboard Nav 06

The screen will change to indicate that the service is in the process of starting, with an updated yellow triangle color on the service icon:

OAC Restarting Service-Dashboard Nav 07

Keep pressing the refresh button. Once the service starts, the service icon will go back to normal and the status will change to Ready:

OAC Restarting Service-Dashboard Nav 09

 

Part III: Essbase Cloud Website Recovery

Regardless of your path, the Essbase Cloud service should be fully restarted. However, if you navigate to the Essbase Cloud URL immediately afterwards, you’ll get this lovely little message:

OAC Restarting Service-Dashboard Nav 08

Just wait ~5 minutes and it will all come back up. Right as rain!

One thought on “OAC Quick Tip: Manually Restarting Essbase Cloud

Let it out here

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s