oracle 11gr2 rac 安裝

環境:virtual box +oracle linux 5.5+oracle 11g rac11.2.0.1

簡要安裝流程如下:

groupadd oinstall

groupadd asmadmin

groupadd asmdba

groupadd asmoper

groupadd dba

groupadd oper

useradd -g oinstall -G asmadmin,asmdba,asmoper grid

useradd -g oinstall -G dba,oper,asmdba oracle

passwd grid

passwd oracle

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2.0/grid

chown -R grid:oinstall /u01

mkdir -p /u01/app/oracle

chown oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

id nobody

adding ptions=-g

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB7b67e283-b1cc79c0_", NAME="asm-diskb", WNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBc48c2f60-42cce267_", NAME="asm-diskc", WNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBc4c85841-369f120c_", NAME="asm-diskd", WNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBfe3e89ca-6fe0cb64_", NAME="asm-diske", WNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBc8b2d054-96318cc3_", NAME="asm-diskf", WNER="grid", GROUP="asmadmin", MODE="0660"

生成命令

# for i in b c d e f; do echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id -g -u -s %p\", RESULT==\"`scsi_id -g -u -s /block/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""; done

vi /etc/hosts

192.168.10.21 node11g1

192.168.10.22 node11g2

10.0.0.11 node11g1-priv

10.0.0.12 node11g2-priv

192.168.10.23 node11g1-vip

192.168.10.24 node11g2-vip

192.168.10.25 scanip

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 1054504960

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

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=1048586

/sbin/sysctl -a | grep shm

Add the following lines to the "/etc/security/limits.conf" file.

grid               soft    nproc   2047

grid                hard    nproc   16384

grid                soft    nofile  1024

grid               hard    nofile  65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

vi .bash_profile

umask 022

ORACLE_SID=+ASM1; export ORACLE_SID

JAVA_HOME=/usr/local/java; export JAVA_HOME

ORACLE_BASE=/u01/app/grid; export ORACLE_BASE

ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME

ORACLE_PATH=/u01/app/oracle/common/oracle/sql; export ORACLE_PATH

QLPATH=/u01/app/common/oracle/sql; export SQLPATH

ORACLE_TERM=xterm; export ORACLE_TERM

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

PATH=${PATH}:/u01/app/common/oracle/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export CLASSPATH

RACLE_SID=racdb1; export ORACLE_SID

ORACLE_UNQNAME=racdb; export ORACLE_UNQNAME

JAVA_HOME=/usr/local/java; export JAVA_HOME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATH

ORACLE_TERM=xterm; export ORACLE_TERM

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

PATH=${PATH}:/u01/app/common/oracle/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export CLASSPATH

THREADS_FLAG=native; export THREADS_FLAG

umask 022

# /sbin/service ntpd stop

# chkconfig ntpd off

# mv /etc/ntp.conf  /etc/ntp.conf.org  

rm /var/run/ntpd.pid

dd if=/dev/sdb f=/home/grid/asmbak/sdb.dd bs=4096 count=1

dd if=/dev/sdc of=/home/grid/asmbak/sdc.dd bs=4096 count=1

dd if=/dev/sdd of=/home/grid/asmbak/sdd.dd bs=4096 count=1

 ASMCMD> md_backup /home/grid/asmbak/asm1219.mdx

Disk group metadata to be backed up: CRS

Disk group metadata to be backed up: DATA

Current alias directory path: zzwsjdb-cluster

Current alias directory path: zzwsjdb-cluster/ASMPARAMETERFILE

Current alias directory path: zzwsjdb-cluster/OCRFILE

Current alias directory path: RACDB

Current alias directory path: RACDB/TEMPFILE

Current alias directory path: RACDB/PARAMETERFILE

Current alias directory path: RACDB/ONLINELOG

Current alias directory path: RACDB/CONTROLFILE

Current alias directory path: RACDB/DATAFILE