Oracle 11g RAC redhat server5.5 64bits

 

—————————————-

—————————————-PACKAGE

mount /dev/cdrom /mnt

rpm -q –qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \

compat-libstdc++-33 \

elfutils-libelf \

elfutils-libelf-devel \

gcc \

gcc-c++ \

glibc \

glibc-common \

glibc-devel \

glibc-headers \

ksh \

libaio \

libaio-devel \

libgcc \

libstdc++ \

libstdc++-devel \

make \

sysstat \

unixODBC \

unixODBC-devel

 

 

——————————————IP

#cat /etc/hosts

127.0.0.1       localhost.localdomain   localhost

# Public

172.16.100.66   rac1

172.16.100.77   rac2

# Private

192.168.1.111   rac1-priv

192.168.1.112   rac2-priv

# Virtual

172.16.100.67   rac1-vip

172.16.100.78   rac2-vip

# SCAN

172.16.100.100  rac-scan

 

/etc/sysconfig/network

NETWORKING=yes

HOSTNAME=ol6-112-rac2.localdomain

 

 

 

 

——————————————LIMIT

/etc/sysctl.conf

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 -p

 

 

cat /etc/security/limits.conf 

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

grid                soft    nproc   2047

grid                hard    nproc   16384

grid                soft    nofile  4096

grid                hard    nofile  65536

grid                soft    stack   10240

 

cat /etc/pam.d/login

session    required     pam_limits.so

 

 

cat /etc/selinux/config

SELINUX=disabled

 

——————————————NTP

Shutting down ntpd:                                        [  OK  ]

# chkconfig ntpd off

# mv /etc/ntp.conf /etc/ntp.conf.orig

# rm /var/run/ntpd.pid

If you are using NTP, you must add the "-x" option into the following line in the "/etc/sysconfig/ntpd" file.

OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

Then restart NTP.

# service ntpd restart

 

——————————————USER

groupadd -g 1200 dba

useradd -u 1100 -g dba  ora11g

useradd -u 1101 -g dba  grid

passwd oracle 

passwd grid

 

 

 

——————————————DIRECTORY

–grid

mkdir -p  /u01/app/11.2.0/grid

–db

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R ora11g:dba /u01

chmod -R 775 /u01/

chown -R grid:dba /u01/app/11.2.0/grid

 

–environment

#add it /home/grid/.bash_profile   user:grid

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/11.2.0/grid

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

umask 022

export   LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

#add it /home/grid/.bash_profile   user:ora11g

export ORACLE_BASE=/u01/app/oracle

export GRID_HOME=/u01/app/11.2.0/grid

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

umask 022

export   LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

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

 

 

——————————————ASM raw

/dev/sdb1 1g crs vtoing

/dev/sdc1 1g crs voting 

    

1>

# grep -v ^# /etc/scsi_id.config

vendor="ATA",options=-p 0×80

options=-g

 

2>

for i in `cat /proc/partitions | awk {'print $4'} |grep sd`; do echo "### $i: `scsi_id -g -u -s /block/$i`"; done

### sdb: 36000c2911a6600a91a6bcb525ef26649

### sdc: 36000c2943446dddf9d725955c2b7bd89

 

5>

#vi /etc/udev/rules.d/61-oracleraw.rules

ACTION=="add", KERNEL=="sd*",  PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="36000c2911a6600a91a6bcb525ef26649", RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add", KERNEL=="sd*",  PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="36000c2943446dddf9d725955c2b7bd89", RUN+="/bin/raw /dev/raw/raw2 %N"

# vi /etc/udev/rules.d/65-raw-permissions.rules

KERNEL=="raw1", OWNER="grid", GROUP="dba", MODE="660"

KERNEL=="raw2", OWNER="grid", GROUP="dba", MODE="660"

/sbin/udevcontrol reload_rules

start_udev

 

——————————————install crs

$INSTALL_DIR/runcluvfy.sh stage -pre crsinst -n rac1,raac2 -verbose

reboot the host

ping -c 3 rac1

ping -c 3 rac1-priv

ping -c 3 rac2

ping -c 3 rac2-priv

 

$ ./runInstaller

chose advice install

tail -f /u01/app/oraInventory/logs/installActions2011-12-26_12-54-09PM.log

tail -f /u01/app/11.2.0/grid/log/rac1/alert_rac1.log

tail -f /u01/app/11.2.0/grid/cfgtoollogs/crsconfig/rootcrs_rac1.log

 

Resolve

[INS-20802] Oracle Cluster Verification Utility failed

meatlink  887471.1 忽略

INFO: PRVG-1101 : SCAN name "rac-scan" failed to resolve

INFO: ERROR: 

INFO: PRVF-4657 : Name resolution setup check for "rac-scan" (IP address: 172.16.100.100) failed

For cause 1: Oracle strongly recommend to use DNS or GNS for SCAN name resolution as hosts file support only one IP for SCAN name.

If you intended to use hosts file for SCAN name resolution, and ping command returns correct SCAN VIP, you can ignore the error and move forward.

If you intend to use DNS or GNS for SCAN name resolution, please comment out entries in hosts file for SCAN name, and re-run “$GRID_HOME/bin/cluvfy comp scan” to confirm.

 

——————————————install database 

$ ./runInstaller

 

…

..

dbca

 

 

2用srvctl 工具添加监听并手动加入静态注册信息

srvctl config network

Network exists: 1/172.16.0.0/255.255.0.0/eth0, type static

               net-number

srvctl add listener -l LISTENER_LANK -o /u01/app/11.2.0/grid -p 2586 -k 1

…

….

….

..

..

..