Archive for the ‘Installs’ Category

The following are the steps I used to install Oracle 12c on Red Hat 6

Download the Software from Technet
The 2 zip files needed are linuxamd64_12c_database_1of2.zip & linuxamd64_12c_database_2of2.zip

OS Settings
Ensure the Hostname is in /etc/hosts

[root@dba05tst stage]# cat /etc/hosts |grep dba05tst
172.23.11.222 dba05tst

Disable the Firewall Settings

[root@dba05tst stage]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
[root@dba05tst stage]# service iptables stop
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
[root@dba05tst stage]# chkconfig iptables off
[root@dba05tst stage]# service network restart
Shutting down interface eth0: Device state: 3 (disconnected)
[ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/1
[ OK ]

Kernel Settings
Add the following settings to /etc/sysctl.conf

#Oracle settings
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

Apply the settings using sysctl -p

[root@dba05tst stage]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
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

Create the Users and Groups and directories

[root@dba05tst stage]# groupadd -g 500 oinstall
[root@dba05tst stage]# groupadd -g 501 dba
[root@dba05tst stage]# useradd -u 502 -g oinstall -G dba oracle
[root@dba05tst stage]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is too simplistic/systematic
Retype new password:
passwd: all authentication tokens updated successfully.
[root@dba05tst stage]# mkdir -p /u01/app/oracle/product/12.1.0
[root@dba05tst stage]# chown -R oracle:oinstall /u01
[root@dba05tst stage]# chmod -R 775 /u01

Add the following Entries to /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

Change Settings in /etc/security/limits.d/90-nproc.conf and /etc/selinux/config

The setting should be as follows:

[root@dba05tst stage]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

[root@dba05tst stage]# cat /etc/security/limits.d/90-nproc.conf
# Default limit for number of user's processes to prevent
# accidental fork bombs.
# See rhbz #432903 for reasoning.

# Comment the following Line
* soft nproc 1024

# Include the following Line
* - nproc 16384

AdditonalSoftware packages
Make sure the software disk is mounted

[root@dba05tst Packages]# mkdir /tmp/packages
[root@dba05tst Packages]# pwd
/media/RHEL_6.2 x86_64 Disc 1/Packages

rpm -Uvh kernel-headers-2.6.32-220.el6.x86_64.rpm
rpm -Uvh glibc-headers-2.12-1.47.el6.x86_64.rpm
rpm -Uvh compat-libcap1-1.10-1.x86_64.rpm
rpm -Uvh libmpcdec-1.2.6-6.1.el6.x86_64.rpm
rpm -Uvh mpfr-2.4.1-6.el6.x86_64.rpm
rpm -Uvh cpp-4.4.6-3.el6.x86_64.rpm
rpm -Uvh libgomp-4.4.6-3.el6.x86_64.rpm
rpm -Uvh ppl-0.10.2-11.el6.x86_64.rpm
rpm -Uvh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
rpm -Uvh gcc-4*x86_64*
rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-x86_64
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*
rpm -Uvh openssh-clients-5.3p1-70.el6.x86_64.rpm

Add the following to .profile or bash_profile

oracle@dba05tst ~]$ cat .profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0
export ORACLE_SID=TEST12C
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

Unzip the software

[oracle@dba05tst stage]$ unzip linuxamd64_12c_database_1of2.zip
[oracle@dba05tst stage]$ unzip linuxamd64_12c_database_2of2.zip

CVU Bug [ID 1304727.1]

Change CV_ASSUME_DISTID=OEL4 to CV_ASSUME_DISTID=OEL6 in /stage/database/stage/cvu/cv/admin/cvu_config

Start the installer

[oracle@dba05tst database]$ xclock
Error: Can't open display:
[oracle@dba05tst database]$ export DISPLAY=172.23.0.90:0.0
[oracle@dba05tst database]$ xclock
[oracle@dba05tst database]$ pwd
/stage/database
[oracle@dba05tst database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 15944 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4031 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-11-11_02-10-39PM. Please wait ...

Untick I wish to receive security updates via My Oracle Support and press Next then Yes
Select Skip software updates then next
Select Install database software only then next
Select Single instance database installation then next
Select English and English (United Kingdom) then next
Select database edition then next
Select oracle base and oracle software location then next
Select inventory location and group name then next
Select os groups then next
Make sure no issues then press install

Run the root.sh scripts

[root@dba05tst Packages]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@dba05tst Packages]# /u01/app/oracle/product/12.1.0/root.sh
Performing root user operation for Oracle 12c

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.