Oracle Database Experts

By Charles Kim

October 18th, 2007

Kernel parameters for Oracle Discoverer

/etc/security/limits.conf

* soft nproc 2047

* hard nproc 16384

* soft nofile 2048

* hard nofile 65536

 

/etc/pam.d/login

# for Oracle

session required /lib/security/pam_limits.so

 

/etc/profile

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

October 18th, 2007

Unix: Create oracle user

groupadd -g 500 oinstall

groupadd -g 501 dba

mkdir -p /apps/oracle

mkdir -p /var/opt/oracle

useradd -u 500 -d /home/oracle -g oinstall -G dba -s /bin/bash oracle

chown oracle:dba /apps/oracle /var/opt/oracle

October 18th, 2007

Default Values for Voting Disks

Default values are 30 seconds for the network heartbeat and 200 seconds for I/O to a voting disk. Consequently, Oracle Clusterware may wait a minimum of 30 seconds before initiating a cluster membership reconfiguration and ejecting a failed node. Oracle support may also recommend increasing the time-outs to accommodate peak workload periods.

|