安裝ORACLE 11.2.0.3 ASM for AIX HA (Non-RAC)

1.根據oracle官方建議修改OS相關引數

 

2.建立組和使用者
mkgroup -A id=501 oinstall
mkgroup -A id=502 dba
mkgroup -A id=503 oper
mkgroup -A id=504 asmadmin
mkgroup -A id=505 asmoper
mkgroup -A id=506 asmdba
mkuser pgrp=oinstall groups=asmadmin,asmdba,asmoper,dba grid
mkuser pgrp=oinstall groups=dba,oper,asmdba oracle
配置.profile
# GRID Environment
export ORACLE_BASE=/oravl01/app/oracle
export ORACLE_HOME=/oravl01/app/11.2.0/grid
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:/usr/java5/jre/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/precomp/lib:$LD_LIBRARY_PATH
export LIBPATH=$ORACLE_HOME/lib
export AIXTHREAD_SCOPE=S
export ORACLE_TERM=vt100
export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

# Oracle Environment
export ORACLE_UNQNAME=bidb
export ORACLE_BASE=/oravl01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/11.2.0/db_1
export GRID_HOME=/oravl01/app/11.2.0/grid
export ORACLE_SID=bidb
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/precomp/lib:$LD_LIBRARY_PATH
export LIBPATH=$ORACLE_HOME/lib
export AIXTHREAD_SCOPE=S
export ORACLE_TERM=vt100
export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

 

3.修改磁碟屬性
chown grid:asmadmin rhdiskn
chmod 660 rhdiskn

 

4.Grid Infrastructure安裝
安裝過程中建立ASM DG

 

5.ORACLE資料庫軟體安裝

 

6.DBCA建庫

 

至此，節點一的資料庫安裝完成（此時就是一臺單例項資料庫）

節點一上，grid使用者停止所有資源
jxhdb:grid:/home/grid> crsctl stop has

root使用者執行：
tar cfv ora.tar /oravl01
(grid、oracle軟體都安裝在/oravl01)

tar完成後，ftp到節點二

 

接下來的操作都在第二個節點上
重複上面的節點一上的1、2、3步

然後再將節點一的tar解開（root使用者執行）
cd /
tar xvf ora.tar
解開後，繼續root使用者執行：
# /oravl01/app/oraInventory/orainstRoot.sh
Changing permissions of /oravl01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /oravl01/app/oraInventory to oinstall.
The execution of the script. is complete.
# /oravl01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /oravl01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oravl01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
CRS-4664: Node jxhdb2 successfully pinned.
Adding Clusterware entries to inittab

jxhdb2     2012/02/08 13:41:21     /oravl01/app/11.2.0/grid/cdata/jxhdb2/backup_20120208_134121.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

 

如上配置還有另一個方法：
CSS & OHAS services as root user:
# $/crs/install/roothas.pl -deconfig -force
# $/crs/install/roothas.pl

# /oravl01/app/oracle/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oravl01/app/oracle/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

 

將cssd設定為自動啟動：
jxhdb2:grid:/oravl01/app/oracle>crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

 

由於ora.diskmon在11.2.0.3狀態為offline是正常的，可不用管它
ID 1346881.1
As Grid Infrastructure daemon diskmon.bin is used for Exadata fencing, started from 11.2.0.3, resource ora.diskmon will be offline in non-Exadata environment. This is expected behaviour change.

 

用grid在圖形介面下reconfig監聽

jxhdb2:grid:/oravl01/app/oracle>srvctl add LISTENER
jxhdb2:grid:/oravl01/app/oracle>srvctl add asm
jxhdb2:grid:/oravl01/app/oracle>crsctl modify resource "ora.asm" -attr "AUTO_START=1"
jxhdb2:grid:/oravl01/app/oracle>crsctl start resource ora.cssd    （不手動啟動一次cssd，後面通過crsctl start has是不能啟動的，我做過幾次都這樣，請大家注意）
CRS-2672: Attempting to start 'ora.cssd' on 'jxhdb2'
CRS-2672: Attempting to start 'ora.diskmon' on 'jxhdb2'
CRS-2676: Start of 'ora.diskmon' on 'jxhdb2' succeeded
CRS-2676: Start of 'ora.cssd' on 'jxhdb2' succeeded

jxhdb2:grid:/>crsctl stop has
jxhdb2:grid:/>crsctl start has

jxhdb2:grid:/>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host       
----------------------------------------------------------------------
ora.DGDATA1.dg ora....up.type 0/5    0/     ONLINE    ONLINE    jxhdb2
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    jxhdb2     
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    jxhdb2     
ora.cssd       ora.cssd.type  0/5    0/5    ONLINE    ONLINE    jxhdb2     
ora.diskmon    ora....on.type 0/10   0/5    OFFLINE   OFFLINE              
ora.evmd       ora.evm.type   0/10   0/5    ONLINE    ONLINE    jxhdb2     
ora.ons        ora.ons.type   0/3    0/     OFFLINE   OFFLINE 

 

如果DG offline應手動mount

jxhdb2:grid:/oravl01/app/11.2.0/>sqlplus / as sysasm
SQL> alter diskgroup DGDATA1 mount;

 

最後把資料庫加入：
jxhdb2:oracle:/>srvctl add database -d bidb -o /oravl01/app/oracle/11.2.0/db_1

jxhdb2:grid:/>crsctl stop has
jxhdb2:grid:/>crsctl start has

jxhdb2:oracle:/home/oracle>crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host       
----------------------------------------------------------------------
ora.DGDATA1.dg ora....up.type 0/5    0/     ONLINE    ONLINE    jxhdb2         
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    jxhdb2     
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    jxhdb2     
ora.bidb.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    jxhdb2
ora.cssd       ora.cssd.type  0/5    0/5    ONLINE    ONLINE    jxhdb2     
ora.diskmon    ora....on.type 0/10   0/5    OFFLINE   OFFLINE              
ora.evmd       ora.evm.type   0/10   0/5    ONLINE    ONLINE    jxhdb2     
ora.ons        ora.ons.type   0/3    0/     OFFLINE   OFFLINE            

ASM HA配置完成。