oracle 10g rac install for linux

selectshen發表於2014-10-30
rhel10g03  --a
pub 123.0.0.110  vip 123.0.0.210 priv 124.0.0.110 storage 125.0.0.110
rhel10g04  --b
pub 123.0.0.111  vip 123.0.0.211 priv 124.0.0.111 storage 125.0.0.111

1.--a,b
vi /etc/hosts
123.0.0.110     rhel10g03
123.0.0.111     rhel10g04
123.0.0.210     rhel10g03-vip
123.0.0.211     rhel10g04-vip
124.0.0.110     rhel10g03-priv
124.0.0.111     rhel10g04-priv
2.--a,b
[root@rhel10g03 ~]# vi /etc/redhat-release
[root@rhel10g03 ~]# groupadd oinstall
[root@rhel10g03 ~]# groupadd dba
[root@rhel10g03 ~]# useradd -d /home/oracle -g oinstall -G dba oracle
[root@rhel10g03 ~]# passwd oracle
[root@rhel10g03 ~]# id oracle
3.--a,b
vi /home/oracle/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=rh10g21
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
ulimit -u 16384 -n 65536
umask 022

[root@rhel10g03 ~]# .  /home/oracle/.bash_profile
4.--a,b
[root@rhel10g03 ~]# mkdir -p /u01/app/oracle /u02/oradata
[root@rhel10g03 ~]# chown -R oracle.oinstall  /u01/app/oracle /u02/oradata
[root@rhel10g03 ~]# chmod -R 775 /u01/app/oracle /u02/oradata

[root@rhel10g03 ~]# vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 1073741824
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
[root@rhel10g03 ~]# sysctl -p

[root@rhel10g03 ~]# vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

[root@rhel10g03 ~]# vi /etc/pam.d/login
session required /lib/security/pam_limits.so

[root@rhel10g03 ~]# vi /etc/rc.local
modprobe hangcheck-timer hangcheck-tick=30 hangcheck_margin=180

4.--a,b
service iscsi start
chkconfig iscsi on
chkconfig iscsi --list
iscsiadm -m discovery -t sendtargets -p 125.0.0.200:3260
iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.4866fae01dc7 -p 125.0.0.200:3260 -l
iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.4866fae01dc7 -p 125.0.0.200:3260 --op update -n node.startup -v automatic
5.--a
fdisk -l
分割槽ocr,voting,data
--b
partprobe

--a,b
root@rhel10g03 ~]# vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="/dev/sdb1",RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="17",RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", KERNEL=="/dev/sdb2",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="18",RUN+="/bin/raw /dev/raw/raw2 %M %m"
ACTION=="add", KERNEL=="/dev/sdb3",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="19",RUN+="/bin/raw /dev/raw/raw3 %M %m"
ACTION=="add", KERNEL=="/dev/sdb4",RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="20",RUN+="/bin/raw /dev/raw/raw4 %M %m"
KERNEL=="raw[1-4]", OWNER="oracle", GROUP="oinstall", MODE="640"

start_udev
ls /dev/raw/ -l

6.--a,b
[root@rhel10g03 ~]# crontab -l
*/15 * * * * /usr/sbin/ntpdate 123.0.0.50 > /home/oracle/ntp.log 2>&1

7.--a,b
[root@rhel10g03 dev]# su - oracle
[oracle@rhel10g03 ~]$ mkdir ~/.ssh
[oracle@rhel10g03 ~]$ chmod 700 ~/.ssh
[oracle@rhel10g03 ~]$ ssh-keygen -t rsa
[oracle@rhel10g03 ~]$ ssh-keygen -t dsa
--a
[oracle@rhel10g03 ~]$ cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[oracle@rhel10g03 ~]$ cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[oracle@rhel10g03 ~]$ ssh 123.0.0.111 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[oracle@rhel10g03 ~]$ ssh 123.0.0.111 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[oracle@rhel10g03 ~]$ scp ~/.ssh/authorized_keys 123.0.0.111:~/.ssh/authorized_keys
--a,b
[oracle@rhel10g03 ~]$ ssh rhel10g03 date
[oracle@rhel10g03 ~]$ ssh rhel10g03-priv date
[oracle@rhel10g03 ~]$ ssh rhel10g04 date
[oracle@rhel10g03 ~]$ ssh rhel10g04-priv date

8.--a
安裝clusterware
       執行root.h時 --a,b      
       [oracle@rhel10g03 ~]$ vi /u01/app/oracle/product/10.2.0/crs_1/bin/vipca
       Remove this workaround when the bug 3937317 is fixed
       arch=`uname -m`
       if [ "$arch" = "i686" -o "$arch" = "ia64" ]
       then
       LD_ASSUME_KERNEL=2.4.19
       export LD_ASSUME_KERNEL
       fi
       unset LD_ASSUME_KERNEL
       #End workaround      
       [oracle@rhel10g03 ~]$ vi /u01/app/oracle/product/10.2.0/crs_1/bin/srvctl
       找到如下內容:
       LD_ASSUME_KERNEL=2.4.19
       export LD_ASSUME_KERNEL
       同樣在其後新增加一行:
       unset LD_ASSUME_KERNEL
在第二臺執行root.sh時,出現若
       Error 0(Native: listNetInterfaces:[3])
       [Error 0(Native: listNetInterfaces:[3])]
       --b
       [oracle@rhel10g04 bin]$ ./oifcfg iflist
       oracle@rhel10g04 bin]$ ./oifcfg setif -global eth0/123.0.0.0:public
       [oracle@rhel10g04 bin]$ ./oifcfg setif -global eth1/124.0.0.0:cluster_interconnect
       [oracle@rhel10g04 bin]$ ./oifcfg getif
       圖形介面下用root執行vipca
[oracle@rhel10g04 dbs]$ /u01/app/oracle/product/10.2.0/crs_1/bin/./crs_stat -t

9.--a
安裝資料庫

10.--a
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 123.0.0.210)(PORT = 1521))' sid='rhel10g03';

11.--b
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 123.0.0.211)(PORT = 1521))' sid='rhel10g04';

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28539951/viewspace-1314979/,如需轉載,請註明出處,否則將追究法律責任。

相關文章