Wednesday, September 2, 2015

Oracle 12c preinstallation steps

https://oracle-base.com/articles/12c/oracle-db-12cr1-installation-on-oracle-linux-5
https://www.youtube.com/watch?v=8gQvNFqUQTU
http://dbaworkshop.blogspot.it/2013/07/How-to-change-the-open-mode-of-listed-PDBs.html

uname -a

edit host files
==============
vi/etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               welsfargo12c localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
192.168.1.40    welsfargo_12C.localdomain  oracle_12C


vi /etc/sysctl.conf
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

systctl -p - applychanges

:wq

Run the following command to change the current kernel parameters.

/sbin/sysctl -p


Add the following lines to the "/etc/security/limits.conf" file.
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

:wq!

step 4 Install dependencies
===============================




# From Public Yum or ULN
yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i386 -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.i386 -y
yum install ksh -y
yum install libaio -y
yum install libaio.i386 -y
yum install libaio-devel -y
yum install libaio-devel.i386 -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i386 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i386 -y
yum install libXext -y
yum install libXext.i386 -y
yum install libXtst -y
yum install libXtst.i386 -y
yum install libX11 -y
yum install libX11.i386 -y
yum install libXau -y
yum install libXau.i386 -y
#yum install libxcb -y
#yum install libxcb.i386 -y
yum install libXi -y
yum install libXi.i386 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y

if you dont have access to repository you can use Yum command


rpm -qa |grep -i binutils -y
OR
yum install unixODBC-devel -y




step 5 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

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

step 6 -/etc/security/limits.d/90-nproc.conf
========================================
vi /etc/security/limits.d/90-nproc.conf
*      -nproc  16384
root   soft nproc  unlimited
:wq!

step7 -Set SELINUX
vi /etc/selinux/config
SELINUX=disabled



STEP 8 :STOP FIREWALLS

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.

# service iptables stop
# chkconfig iptables off

STEP 9:Create the directories in which the Oracle software will be installed.

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

STEP10 :fire command
xhost +


add Host file

step 11 :Add the following lines at the end of the "/home/oracle/.bash_profile" file.

su - oracle

vi .bash_profile
export PATH
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=ol5-121.localdomain
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_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

:wq!
APPLY CHANGES TO BASH
. ./.bash_profile


DOWNLOAD ORACLE FROM WEBSITE
===========================






No comments:

Post a Comment