What’s ahead
Running Oracle ERP
To run Oracle ERP you need a proper Operating System that is certified by Oracle.
However. it is not enough to just chose a certified OS. The OS needs to be pre-prepped so that these tools will not only install properly but also run properly and efficiently.
Which OS?
Oracle Fusion and Oracle EBS run on a variety of OS’s and the choice of which one to use relates to each individual case and the that is beyond the scope of our destiny here today.
We are here to focus on spinning up a version 6 Oracle Linux (OL). It’s free, it’s solid and it can the full process to get it ready is under 20-30 minutes depending on the Linux, AWS, Bash and Oracle skill level of the creator.
Certified Operating System
Pretty much standard nowadays is the use of Linux for running things.
We will run the certified Linux x86-64 Oracle Linux 6.
(Oracle Fusion Applications 11.1.9.2.0 is certified on Linux x86-64 Oracle Linux 6)
(Oracle EBS R12.2.10 is certified onLinux x86-64 Oracle Linux 6)
AWS Related
This guide is assuming the use of the following:
- AMI use is ami-0a83f78399a1196ec (Oracle Linux 6 update 10 for x86_64 HVM)
- Zone is us-west-1 – (California)
Some Assumptions
- Reasonable ability to get around Linux
- Familiar with Amazon AWS instances
- Amazon AWS Account
- PuTTy installed (or just use cmd on Macs)
- MS Remote Desktop installed
The Process
Create the AWS Instance of OL6
Update and Install Oracle required
Install tools to access the newly Oracle prepped Instance
First up – Create an Amazon Instance
Create an Amazon AWS Instance having an instance type at least 2GM RAM using the AMI and zone described the AWS Related section.
I like using a t2.medium or a t2,small
At this point this is all OS prep based stuff so the volume the OS comes on is 15GB so no additional Volumes need to be created.
If you want to cheat skip below to the Bash shortcut.
Next up – The Required Oracle Bits
sudo yum install oracle-ebs-server-R12-preinstall.x86_64 binutils compat-db sysstat unixODBC-devel wget nano -y passwd oracle
Install a Desktop Remote & Desktop Utility
Time to install xfce Desktop (a lightweight desktop that allows us to manage the OS) outside a cli. More importantly is that such a setup guards against install fails due to disconnections.
Sure you could run something like xming and run the install with a local X provider. However if that gets disconnected the session is lost.
Another factor is skilling the X running over the wire is that is seems to be much slower.
We install xrdp which is a facility that allows us to skip using a VNC client and instead run Windows Remote Desktop to connect
We install xfce desktop and xrdp using the epel-release repo
wget https://d2lzkl7pfhq30w.cloudfront.net/pub/archive/epel/6/x86_64/epel-release-6-8.noarch.rpm sudo rpm -ivh epel-release-6-8.noarch.rpm sudo yum install tigervnc-server xrdp firefox rsync -y sudo chkconfig iptables off sudo service iptables stop sudo passwd ec2-user sudo yum groupinstall xfce -y sudo chkconfig xrdp on cd /home/ec2-user echo "xfce4-session" > ~/.Xclients chmod a+x ~/.Xclients sudo service xrdp start
Create Swapfile
Just about any Oracle install requires some form of Swap facility. The steps below create a 4G swap facility in file form
sudo fallocate -l 4G /swapfile sudo dd if=/dev/zero of=/swapfile bs=1024 count=4048576 sudo chmod 600 /swapfile sudo mkswap /swapfile sudo swapon /swapfile
Bash Shortcut
If you want to automate the whole process copy the following lines to a bash file like say “all.sh” on the server then run it.
It will run everything you need to be done with it including settling the passwords for the ec-user and oracle.
Edit as needed to fit your circumstances – like the passwords, swapfile size etc.
You MUST install nano first so you can use nano to create the all.sh file to use this method
#!/bin/bash sudo yum install oracle-ebs-server-R12-preinstall.x86_64 binutils compat-db sysstat unixODBC-devel wget nano -y wget https://d2lzkl7pfhq30w.cloudfront.net/pub/archive/epel/6/x86_64/epel-release-6-8.noarch.rpm sudo rpm -ivh epel-release-6-8.noarch.rpm sudo yum install tigervnc-server xrdp firefox -y sudo chkconfig iptables off sudo service iptables stop sudo yum groupinstall xfce -y sudo chkconfig xrdp on cd /home/ec2-user echo "xfce4-session" > ~/.Xclients chmod a+x ~/.Xclients sudo service xrdp start sudo fallocate -l 4G /swapfile sudo dd if=/dev/zero of=/swapfile bs=1024 count=4048576 sudo chmod 600 /swapfile sudo mkswap /swapfile sudo swapon /swapfile echo "biggie" | sudo passwd --stdin ec2-user echo "biggie" | sudo passwd --stdin oracle
Run the command below to make the file “executable”
chmod +x all.sh
./all.sh
In Closing
This process is painless and gets easier everytime you do it.
Keep in mind that so many of Oracle’s tools can run on this configuration such as Oracle Databases, Oracle Middleware etc
It’s the OS for Oracle that just keeps on giving!
Hope you enjoyed it.
You ever need paid for Oracle services in the Fusion or Oracle EBS space be sure to reach out.
NEXT STEPS?
Create a Staging Area Volume on AWS for installing Oracle Fusion Applications?
