A. First of all make a decision whether you want to install RPM through ORACLE PUBLIC YUM or Locally. Decide any one before continuing :-

 


A. IF YOU WANT TO DOWNLOAD PACKAGE VIA INTERNET THEN FOLLOW THIS:-

 

1. ORACLE PUBLIC YUM ( INTERNET CONNECTION REQUIRED MIGHT TAKES TIMES FOR YUM INSTALL)

-- If you want to perfom YUM INSTALL ORACLE PUBLIC YUM then follow the below mentioned I, II and III steps only and follow

I. [root@storage yum.repos.d]# cd /etc/yum.repos.d
II. oraclenepal[root@storage yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo

III. [root@storage yum.repos.d]# vi public_yum_ol6.repo
MAKE all enable = 0 to 1 ( ie enable=1)

 

NOTE : AFTER FOLLOWING ABOVE STEPS I, II and III. FOLLOW DIRECTLY TO STEP 3 FROM MANUAL STEPS  AND MAKE SURE YOU HAVE A INTERNET CONNECTION FOR YUM INSTALL.

 

B. YUM INSTALL RPM LOCALLY (INTERNET NOT REQUIRED, LESS TIME CONSUMING). (RECOMENDED)

-- If you want to perform YUM INSTALL through locally then follow the below mentioned  MANUAL STEPS from 1.

 

Note : Oracle Installation can be performed through AUTOMATIC SETUP and MANUAL SETUP. We will follow MANUAL SETUP.

 

AUTOMATIC STEPS

 

For AUTOMATIC SETUP follow this steps :-

[root@storage yum.repos.d]# yum install oracle-rdbms-server-11gR2-preinstalled

 

MANUAL STEPS

For MANUAL SETUP, If you haven't run this command # yum install oracle-rdbms-server-11gR2-preinstall then follow the below mentioned steps :-

 

1. Installation Required RPMs

Insert OEL6.5  into the DVD-ROM

media.JPG

 

2. Create a Directory for RPM backup and Copy all the RPM inside /stage/Disk1

[root@storage OL6.5 x86_64 Disc 1 20131125]# mkdir -p /stage/Disk1

mkdir.JPG

[root@storage OL6.5 x86_64 Disc 1 20131125]# cp -r /media/OL6.5 x86_64 Disc 1 20131125/* /stage/Disk1

rpmcopy.JPG
[root@storage Packages]# cd /stage/Disk1/Packages

[root@storage Packages]# rpm -ivh createrepo-0.9.9-18.0.1.el6.noarch.rpm deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm

rpmcreaterepo.JPG

[root@storage Packages]# createrepo /stage/Disk1/Packages

Spawning worker 0 with 3754 pkgs

Workers Finished

Gathering worker results

 

Saving Primary metadata

Saving file lists metadata

Saving other metadata

Generating sqlite DBs

Sqlite DBs complete

[root@storage Packages]#

create_repo.JPG

 

[root@storage Packages]# cd /etc/yum.repos.d

[root@storage yum.repos.d]# vi packages.repo

[server]

name=server's packages

baseurl=file:///stage/Disk1/Packages

enabled=1

gpgcheck=0

packagerepo.JPG

3. [root@storage yum.repos.d]# yum -y install compat-libcap1*i686* compat-libcap1*86_64* compat-libstdc++*x86_64* elfutils-devel*x86_64* elfutils-libelf-devel*x86_64* gcc-c++*x86_64*glibc*i686* glibc-devel*i686* libaio*i686* libaio-devel*x86_64* libattr*i686*libcap*i686* libgcc*i686* libstdc++-devel*x86_64* libtool-ltdl*i686* ncursesdevel*i686* ncurses-libs*i686* nss-softokn-freebl*i686* pdksh*x86_64*readline*686* glibc-devel*x86_64* java*

yuminstall.JPG

After YUM INSTALL completed, You will see the following output.

installed.JPG

4. Configure Kernel

[root@storage Desktop]# vi /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 982431744

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

configure_kernel.JPG

5. [root@storage Desktop]# sysctl -p

sysctl.JPG

6. Specify Resource Limitations

[root@storage Desktop]# vi /etc/pam.d/login

session required pam_limits.so

session.JPG

7. [root@storage Desktop]# vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

limit_conf.JPG

8. Specify Shell Limitations

[root@storage Desktop]# vi /etc/profile

if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then

if [ \$SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

umask 022

 

profile.JPG

9. Disable SELinux

[root@storage Desktop]# setenforce 0

[root@storage Desktop]# vi /etc/sysconfig/selinux

SELINUX=disabled

selinux.JPG

10. Disable Firewall

[root@storage Desktop]# iptables -F

[root@storage Desktop]# service iptables save

iptables: Saving firewall rules to /etc/sysconfig/iptables:[  OK  ]

[root@storage Desktop]# chkconfig iptables off

iptables.JPG

11. Creating OS groups and users.

[root@storage Desktop]# groupadd asmadmin

[root@storage Desktop]# groupadd asmdba

[root@storage Desktop]# groupadd asmoper

[root@storage Desktop]# groupadd oinstall

[root@storage Desktop]# groupadd dba

[root@storage Desktop]# groupadd oper

[root@storage Desktop]# useradd -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid grid

[root@storage Desktop]# useradd -g oinstall -G dba,oper,asmdba -d /home/oracle oracle

[root@storage Desktop]# passwd grid

[root@storage Desktop]# passwd oracle

groupadd.JPG

12. Creating necessary directories

[root@storage Desktop]# mkdir -p /u01/app/grid

[root@storage Desktop]# mkdir -p /u01/app/11.2.0/grid

[root@storage Desktop]# chown -R grid:oinstall /u01

[root@storage Desktop]# mkdir -p /u01/app/oracle

[root@storage Desktop]# chown oracle:oinstall /u01/app/oracle

[root@storage Desktop]# chmod -R 775 /u01

directories.JPG

13. Specify neccessary environment variables for oracle user

[oracle@storage ~]$ vi .bash_profile

ORACLE_SID=orcl; export ORACLE_SID

ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME

JAVA_HOME=/usr/local/java; export JAVA_HOME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

PATH=${PATH}:/u01/app/common/oracle/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export CLASSPATH

THREADS_FLAG=native; export THREADS_FLAG

export TEMP=/tmp

export TMPDIR=/tmp

umask 022

oracle_bashprofile.JPG

14.Specify neccessary environment variables for grid user

[root@storage Desktop]# su - grid

[grid@storage ~]$ vi .bash_profile

ORACLE_SID=+ASM; export ORACLE_SID

JAVA_HOME=/usr/local/java; export JAVA_HOME

ORACLE_BASE=/u01/app/grid; export ORACLE_BASE

ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

PATH=${PATH}:/u01/app/common/oracle/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export CLASSPATH

THREADS_FLAG=native; export THREADS_FLAG

export TEMP=/tmp

export TMPDIR=/tmp

umask 022

grid_bash_profile.JPG

 

15. CONFIGURE HOSTNAME AND IP inside  /etc/hosts. You can give following IP and host name or you can give your own desire  name

 

[root@storage ~]#  vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.227 storage storage.castrading.com localhost localhost.localdomain localhost4 localhost4.localdomain4

[root@storage ~]#

 

16. CONFIGURE ETH0 as following and CONFIGURE IP

 

root@storage network-scripts]#  vi /etc/sysconfig/network-scripts/ifcfg-eth0

[root@storage network-scripts]#  vi ifcfg-eth0

DEVICE=eth0

HWADDR=00:0C:29:77:63:07

IPADDR=192.168.0.227

NETMASK=255.255.255.0

GATEWAY=192.168.0.2

DNS1=192.168.0.2

ONBOOT=yes

BOOTPROTO=static

[root@storage network-scripts]#

 

 

17. FOR SYSTEM DOMAIN NAME RESOLVER CONFIGURE resolv.conf

[root@storage network-scripts]# vi /etc/resolv.conf

# Generated by NetworkManager

search castrading.com

nameserver 192.168.0.2

[root@storage network-scripts]#

 

 

19. Setup Port Forwarding in VMware Workstation

This small walkthrough explains how to configure a port forwarding in VMware Workstation 9 / 10. The same procedure should also work for VMware Workstation 8, 7 and 6.

 

Why do you need port forwarding in VMware Workstation? The main purpose is to make virtual machines available on the network. You could simply use bridged networking, but sometimes NAT fits better to your requirements. If you want your virtual machine to be available no matter what network you are connected to or if you are limited in IP addresses you might have a valid use case for using NAT and for port forwarding.

 

1. Open Virtual Machine Settings (Rightclick -> Settings…) and set your virtual machines network connection to “NAT

 

2. Power on the Virtual Machine and write down the IP address (You could also use a static IP address)

3. Open Virtual Network Editor (Edit -> Virtual Network Editor…)

4. Select VMnet8 / NAT and press NAT Settings…

 

5. Click on NAT SETTING. Make sure of GATEWAY IP. Click on Add  and Type as following

 


6. Configure Port and IP address ( SAME step 5)

 

7. Press OK twice to close NAT Settings and Virtual Network Editor

Finish! You can now access SSH service to the network with your workstations IP address. This is just an example and the port forwarding will also work with any other TCP/UDP Port, as long as it is not in use by your host.

 

18.  STOP and START NETWORK SERVICE
[root@storage ~]# service network stop

[root@storage ~]# service network start

 

ping <hostname> ---> it should ping

 

Now We will begin for ASM Configuration

Preparing Disk for ASM using ASMLib