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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Solaris 10.5 安裝Oracle 11gR2Oracle
- linux7 靜默安裝 11GR2 RACLinux
- Oracle RAC 11gR2開啟歸檔Oracle
- Oracle 11G RAC叢集安裝(3)——安裝OracleOracle
- oracle rac資料庫的安裝Oracle資料庫
- vgant 安裝oracle資料庫racOracle資料庫
- centos7 安裝ORACLE 11.2.0.4.0 RACCentOSOracle
- Solaris下Oracle RAC 11.2.0.4 安裝方法Oracle
- ORACLE 11GR2 RAC的網路規劃解析Oracle
- 操作規範(四)——Linux 5.4安裝Oracle 11gR2LinuxOracle
- Oracle RAC叢集解除安裝步驟Oracle
- Linux下Oracle 11.2.0.1 RAC安裝筆記LinuxOracle筆記
- Oracle Linux 7.1 靜默安裝Oracle 18c RACOracleLinux
- Oracle 11gR2(11.2.0.4)安裝包(7個)作用說明Oracle
- redhat7.6安裝Oracle11G RACRedhatOracle
- Oracle 11G RAC叢集安裝(2)——安裝gridOracle
- Oracle:Redhat 7 + Oracle RAC 11g 安裝 bug 總結OracleRedhat
- 【配置上線】靜默安裝資料庫Oracle 11gR2資料庫Oracle
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- Oracle 19c RAC on Linux 7.6安裝手冊OracleLinux
- Oracle 11gR2 RAC 單網路卡轉雙網路卡繫結配置Oracle
- 通過ORACLE VM virtualbox環境安裝oracle 11G RAC(ASM)OracleASM
- 【BUILD_ORACLE】Oracle 19c RAC搭建(五)DB軟體安裝UIOracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建(四)Grid軟體安裝UIOracle
- oracle 11g RAC 安裝前準備指令碼Oracle指令碼
- 靜默方式安裝11gR2
- Oracle 11gR2 RAC 叢集服務啟動與關閉總結Oracle
- Oracle 11G RAC叢集安裝(1)——安裝前的準備Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建(一)安裝資源規劃UIOracle
- 麒麟 V10 一鍵安裝 Oracle 11GR2(231017)單機版 2Oracle
- rac靜默安裝
- 11gR2 RAC新增節點步驟
- RedHat Advance Server上安裝Oracle 9204 RAC參考手冊(轉)RedhatServerOracle
- ORACLE11GR2 RAC解除安裝ASM例項步驟OracleASM
- 【ASK_ORACLE】安裝Oracle RAC 12.2的GI軟體時報錯CLSRSC-614Oracle
- vmware + 裸裝置 + crs + oracle10g RAC搭建步驟(二):安裝linuxOracleLinux
- 2節點RAC安裝
- 安裝RAC 19C