Select Page

Quiz: Which Instance is EPMAutomate Accessing?

Dave Shay | | September 6, 2017

The automation utility Oracle provides for their EPM Cloud solutions, “EPMAutomate,” does not tell you which EPM Cloud instance you are accessing. It doesn’t say if you’re hitting Production vs. Test, or even which instance you’re accessing.

For architects like me, this can be a problem – and I have a solution. But first, a quiz! Let’s see if you can figure out which Oracle instance is involved in two examples:

Question #1:

EPMAutomate for Oracle Cloud is a powerful tool, but if you are working on multiple implementations, it does not prompt you to login after you’ve successfully logged in previously. Can you tell which Oracle Cloud instance I just bounced?

The answer is below the screenshot, but see if you can figure it out yourself first.

Answer #1:

Inspect the “.prefs” file. Stay safe out there!

Question #2:

Which customer’s Cloud environment did I just blow away?

Answer #2:

Examine the file named “.prefs” within the EPMAutomate /bin folder! I suggest a separate EPMAutomate folder for each instance (e.g. “a123456Prod” vs “a123456Test”)

And now for an easy, straightforward solution. If you use EPMAutomate interactively, add lines 13-16 from my screenshot below to your own copy of epmautomate.bat. This is a quick & dirty hack if you want visual confirmation that you’re hitting the Oracle Cloud instance you intended.

The solution I provided wouldn’t be advised for lights-out automation, but it is ideal for many other instances, for example, my current project migrating application content from a customer’s Test instance into their Production instance.

And there you have it! Did you get the questions right?

For additional resources please download white paper, Where, Oh Where Has My Hyperion Administrator Gone 

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS