How to install ORACLE 12c R1 on ORACLE Linux 7 step by step

-
In this post i’m going to demonstrate you how to install ORACLE 12c Release 1 (12.1) on ORACLE LINUX-7 64 bit step by step. For ORACLE 12c  installation minimum 2GB swap required.


Download ORACLE 12c R1 software form www.oracle.com accept OTN License Agreement, it’s download in two parts and it’s zip file.

After downloading software unzip file using the following command.

STEP-1. 

# mkdir /u01
# unzip linuxamd64_12102_database_1of2 -d/u01
# unzip linuxamd64_12102_database_2of2 -d/u01


After unzip these zip files now you have a single folder name is “database” which is containing installation file.


STEP-2.

we have two Installation methods

Automatic
Manual

1. Automatic: For automatic installation run below command but before running below command you must have to configure YUM Server.

# yum install oracle-rdbms-server-12cR1-preinstall -y
this command is set automatically all requirement settings.

STEP-3.

2. Manual setup:

Add bellow lines in “/etc/sysctl.conf” file using below command.

# vi /etc/sysctl.conf (open this file and past bellow parameters in end of this file).

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
save changes using press Esc then Shift+: then wq then hit Enter

After saving these changes, run below command for applying changes.

# /sbin/sysctl -p


STEP-4.

Add bellow line in ‘/etc/security/limits.conf’ using bellow command.

# vi /etc/security/limits.conf

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768


STEP-5.

Now install Linux packages which is required for ORACLE installation, following bellow command, here we are installing 
.rpm file using YUM server, for YUM server configuration please visit on my website and to through it. May be some packages are already install.

yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -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 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 libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install zlib-devel.i686 -y

STEP-6.

Now create some groups and user, using following commands.

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper

Add ORACLE user.

useradd -u 54321 -g oinstall -G dba,oper oracle

set the password for ORACLE user using following command.

passwd oracle

STEP-7.

Change SELINUX mode using below command.

# vi /etc/selinux/config

SELINUX=permissive

And firewall must be disabled, using bellow command.

# systemctl disable firewalld

STEP-8.

Now create some appropriate Directories where is ORACLE software will be install, and giving privileges, using bellow command.

mkdir -p /u01/app/oracle/product/12.1.0/dbhome_1
chown -R oracle:oinstall /u01 /u02 /u03 /u04 /u05 /u06 /u07 /u08
chmod -R 775 /u01 /u02 /u03 /u04 /u05 /u06 /u07 /u08

STEP-09.

Now switch in ORACLE user and add bellow lines in end of file, using bellow command.

# su – oracle

$ vi .bash_profile

# Oracle installation Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=ol7.localdomain
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=cdb1

export PATH=/usr/sbin:$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

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

After saving this file, exit from ORACLE user and Restart your pc.

# reboot

STEP-10.

Now login with ORACLE user and start runInstaller using bellow command.

$ cd /u01/database
$ ./runInstaller



Comments

Post a Comment

Popular posts from this blog

Step by Step: How to troubleshoot a slow running query in Oracle

-
This is a day to day task of a DBA. Someone from application team comes to our desk and simply says a query is running slow. We may question him on many things but ultimately a DBA has to tune the query at the end. This is also very popular and known question for the DBA's who are attending interviews. This question is simply asked again and again. I have also been asked this question multiple times. After a pause, interviewer simply asks...so suppose a user comes and reports that his query is running slow, what will be your approach to tune this. There is no absolute or concrete answer to this question because there might be multiple way to tune a slow running query. Everyone can have a different approach. So here is my approach: Very first thing we have to find which type of query is running slow. Whether it is SELECT query of DML statements(insert, update, delete and merge). So first we will see how to tune a SELECT query Step 1 – Find the SQL_ID of the ...
Read more

Register Archive log file manually in standby Database

-
  Some time, the archive logs are not shipping to standby location due to network issue.  There may be  several  archive logs are waiting in standby location for one archive log file. For instance, Archive log sequence # 100 is not shipped to standby location. But other archive logs(sequence#101 to sequence#200) were shipped to standby and it is waiting to ship the sequence# 100.  In this scenario, DBA can copy the archive log file and register manually. Once manually registered, the sequence#101 to sequence#200 will apply automatically on standby database. Step 1 Let us assume, the archive log file devdb12_1_283_801988635.arc is not shipped to standby due to some reason. Copy the archive log file devdb12_1_283_801988635.arc manually from primary to standby archive destination location. Step  2 Run the below command in standby database. ALTER DATABASE REGISTER LOGFILE '/dbArch/oradata/devdb12/ devdb12_1_283_801988635.arc';   Step  3 Verify th...
Read more

How to check UNDO tablespace usage and who is using more undo

-
Query To check UNDO tablespace usage: ================================ set linesize 152 col tablespace_name for a20 col status for a10 select tablespace_name,status,count(extent_id) "Extent Count", sum(blocks) "Total Blocks",sum(bytes)/(1024*1024*1024) spaceInGB from   dba_undo_extents group by  tablespace_name, status having tablespace_name=upper('&TSNAME') order by tablespace_name; Query To check who is using more UNDO space: ===================================== SET termout ON SET heading ON SET PAGESIZE   6000 SET LINESIZE   200 COLUMN pgm_notes    FORMAT a80        HEADING 'Notes' COLUMN rbs          FORMAT a16         HEADING 'RBS'             JUST center COLUMN oracle_user  FORMAT a12        HEADING 'Oracle|Username' COLUMN sid_serial   FORMAT a12      ...
Read more