Installation Steps:

Step 1: Download Software

Download the Software from Oracle Edelivery or My Oracle Support.After download the software you got a file like below.

V46095-01_1of2.zip, V46095-01_2of2.zip

Step 2: Unzip

Unpack the software, go to the software directory and type this command.

unzip V46095-01_1of2.zip V46095-01_2of2.zip

step 3 : Oracle Installation Prerequisites

Automatic Setup:

For Oracle Database we need to run some commands for the automatic setup. Before run these commands you Login with the root .

# yum install oracle-database-server-12cR2-preinstall -y

# yum update -y

Manual Setup:

You will need to manually perform the following setup tasks. Add the following lines to the “/etc/sysctl.conf” file, or in a file called “/etc/sysctl.d/98-oracle.conf“.

Go to the sysctl.conf file and edit the info manually like below

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Run the following command to change the current kernel parameters.

/sbin/sysctl -p

Add the following lines to a file called “/etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf” file.

oracle   soft   nofile    1024 
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728

The following packages are listed as required, including the 32-bit version of some of the packages. Many of the packages should be installed already.

Login with the root and perform this commands.

# OL6 and OL7 (RHEL6 and RHEL7) 
yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install glibc -y yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install make -y
yum install nfs-utils -y
yum install net-tools -y
yum install smartmontools -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
# Required for 12.1, not listed for 12.2
yum install gcc -y
yum install gcc-c++ -y
yum install libXext -y
yum install libXext.i686 -y
yum install zlib-devel -y
yum install zlib-devel.i686 -y
# OL6 only (RHEL6 only)
yum install e2fsprogs -y
yum install e2fsprogs-libs -y
yum install libs -y
yum install libxcb.i686 -y
yum install libxcb -y

Create the new groups and users.

groupadd -g 54321 oinstall 
groupadd -g 54322 dba
groupadd -g 54323 oper
#groupadd -g 54324 backupdba
#groupadd -g 54325 dgdba
#groupadd -g 54326 kmdba
#groupadd -g 54327 asmdba
#groupadd -g 54328 asmoper
#groupadd -g 54329 asmadmin
#groupadd -g 54330 racdba useradd -u 54321 -g oinstall -G dba,oper oracle

Step 4:Additional Setup

The following steps must be performed, whether you did the manual or automatic setup.

Set the password for the “oracle” user.

passwd oracle

Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. To disable it, do the following.

# systemctl stop firewalld 
# systemctl disable firewalld

If you are not using Oracle Linux and UEK, you will need to manually disable transparent huge pages.

Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/12.2.0.1/db_1 
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Unless you are working from the console, or using SSH tunnelling, login as root and issue the following command.

xhost +<machine-name>

Step 5:

Create a “scripts” directory.

mkdir /home/oracle/scripts

Step 6:

Create an environment file called “setEnv.sh“.

cat > /home/oracle/scripts/setEnv.sh <<EOF 
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP
export ORACLE_HOSTNAME=ol7-122.localdomain
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=cdb1 export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib EOF

Add a reference to the “setEnv.sh” file at the end of the “/home/oracle/.bash_profile” file.

echo ". /home/oracle/scripts/setEnv.sh" >> /home/oracle/.bash_profile

Step 7:

Create a “start_all.sh” and “stop_all.sh” script that can be called from a startup/shutdown service. Make sure the ownership and permissions are correct.

cat > /home/oracle/scripts/start_all.sh <<EOF 
#!/bin/bash .
/home/oracle/scripts/setEnv.sh
export ORAENV_ASK=NO . oraenv
export ORAENV_ASK=YES dbstart \$ORACLE_HOME
EOF




cat > /home/oracle/scripts/stop_all.sh <<EOF
#!/bin/bash .
/home/oracle/scripts/setEnv.sh
export ORAENV_ASK=NO . oraenv
export ORAENV_ASK=YES dbshut \$ORACLE_HOME
EOF



chown -R oracle.oinstall /home/oracle/scripts chmod u+x /home/oracle/scripts/*.sh

Step 8:

Once the installation is complete and you’ve edited the “/etc/oratab“, you should be able to start/stop the database with the following scripts run from the “oracle” user.

~/scripts/start_all.sh
~/scripts/stop_all.sh

Step 9:

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

./runInstaller

After running the runInstaller wizard page will open.

Click Next

Here you can select the Create and configure a database

In this step you can select the Desktop class

Select Single Instance of database Installation you want to perform and click on next

Select Typical Installation and click on Next

Here you can provide the appropriate details and click on Next.

Click on Next

Save the response file and click on Next

Save the url and click on OK. This is the process of installing Oracle Database.

Categories: Uncategorised

Leave a Reply

Your email address will not be published. Required fields are marked *

www.000webhost.com