oracle 11gr2 rac 安装

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

简要安装流程如下:

一安装GI

1 Creating Groups, Users and directories 

 

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

2 config storage 

2.1vi /etc/scsi_id.config

adding ptions=-g

 

2.2 vi /etc/udev/rules.d/99-oracle-asmdevices.rules

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

2.3 /sbin/start_udev

3  config network

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

5 Resource Limits

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

 

6  Environment Requirements

grid 用户

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

oracle用户 :

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

7 install Package 

8 config ntp

# /sbin/service ntpd stop

# chkconfig ntpd off

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

rm /var/run/ntpd.pid

9 disable selinux and firewall

10 install

二: 创建磁盘组

三:安装DB

四 :创建实例

 

五:安装后工作

1 备份ASM HEARDER 

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

2 备份asm 元数据

 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 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-750501/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-750501/