You may find many blogs on internet providing step-by-step guidelines to install Oracle 11g on RHEL/Centos 6.x but what’s different here is, I would be discussing the installation of Oracle 11g on AWS EC2 instance through CLI in cases where you do not have access to physical system. I believe the best example to showcase this environment would be that of AWS Cloud.
Without wasting any time lets jump down to the point & discuss further steps.
We use “oracle-rdbms-server-11gR2-preinstall” package offered by “Oracle Public Yum” repository.
# cd /etc/yum.repos.d # wgethttps://public-yum.oracle.com/public-yum-ol6.repo
Install GPG key for your OS release
# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Now install the package
# yum install oracle-rdbms-server-11gR2-preinstall
Setup your hostname
# vi /etc/sysconfig/network HOSTNAME=oracle.intelligrape.com
Make an entry for fully qualified hostname in /etc/hosts file
# vi /etc/hosts 54.xxx.xxx.xxx oracle.intelligrape.com oracle
where, 54.xxx.xxx.xxx is the Elastic IP of your Oracle Instance
Restart your network for the changes to take effect.
# /etc/init.d/network restart
Create a User oracle & specify a password for it.
# useradd oracle # passwd oracle
Make the following entries in /etc/security/limits.d/90-nproc.conf
* softnproc 1024
Add below entry
* - nproc 16384
Disable SELinux on your instance
# vi /etc/selinux/config SELINUX=disabled
Reboot for changes to take effect
Now login as oracle user & make below entry in your .bash_profile
# su - oracle $ vi .bash_profile # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=oracle.intelligrape.com; export ORACLE_HOSTNAME ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID=DB11G; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH
Create the directories and set the appropriate permissions in which the Oracle software will be installed.
# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_2 # chown -R oracle:oinstall /u01 # chmod -R 775 /u01
Download Oracle Software
For Linux x86-64 Systems
# wgethttp://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip # wgethttp://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip # su - oracle $ unzip linux_11gR2_database_1of2.zip $ unzip linux_11gR2_database_2of2.zip
On unzipping the files a database directory will get created. Run the runInstaller script placed under database directory.
$ cd database $ ./runInstaller
On running the script you will receive errors for swap space & most importantly errors responding to setting up of DISPLAY Parameter as indicated below.
Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 7113 MB Passed Checking swap space: must be greater than 150 MB. Actual 1011 MB Passed Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<< Some requirement checks failed. You must fulfill these requirements before continuing with the installation, Continue? (y/n) [n]
Note : As per the above error logs swap space check is passed as I have already created one using mkswapcommand on one of the unused partition or spare volume. By default when we setup a new server instance in cloud the swap space is not present, you can check the same via free –k command.
Since Oracle requires a GUI environment for installation we need to provide the same externally.
You need to install “Xming”or any of the X environment display tools on your local Windows PC, the installation process might be pretty slow in this case might be slow as your cloud server & your local PC are in different networks. In order to speed up the installation process you can install Xming on the Windows server instance which is in the same network as your Linux server, what I mean by this is that both the Linux & Windows server should be present in the Cloud within the same VPC.
Download Xming from http://sourceforge.net/projects/xming/files/Xming-mesa/22.214.171.124/Xming-mesa-6-9-0-31-setup.exe/download
Installation steps & enabling X11 forwarding
Download Additional fonts for Xming from download link :http://sourceforge.net/projects/xming/files/
After downloading walk down through the following steps for installation
Now start the Xming server by clicking on the Desktop icon.
“Enable X11Forwarding yes” in /etc/ssh/sshd_config & restart the ssh service.
Configure X11 Forwarding in SSH Clients
In the PuTTY configuration window, select “Connection->SSH->X11” and make sure the “Enable X11″ forwarding box is checked, then return to the Session category and click [Open] when you are ready to connect to the specified machine:
Once you login with your pem file as ubuntu or ec2-user type below command.
$ xauth list $ oracle.intelligrape.com/unix:10 MIT-MAGIC-COOKIE-1 8ea792a81074c62518d53789faf9558d
Now login as oracle user.
$ su – oracle $ xauth add oracle.intelligrape.com/unix:10 MIT-MAGIC-COOKIE-1 8ea792a81074c62518d53789faf9558d
Now go to the unzipped database directory & run runInstallerscript.
$ cd database $ ./runInstaller
Note :Now the runInstaller script will make use of your local Windows PC for the DISPLAY_PARAMETER error faced earlier for enabling the 256 colors required for launching the oracle GUI for installation.
Press “Continue” for resuming the Oracle installation
Click Yes to continue installation
Click Yes to continue installation.
The pdksh package is not available in Oracle repository due to which you need to download and install it manually.
# wget ftp://rpmfind.net/linux/redhat-archive/6.2/en/os/i386/RedHat/RPMS/pdksh-5.2.14-2.i386.rpm
During pdksh package installation you may encounter conflict error of ksh package. Remove ksh package forcefully and install the pdksh package with given below command:-
# rpm -e ksh-20100621-19.el6_4.4.i686 --nodeps # rpm -ivh pdksh-5.2.14-2.i386.rpm
In case you face any more errors you can Check“Ignore All” checkbox& install the mentioned packages externally if required.
Click on Password Management
Set password for user “SYS”& click “OK” to continue.
Run the following configuration scripts
# cd /u01/app/oraInventory # ./orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
# cd /u01/app/oracle/product/11.2.0/dbhome_2/ # ./root.sh
Running Oracle 11g root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_2
Enter the full pathname of the local bin directory:
[/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created.
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Installation of Oracle database is Successful;
<a href=”http://www.tothenew.com/blog/wp-content/uploads/2013/12/15.png”><img class=”alignnone size-full wp-image-11293″ title=”15″ src=”http://www.tothenew.com/blog/wp-content/uploads/2013/12/15.png” alt=”” width=”402″ height=”251″ /></a>
In order to check whether oracle is installed login as oracle user.
$ export ORACLE_SID=orcl $ sqlplus / as sysdba SQL*Plus: Release 126.96.36.199.0 Production on Tue Dec 24 01:37:49 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
This completes the installation. Enjoy!!!!!
Hopefully the above mechanism will work on other Cloud environments as well.
Work Hard…..Party Harder…………!!!!!!!