Oracle 11g in RHEL5.3

Create user: oracle
Create group: oinstall,dba
Add oinstall,dba to user oracle

groupadd oinstall
groupadd dba
useradd oracle -g oinstall -G dba
passwd oracle

[
for OSDBA select dba group, OS users under this group will get SYSDBA privilege
for OSOPER select oinstall group, OS users under this group will get SYSOPER privilege
]

chown oracle /opt/oracle/
chgrp dba /opt/oracle/

increase "tmpfs(/dev/shm)" to >= "memory_max_target" (If use autometic memory management)

unzip two disks in the same folder like below, o
therwise some .ear file missing error may occur:
----------------------------------------
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
cd database
./runInstall


----------------------------
append below lines in file:/etc/sysctl.conf


# Controls the maximum number of shared memory segments

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr=1048576
net.ipv4.ip_local_port_range=9000 65500

net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

---------------------------------
append below lines in file:/etc/security/limits.conf

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536


-----------------------------
append below lines in file:/etc/pam.d/login

session required pam_limits.so

----------------------------
sysctl -p

Package normally missing
-------------------------
libXp libaio libaio-devel unixODBC unixODBC-devel sysatat


vi ~/.bash_profile

PATH=$PATH:$HOME/bin
ORACLE_BASE=/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME PATH

Comments

Popular posts from this blog

Restoring Master, Model and MSDB from Netbackup

Oracle Job Operations