Set the session limits for Oracle user Setting Kernel Parameters Add the below parameters to /etc/sysctl.conf file # Memory kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 fs.file-max = 65536 #network ports net.ipv4.ip_local_port_range = 1024 65000 # Additional and amended parameters suggested by Kevin Closson net.core.rmem_default = 524288 net.core.wmem_default = 524288 net.core.rmem_max = 16777216 net.core.wmem_max = 16777216 net.ipv4.ipfrag_high_thresh=524288 net.ipv4.ipfrag_low_thresh=393216 net.ipv4.tcp_rmem=4096 524288 16777216 net.ipv4.tcp_wmem=4096 524288 16777216 net.ipv4.tcp_timestamps=0 net.ipv4.tcp_sack=0 net.ipv4.tcp_window_scaling=1 net.core.optmem_max=524287 net.core.netdev_max_backlog=2500 sunrpc.tcp_slot_table_entries=128 sunrpc.udp_slot_table_entries=128 net.ipv4.tcp_mem=16384 16384 16384 Every user on Linux box has certain resource allocation limits The limits can be verified by the command $ulimit -aH Add the following lines to the /etc/security/limits.conf file to set the resource limits for a particular user oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 Add the following line in the /etc/pam.d/login file session required /lib/security/pam_limits.so session required pam_limits.so Configure the Hangcheck Timer Edit /etc/modprobe.conf and add belwo entries options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180 ############################################################################### Creat Group And Users on each nodes /usr/sbin/groupadd -g 501 oinstall /usr/sbin/groupadd -g 502 dba /usr/sbin/groupadd -g 503 oper /usr/sbin/useradd -m -u 501 -g oinstall -G dba,oper oracle passwd oracle -change oracle user password ############################################################################### Add these lines to /home/oracle/.bash_profile # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=cxm-pl-orte02.nonprodcs; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME CRS_HOME=/u01/crs/oracle/product/10.2.0/crs; export CRS_HOME ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi Configure the Host name if not set while installation /etc/sysconfig/network HOSTNAME=cxm-pl-orte01.nonprodcs HOSTNAME=cxm-pl-orte02.nonprodcs ################################################################################################################################# Create Mount Points mkdir -p /u01/app/oracle/product/10.2.0/db_1 mkdir -p /u01/crs/oracle/product/10.2.0/crs mkdir -p /u01/oradata mkdir -p /u01/oraInventory chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/ ########################################################################################################################### Update on both the nodes -nonprodrac update below entries in /etc/sysconfig/rawdevices /dev/raw/raw1 /dev/cciss/c1d1p1 /dev/raw/raw2 /dev/cciss/c1d1p2 /dev/raw/raw3 /dev/cciss/c1d2p1 /dev/raw/raw4 /dev/cciss/c1d2p2 /dev/raw/raw5 /dev/cciss/c1d2p3 Restart rawdevice services # service rawdevices restart run these commands from root user chown root:oinstall /dev/raw/raw1 chown root:oinstall /dev/raw/raw2 chown oracle:oinstall /dev/raw/raw3 chown oracle:oinstall /dev/raw/raw4 chown oracle:oinstall /dev/raw/raw5 Add below lines in /etc/rc.local file chown root:oinstall /dev/raw/raw1 chown root:oinstall /dev/raw/raw2 chown oracle:oinstall /dev/raw/raw3 chown oracle:oinstall /dev/raw/raw4 chown oracle:oinstall /dev/raw/raw5 chmod 640 /dev/raw/raw1 chmod 640 /dev/raw/raw2 chmod 600 /dev/raw/raw3 chmod 600 /dev/raw/raw4 chmod 600 /dev/raw/raw5 ---------------------------- If ASM drives are already installed then configure them by below command otherwise install them manually here and configure /etc/init.d/oracleasm configure Create ASM Disks with ASM Library Driver /etc/init.d/oracleasm createdisk DATA /dev/cciss/c1d1p3 /etc/init.d/oracleasm createdisk FLASH /dev/cciss/c1d2p4 Device Boot Start End Blocks Id System /dev/cciss/c1d3p1 1 71805 292964384 5 Extended [root@cxm-pl-orte01 ~]# [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm createdisk ORADISK1 /dev/cciss/c1d1p4 Marking disk "ORADISK1" as an ASM disk: [ OK ] [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm createdisk ORADISK2 /dev/cciss/c1d2p3 Marking disk "ORADISK2" as an ASM disk: [ OK ] [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm scandisks Scanning the system for Oracle ASMLib disks: ORADISK1 [ OK ] [root@cxm-pl-orte01 ~]# ORADISK1 -bash: ORADISK1: command not found [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm scandisks Scanning the system for Oracle ASMLib disks: ORADISK2 [ OK ] [root@cxm-pl-orte01 ~]# ORADISK2 -bash: ORADISK2: command not found [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm listdisks ORADISK1 ORADISK2 [root@cxm-pl-orte01 ~]# [root@cxm-pl-orte01 ~]# [root@cxm-pl-orte01 ~]# /etc/init.d/oracleasm querydisk Usage: oracleasm-querydisk [-l ] [-v] [-d|-p]