Installing Oracle on Linux
Requirements
-
Create Users and groups
-
Creating directories for installing oracle
-
Change Kernel Parameters
-
Install Oracle
-
Create User and groups
#groupadd oinstall
#groupadd dba
#useradd –m –g oinstall –G dba oracle
#passwd oracle
-
Creating directories for installing oracle
For Applicaiton
#Mkdir –p /u01/app/oracle
#Chown –R oracle:oinstall /u01/app/oracle
For data
#mkdir -p /u02/oradata
#chown –R oracle:oinstall /u02/
-
Change Kernel Parameters
Sysctl file
# vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
Limits file
#vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Login file
#vi /etc/pam.d/login
session required /lib/security/pam_limits.so
profile file
#vi /etc/profile
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
-
Install Oracle
# cd /opt/database
#./runInstaller
-
Advance installation
-
Enterprise edition
-
Application path /u01/app/oracle/product/10.2.0/db_1
-
Create database
-
Transaction processing
-
Global database (gtldev.localdomain sid gtldev)
-
Unicode standard utf-8 AL32F8
-
File system storage ( /u02/oradata/
-
Do not enable backup
-
Password
-
Install
After installation run two scripts
-
# cd /home/orainventory
-
#./orainstroot.sh
-
#cd /u01/app/oracle/product/10.2.0_db1/
-
#./root.sh
Web Console
http://192.168.*.*/em