How to enable Debug mode for Oracle HTTP Server (OHS) within for a WebLogic Managed Server

By | Best Practices, Tips and Tricks, Oracle HTTP Server (OHS), Oracle Hyperion Enterprise Performance Management - EPM, Tips and Tricks, Troubleshooting, WebLogic | No Comments

As a professional Oracle Hyperion EPM infrastructure consultant we have sometimes been stumped by the misbehaving of the Oracle HTP Server (OHS) to WebLogic Managed Servers traffic proxying as deployed within the Oracle Hyperion EPM configuration at clients.  There are occasions in which we just can’t figure out why things aren’t “communicating” like they should.  So, from our little bag of tricks…

Read More

OCI Load balancer backend set session persistence when set to “Drain State”

By | Oracle Cloud Infrastructure (OCI), Tips and Tricks | No Comments

I recently took the Oracle Cloud Infrastructure 2019 Architect Associate exam. There was a question about Load Balancers and I only knew half the answer. I went back after the exam to search for the correct answer but had a really hard time finding it in any of the materials I had been using to study. This includes the videos…

Read More

Oracle EPM 11.2 OHS Services

By | Tips and Tricks | No Comments

Oracle EPM 11.2 does not include the Oracle HTTP server (OHS) startup service we are used to seeing in prior version of the product. This requires us to be more hands-on when starting and stopping the EPM environment. Fortunately, if you use a services start/stop script, you can add commands to ensure the OHS processes and prerequisites are on-line before…

Read More

Oracle Cloud Infrastructure Tutorial Series: Creating a SSH Key Pair on Mac OS X

By | Free Tutorials, Infrastructure as a Service, Oracle Cloud Infrastructure (OCI), Tips and Tricks | No Comments

SSH Key Pairs are required by most Cloud Infrastructure (Infrastructure as a Service) providers for use in authenticating the root or admin level users for various UNIX or Linux compute instances and compute shapes as well as for other IaaS provider management systems (i.e. Amazon Web Services – AWS LightSail, Oracle Cloud Infrastructure – OCI console access, etc…)  The procedures below…

Read More

How I studied for and passed the Oracle Cloud Infrastructure (OCI) Architect Associate certification exam 1Z0-932 (the first time).

By | Certifications, Infrastructure as a Service, Oracle Cloud Infrastructure (OCI), Tips and Tricks | 13 Comments

Since I recently lived through the fun of getting myself Oracle Cloud Infrastructure (OCI) Architect Associate certified, I wanted to share a little information on how I prepared for the exam.  Please note, the opinions, words and views expressed in this article are ONLY a brain dump from my little techy head and there’s no guarantee that if you follow my…

Read More

What version of Oracle EPM/Hyperion am I running?

By | Best Practices, Tips and Tricks, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

When bad things happen and you have to start troubleshooting, it is important to know what version of software you are using.  Whether you or someone else is doing the work, knowing what version or even the patch level of your system, will be required.  Below we have listed a few programs and how to find their versions. Microsoft Excel…

Read More

Financial Management (HFM) Performance Problems When Using SQL Server Database

By | Best Practices, Tips and Tricks, Blogs We Love, EPM System Installation and Configuration, Hyperion Financial Management, Oracle Hyperion Enterprise Performance Management - EPM, Pre-requisites, Tips and Tricks | No Comments

Is your Hyperion Financial Management System running “slow?”  That’s good, because now you have a chance to “catch it” and maybe speed it up!!  If you have more than one HFM application server running against a Microsoft SQL Server backend for your database, then please follow these steps to either fix the issue or confirm that this is not causing the…

Read More

Oracle Smart View Error After Applying Analytic Provider Services (APS) Patch

By | Best Practices, Tips and Tricks, Error Messages, Essbase Errors, Oracle Hyperion Enterprise Performance Management - EPM, Patching, Smart View Errors, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in: Error: ————————— Oracle Smart View for Office ————————— com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V ————————— OK ————————— Screen Shot of Error:   To confirm if there is an issue with the…

Read More

How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

By | Best Practices, Tips and Tricks, Blogs We Love, EPM Presentations, EPM System Installation and Configuration, Oracle Hyperion Enterprise Performance Management - EPM, Tips and Tricks, Troubleshooting, Uncategorized, Utilities | No Comments

People to tend to think that creating a master start/stop script, which can span multiple servers, is a difficult task.  Some Hyperion consulting firms out there even like to charge for such a beast.  They also try to convince you that you need to purchase their “specialized custom scripts” or “compiled start/stop programs” to do the job.  This just isn’t so!  Remember…

Read More