The continuation of the project. Installing EPM on OEL.
Today we're going to be getting the database up and running. The version we're using is available on the Oracle Support site 11g Release 2 (220.127.116.11), if you don't have access to this version don't worry. Version 12 should work fine and the steps shouldn't be that much different.
Begin by logging into the console.
We'll start by creating a shell script to run all the updates we'll need. This list of updates will allow the installation of the database and epm on OEL 6.7
Next we can make the script executable and run it. This will prep the system for installation.
The next step will be to update the /etc/hosts file. We'll be adding the hostname for our server to this file.
Next we'll be adding the following entries to the end of the /etc/sysctl.conf file
We'll now add the groups and user account we'll be using to do the installs. I took these from the Oracle DB guide online.
We'll have to add the entries for EPM and Oracle to the firewall.
Next we add the user account we created to the sudoers group.
You'll want to set the password to something very secure since this account has super user rights.
From here we'll want to create the folders we'll be using for the install process.
We'll need to ad some entries to the /etc/security/limits.conf file. This is required for both the EPM and Oracle installs.
We'll need to modify the .bash_profile file in the home folder for our install-user. (In our case oracle
You'll need to upload the installs for Oracle Database now. Once you have them uploaded you can unpack them with the following command: unzip -o -d /u01/installs/oracledb11/ /u01/installs/oracledb11/\*.zip
Before you begin the install you'll want to make sure you have set putty to enable X11 forwarding (If you're running windows like me)
Run the program runInstaller now in the database folder and if X11 forwarding is working for you, you'll now be presented with the following screens. You can click Next to continue and fill in the relevant details as shown.
At this screen you'll need to open a terminal window logged in as root and run the following two scripts.
Congratulations. We now have a functional installation of Oracle Database.
In our next step we will begin the installation of EPM 18.104.22.168.
One of the features I've started working with in Essbase are members that store text.
The limitations for this feature are that you can only store 1024 different strings of text and there is no easy way to automate the maintenance of the members you want in this text list.
Since there seems to be no way to increase the limit (and so far the solutions I'm working on don't depend on more than 1000 different options for a single text list) I decided to work on coming up with a way to automate the maintenance of the list using the Java API.
The general goals are that the solution will connect to a database to pull the list from a SQL table and then load that into Essbase.
In order to generate an incremental list of IDs with text well be using an olap function most versions of sql come with--row_number().
This will be a small mini guide on the end to end installation of EPM 22.214.171.124 on a single VM with Oracle Linux. Hopefully if it's not too painful I'll attempt to put something up on how to do the same in Amazon Linux.
For the curious this vm currently only has 11GB of Memory assigned so we'll be deploying to a single app server and we won't be tuning the JVM options to crank it up any further from the defaults.
The plan for this is going to be 3 parts.
1 - Installing Oracle Linux
2 - Installing Oracle Database 11g and creating the Schemas for EPM
3 - Installing EPM 126.96.36.199
Without much ado let's begin.
Boot up on the Oracle Linux dvd. (I used version 6.7 which is freely available on eDelivery)
Select the Language and click Next
Select the keyboard and click Next
Select the type of device you want to install on. In my case it's a VM with two disks.
I'm going with two disks to illustrate how to create virtual groups which we will use later on.
Select Fresh Installation and click Next
Enter the hostname of your choice. Mine is oel01.local
Click Configure Network. If you omit this step we'll have to configure TCP/IP later which isn't as much fun as it sounds.
This is a very simple environment so I always set it to 192.168.1.160/24 with a gateway of 192.168.1.1
Select your time zone and click Next
Here you get to enter your root password. I tend to randomly generate this to something really long.
This is where we create the virtual groups for our server. Select Create Custom Layout and click Next
I tend to chose this layout. I'm sure it's not all 100% necessary as I'm not much of a Linux guru. (This is actually my first Linux project so I'm learning as we go along.)
The only take-home here is that I like to build the u01 mount point as it's going to be used later as the location for the app folder where we will be storing the oracle directory.
See this link for the method to my madness: Optimal Flexible Architecture
Oracle really doesn't want you to lose your data. Click Write changes to disk to say you are really really sure you are ok with it.
Click Format to accept that you will be destroying the existing layout (if any exists).
I'd welcome feedback if this isn't the best option but I've had success with choosing Database Server and clicking Next
It'll take some time but soon you'll see this window. Click Reboot.
Congrats you now have a working Oracle Linux Server running OEL 6.7.
Stay tuned for our next installment.