Oracle ASM安裝要點
作業系統:CentOS6.4
Oracle Grid:11.2.0.1
Oracle DataBase:11.2.0.1
1.建立使用者、組
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid
useradd -g oinstall -G dba,asmdba oracle
mkdir /s01
mkdir /g01
chown oracle:oinstall /s01
chown grid:oinstall /g01
mkdir /s01/orabase
mkdir /g01/orabase
chown oracle:oinstall /s01/orabase
chown grid:oinstall /g01/orabase
2.配置環境變數
RAC1-grid
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC2-grid
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC1&RAC2-root
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
RAC1&RAC2-oracle
export ORACLE_HOME=/s01/oracle/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=PROD1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
3.udev裝置繫結
繫結指令碼(root執行)
for i in b c d e f g;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
啟動udev裝置
4.建立軟連結
ln -s /lib/libcap.so.2.16 /lib/libcap.so.1
5.執行root.sh
11.2.0.1版本存在bug,執行root.sh的時候,需要在另外一個視窗以root帳號同時執行
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
這個命令在啟動crsctl start ohasd的時候,也是需要的,否則不能啟動。
如果重新安裝,需要重置共享磁碟使用如下命令
dd if=/dev/zero of=/dev/sdb bs=1M
如果配置RAC叢集,修改/etc/hosts,增加如下內容
192.168.1.70 rac1 rac1.home
192.168.1.71 rac1-vip
192.168.1.80 rac2 rac2.home
192.168.1.81 rac2-vip
192.168.1.200 vip-cluster vip-cluster-scan
172.168.1.1 rac1-priv
172.168.1.2 rac2-priv
127.0.0.1 只能設定為localhost,不能新增RAC1的解析,否則安裝報錯
另外,還是選擇11.2.0.3或者以上版本安裝
11.2.0.1 RAC的bug還真不是一般的多。
Oracle Grid:11.2.0.1
Oracle DataBase:11.2.0.1
1.建立使用者、組
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid
useradd -g oinstall -G dba,asmdba oracle
mkdir /s01
mkdir /g01
chown oracle:oinstall /s01
chown grid:oinstall /g01
mkdir /s01/orabase
mkdir /g01/orabase
chown oracle:oinstall /s01/orabase
chown grid:oinstall /g01/orabase
2.配置環境變數
RAC1-grid
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC2-grid
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC1&RAC2-root
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
RAC1&RAC2-oracle
export ORACLE_HOME=/s01/oracle/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=PROD1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
3.udev裝置繫結
繫結指令碼(root執行)
for i in b c d e f g;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
啟動udev裝置
4.建立軟連結
ln -s /lib/libcap.so.2.16 /lib/libcap.so.1
5.執行root.sh
11.2.0.1版本存在bug,執行root.sh的時候,需要在另外一個視窗以root帳號同時執行
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
這個命令在啟動crsctl start ohasd的時候,也是需要的,否則不能啟動。
如果重新安裝,需要重置共享磁碟使用如下命令
dd if=/dev/zero of=/dev/sdb bs=1M
如果配置RAC叢集,修改/etc/hosts,增加如下內容
192.168.1.70 rac1 rac1.home
192.168.1.71 rac1-vip
192.168.1.80 rac2 rac2.home
192.168.1.81 rac2-vip
192.168.1.200 vip-cluster vip-cluster-scan
172.168.1.1 rac1-priv
172.168.1.2 rac2-priv
127.0.0.1 只能設定為localhost,不能新增RAC1的解析,否則安裝報錯
另外,還是選擇11.2.0.3或者以上版本安裝
11.2.0.1 RAC的bug還真不是一般的多。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29254281/viewspace-1097489/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle12c安裝及使用要點Oracle
- 【Oracle】ASM例項安裝入門OracleASM
- Oracle ASM+11gR2安裝OracleASM
- 探索ORACLE之ASM02_安裝OracleASM
- SUSE 11.1 安裝ORACLE 11.2.0.3 ASM非RAC雙機過程紀要OracleASM
- 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝ASMOracle
- OEL5.6+oracle11.2.0.3+ASM安裝OracleASM
- oracle10g ASM+RAC安裝OracleASM
- Oracle 19c rac安裝,只能啟動一個節點的ASMOracleASM
- windows下安裝react native要點WindowsReact Native
- oracle11Gr2安裝ASM,使用裸裝置OracleASM
- asm-windows下安裝asmASMWindows
- ASM學習筆記_ASM安裝ASM筆記
- 安裝ORACLE 11.2.0.3 ASM for AIX HA (Non-RAC)OracleASMAI
- ASM的安裝配置ASM
- asm命令及安裝ASM
- 安裝藍點Linux2.0 要小心(轉)Linux
- Window下安裝Oracle ASM單例項資料庫OracleASM單例資料庫
- 安裝oracle 11g 使用ASM儲存 詳細OracleASM
- aix5.3上安裝oracle10gR2 asmAIOracleASM
- ORACLE 10g FOR LINUX在FEDORA CORE 6下的安裝要點(修訂)Oracle 10gLinux
- ASM驅動安裝與ASM盤建立(一)ASM
- ASM驅動安裝與ASM盤建立(二)ASM
- AIX6.1安裝ORACLE 11g(單機使用ASM)AIOracleASM
- Redhat 5.4 + ASM + RAW+ Oracle 10g RAC 安裝文件RedhatASMOracle 10g
- 通過ORACLE VM virtualbox環境安裝oracle 11G RAC(ASM)OracleASM
- 安裝__DB、ASM注意事項ASM
- Linux上安裝oracle的注意點LinuxOracle
- InstallShield6.3安裝檔案製作要點 (轉)
- ORACLE11GR2 RAC解除安裝ASM例項步驟OracleASM
- RedHat 4 as 下安裝Oracle11gR2,Cluster(ASM)和DatabaseRedhatOracleASMDatabase
- oracle安裝:OUI安裝Oracle(圖形介面安裝)OracleUI
- Infor ERP LN 6 6.1.3 Oracle 10G R2 10.2.0.3 ASM RHEL5 (Tikanga)安裝簡要指南Oracle 10gASM
- 在centos5.4安裝oracle10g asm相關問題CentOSOracleASM
- RAC安裝【AIX 7 + 11.2.0.4 + ASM】AIASM
- ASM入網小助手解除安裝ASM
- RAW+ASM 的RAC 安裝文件ASM
- 在linux安裝asm總結LinuxASM