oracle 10g rac install for linux
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';
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- AIX 5.3 Install Oracle 10g RAC 錯誤集錦AIOracle 10g
- Oracle Linux 7.1 silent install 19C RACOracleLinux
- Oracle 10g RAC故障處理Oracle 10g
- Centos7.2_Oracle12.1.0.2_RAC_installCentOSOracle
- Oracle 11g RAC Silent Install For NFSOracleNFS
- Oracle 10g RAC 資料儲存更換Oracle 10g
- 10g RAC on AIXAI
- Oracle 9i, 10g, and 11g RAC on Linux所需要的Hangcheck-Timer Module介紹OracleLinuxGC
- Oracle 12.2 RAC on Linux Best Practice DocumentationOracleLinux
- Oracle Linux 7.1 silent install 19cOracleLinux
- Oracle Linux 7.1 靜默安裝Oracle 18c RACOracleLinux
- Linux下Oracle 11.2.0.1 RAC安裝筆記LinuxOracle筆記
- oracle RACOracle
- Oracle RAC Cache Fusion 系列十七:Oracle RAC DRMOracle
- Solaris 10下遷移10G RAC (六)
- Solaris 10下遷移10G RAC (八)
- Solaris 10下遷移10G RAC (四)
- Solaris 10下遷移10G RAC (二)
- Solaris 10下遷移10G RAC (七)
- Solaris 10下遷移10G RAC (三)
- Solaris 10下遷移10G RAC (一)
- Solaris 10下遷移10G RAC (五)
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle RAC CacheFusion 系列十五:Oracle RAC CRServer Part TwoOracleServer
- Oracle Linux 6.7中 Oracle 11.2.0.4 RAC叢集CRS異常處理OracleLinux
- oracle 10g在linux下的安裝及簡單命令Oracle 10gLinux
- ORACLE RAC clusterwareOracle
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Oracle 19c RAC on Linux 7.6安裝手冊OracleLinux
- Scheduler in Oracle Database 10g(轉)OracleDatabase
- Oracle 10g 下載地址Oracle 10g
- oracle 10G特性之awrOracle 10g
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- 【RAC】Oracle RAC如何修改心跳網路Oracle
- Oracle RAC Wait EventsOracleAI
- oracle rac 增加磁碟Oracle
- oracle RAC+DG 擴容ASM和表空間(Linux)OracleASMLinux