{"id":11261,"date":"2013-12-23T12:29:51","date_gmt":"2013-12-23T06:59:51","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=11261"},"modified":"2016-08-30T11:16:12","modified_gmt":"2016-08-30T05:46:12","slug":"installing-oracle-11g-on-cloud-ec2-instance-rhelcentos-6-x-through-command-line","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/installing-oracle-11g-on-cloud-ec2-instance-rhelcentos-6-x-through-command-line\/","title":{"rendered":"Installing Oracle 11g on Cloud (EC2 instance RHEL\/Centos 6.x) through command line"},"content":{"rendered":"

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<\/a>.
\nWithout wasting any time lets jump down to the point & discuss further steps.<\/p>\n

We use \u201coracle-rdbms-server-11gR2-preinstall<\/strong>\u201d package offered by \u201cOracle Public Yum<\/strong>\u201d repository.<\/p>\n

[shell]# cd \/etc\/yum.repos.d
\n# wgethttps:\/\/public-yum.oracle.com\/public-yum-ol6.repo[\/shell]<\/p>\n

Install GPG<\/strong> key<\/strong> for your OS release<\/p>\n

[shell]# wget https:\/\/public-yum.oracle.com\/RPM-GPG-KEY-oracle-ol6 -O \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-oracle[\/shell]<\/p>\n

Now install the package<\/p>\n

[shell]
\n# yum install oracle-rdbms-server-11gR2-preinstall
\n[\/shell]<\/p>\n

Setup your hostname<\/strong><\/p>\n

[shell]
\n# vi \/etc\/sysconfig\/network
\nHOSTNAME=oracle.intelligrape.com
\n[\/shell]<\/p>\n

Make an entry for fully qualified hostname in \/etc\/hosts<\/strong> file<\/p>\n

[shell]# vi \/etc\/hosts
\n54.xxx.xxx.xxx oracle.intelligrape.com oracle[\/shell]<\/p>\n

where, 54.xxx.xxx.xxx is the Elastic IP of your Oracle Instance<\/p>\n

Restart your network for the changes to take effect.<\/p>\n

[shell]# \/etc\/init.d\/network restart[\/shell]<\/p>\n

Create a User oracle\u00a0<\/strong>& specify a password for it.<\/p>\n

[shell]# useradd oracle
\n# passwd oracle[\/shell]<\/p>\n

Make the following entries in \/etc\/security\/limits.d\/90-nproc.conf<\/strong><\/p>\n

Comment out<\/strong><\/p>\n

[shell]* softnproc 1024[\/shell]<\/p>\n

Add below entry<\/strong><\/p>\n

[shell]* – nproc 16384[\/shell]<\/p>\n

Disable SELinux<\/strong> on your instance<\/p>\n

[shell]# vi \/etc\/selinux\/config
\nSELINUX=disabled[\/shell]<\/p>\n

Reboot for changes to take effect<\/p>\n

[shell]# reboot[\/shell]<\/p>\n

Now login as oracle user<\/strong> & make below entry in your .bash_profile<\/strong><\/p>\n

[shell]# su – oracle<\/p>\n

$ vi .bash_profile<\/p>\n

# Oracle Settings
\n TMP=\/tmp; export TMP
\n TMPDIR=$TMP; export TMPDIR<\/p>\n

ORACLE_HOSTNAME=oracle.intelligrape.com; export ORACLE_HOSTNAME
\n ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
\n ORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE
\n ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1; export ORACLE_HOME
\n ORACLE_SID=DB11G; export ORACLE_SID
\n PATH=\/usr\/sbin:$PATH; export PATH
\n PATH=$ORACLE_HOME\/bin:$PATH; export PATH<\/p>\n

LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH
\n CLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH export PATH[\/shell]<\/p>\n

Create the directories and set the appropriate permissions in which the Oracle software will be installed.<\/p>\n

[shell]# mkdir -p \/u01\/app\/oracle\/product\/11.2.0\/dbhome_2
\n # chown -R oracle:oinstall \/u01
\n # chmod -R 775 \/u01[\/shell]<\/p>\n

Download Oracle Software<\/strong>
\n For Linux x86-64 Systems<\/strong><\/p>\n

[shell]# wgethttp:\/\/download.oracle.com\/otn\/linux\/oracle11g\/R2\/linux.x64_11gR2_database_1of2.zip
\n# wgethttp:\/\/download.oracle.com\/otn\/linux\/oracle11g\/R2\/linux.x64_11gR2_database_2of2.zip
\n# su – oracle
\n$ unzip linux_11gR2_database_1of2.zip
\n$ unzip linux_11gR2_database_2of2.zip[\/shell]<\/p>\n

On unzipping the files a database directory will get created. Run the runInstaller script placed under database directory.<\/p>\n

[shell]$ cd database
\n$ .\/runInstaller[\/shell]<\/p>\n

On running the script you will receive errors for swap space\u00a0<\/strong>& most importantly errors responding to setting up of DISPLAY Parameter<\/strong> as indicated below.<\/p>\n

[shell]
\nStarting Oracle Universal Installer…
\n Checking Temp space: must be greater than 120 MB. Actual 7113 MB Passed
\n Checking swap space: must be greater than 150 MB. Actual 1011 MB Passed
\n Checking monitor: must be configured to display at least 256 colors
\n >>> Could not execute auto check for display colors using command \/usr\/bin\/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
\n Some requirement checks failed. You must fulfill these requirements before continuing with the installation,
\n Continue? (y\/n) [n]
\n[\/shell]<\/p>\n

Note<\/strong> : As per the above error logs swap space check is passed as I have already created one using mkswap<\/strong>command 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 \u2013k<\/strong> command.<\/p>\n

Since Oracle requires a GUI environment for installation we need to provide the same externally.<\/p>\n

You need to install \u201cXming\u201dor 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.<\/p>\n

Download Xming<\/strong> from http:\/\/sourceforge.net\/projects\/xming\/files\/Xming-mesa\/6.9.0.31\/Xming-mesa-6-9-0-31-setup.exe\/download
\n
\nInstallation steps & enabling X11 forwarding<\/strong><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a>
\nDownload Additional fonts for Xming from download link :http:\/\/sourceforge.net\/projects\/xming\/files\/<\/a><\/strong><\/p>\n

After downloading walk down through the following steps for installation<\/p>\n

\"\"<\/a><\/p>\n

Now start the Xming server<\/strong> by clicking on the Desktop icon.<\/p>\n

\u201cEnable X11Forwarding yes<\/strong>\u201d in \/etc\/ssh\/sshd_config\u00a0<\/strong>& restart the ssh service.
\nConfigure X11 Forwarding in SSH Clients<\/strong>
\nPuTTY SSH<\/strong>
\nIn the PuTTY configuration window, select “Connection->SSH->X11<\/strong>” and make sure the “Enable X11″<\/strong> forwarding box is checked, then return to the Session category and click [Open] when you are ready to connect to the specified machine:<\/p>\n

\"\"<\/a><\/p>\n

Once you login with your pem file as ubuntu or ec2-user<\/strong> type below command.<\/p>\n

[shell]$ xauth list
\n $ oracle.intelligrape.com\/unix:10 MIT-MAGIC-COOKIE-1 8ea792a81074c62518d53789faf9558d[\/shell]<\/p>\n

Now login as oracle<\/strong> user.<\/p>\n

[shell]$ su \u2013 oracle
\n $ xauth add oracle.intelligrape.com\/unix:10 MIT-MAGIC-COOKIE-1 8ea792a81074c62518d53789faf9558d[\/shell]<\/p>\n

Now go to the unzipped database<\/strong> directory & run runInstaller<\/strong>script.<\/p>\n

[shell]$ cd database
\n$ .\/runInstaller[\/shell]<\/p>\n

Note<\/strong> :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.<\/p>\n

\"\"<\/a><\/p>\n

Press \u201cContinue<\/strong>\u201d for resuming the Oracle installation<\/p>\n

\"\"<\/a><\/p>\n

Click Yes to continue installation<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Click Yes to continue installation.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

The pdksh<\/strong> package is not available in Oracle repository<\/strong> due to which you need to download and install it manually.<\/p>\n

[shell]# wget ftp:\/\/rpmfind.net\/linux\/redhat-archive\/6.2\/en\/os\/i386\/RedHat\/RPMS\/pdksh-5.2.14-2.i386.rpm[\/shell]<\/p>\n

During pdksh<\/strong> package installation you may encounter conflict error of ksh<\/strong> package. Remove ksh<\/strong> package forcefully and install the pdksh<\/strong> package with given below command:-<\/p>\n

[shell]# rpm -e ksh-20100621-19.el6_4.4.i686 –nodeps
\n# rpm -ivh pdksh-5.2.14-2.i386.rpm[\/shell]<\/p>\n

In case you face any more errors you can Check\u201cIgnore All\u201d checkbox& install the mentioned packages externally if required.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Click on Password Management<\/p>\n

\"\"<\/a><\/p>\n

Set password for user \u201cSYS\u201d<\/strong>& click \u201cOK<\/strong>\u201d to continue.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Run the following configuration scripts<\/strong><\/p>\n

[shell]
\n # cd \/u01\/app\/oraInventory<\/p>\n

# .\/orainstRoot.sh[\/shell]<\/p>\n

Changing permissions of \/u01\/app\/oraInventory.
\nAdding read,write permissions for group.
\nRemoving read,write,execute permissions for world.<\/p>\n

Changing groupname of \/u01\/app\/oraInventory<\/strong> to oinstall.
\nThe execution of the script is complete.<\/p>\n

[shell]# cd \/u01\/app\/oracle\/product\/11.2.0\/dbhome_2\/
\n# .\/root.sh[\/shell]<\/p>\n

Running Oracle 11g root.sh script…<\/p>\n

The following environment variables are set as:<\/p>\n

[shell]
\nORACLE_OWNER= oracle
\nORACLE_HOME= \/u01\/app\/oracle\/product\/11.2.0\/dbhome_2
\n[\/shell]<\/p>\n

Enter the full pathname of the local bin directory:<\/p>\n

[shell]
\n[\/usr\/local\/bin]:
\nCopying dbhome to \/usr\/local\/bin …
\nCopying oraenv to \/usr\/local\/bin …
\nCopying coraenv to \/usr\/local\/bin …
\nCreating \/etc\/oratab file…
\n[\/shell]<\/p>\n

Entries will be added to the \/etc\/oratab file as needed by\u00a0Database Configuration Assistant when a database is created.<\/p>\n

Finished running generic part of root.sh script.<\/p>\n

Now product-specific root actions will be performed.<\/p>\n

Finished product-specific root actions.<\/p>\n

Installation of Oracle database is Successful;<\/p>\n

<a href=”\/blog\/wp-ttn-blog\/uploads\/2013\/12\/15.png”><img class=”alignnone size-full wp-image-11293″ title=”15″ src=”\/blog\/wp-ttn-blog\/uploads\/2013\/12\/15.png” alt=”” width=”402″ height=”251″ \/><\/a><\/p>\n

In order to check whether oracle is installed login as oracle user.<\/p>\n

[shell]$ export ORACLE_SID=orcl<\/p>\n

$ sqlplus \/ as sysdba
\n SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 24 01:37:49 2013<\/p>\n

Copyright (c) 1982, 2009, Oracle. All rights reserved.
\n Connected to:
\n Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
\n With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/p>\n

SQL>[\/shell]<\/p>\n

This completes the installation. Enjoy!!!!!<\/p>\n

Hopefully the above mechanism will work on other Cloud environments as well.<\/p>\n

Work Hard\u2026..Party Harder\u2026\u2026\u2026\u2026\uf04a\uf04a\uf04a!!!!!!!<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":91,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":87},"categories":[1174,2348],"tags":[1172,248,1259],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/11261"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=11261"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/11261\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=11261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=11261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=11261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}