AIX5.3配置oracle10g ASM

环境

系统： AIX 5.3? 64位 # oslevel -r 5300-11   数据库：Oracle 10g

创建ASM磁盘组

# lsvg rootvg dbvg   # lsvg dbvg VOLUME GROUP:?????? dbvg???????????????????? VG IDENTIFIER:? 00c4ccf400004c00000001377889ef0f VG STATE:?????????? active?????????????????? PP SIZE:??????? 512 megabyte(s) VG PERMISSION:????? read/write?????????????? TOTAL PPs:????? 546 (279552 megabytes) MAX LVs:??????????? 256????????????????????? FREE PPs:?????? 307 (157184 megabytes) LVs:??????????????? 21?????????????????????? USED PPs:?????? 239 (122368 megabytes) OPEN LVs:?????????? 13?????????????????????? QUORUM:???????? 2 (Enabled) TOTAL PVs:????????? 2??????????????????????? VG DESCRIPTORS: 3 STALE PVs:?? ???????0??????????????????????? STALE PPs:????? 0 ACTIVE PVs:???????? 2??????????????????????? AUTO ON:??????? yes MAX PPs per VG:???? 32768??????????????????? MAX PVs:??????? 1024 LTG size (Dynamic): 1024 kilobyte(s)???????? AUTO SYNC:????? no HOT SPARE: ?????????no?????????????????????? BB POLICY:????? relocatable

在卷组dbvg上创建4个逻辑卷

#? mklv -y lv_asm1 dbvg ?8 lv_asm1 #? mklv -y lv_asm2 dbvg 8 lv_asm2 #? mklv -y lv_asm3 dbvg 8 lv_asm3 #? mklv -y lv_asm4 dbvg 8 lv_asm4   修改权限 chown oracle:oinstall /dev/rlv_asm1 chown oracle:oinstall /dev/rlv_asm2 chown oracle:oinstall /dev/rlv_asm3 chown oracle:oinstall /dev/rlv_asm4

查看ASM设备

# su – oracle $export ORACLE_SID=+ASM $ kfod status=TRUE asm_diskstring='/dev/rlv_asm*' disk=all -------------------------------------------------------------------------------- Disk????????? Size Header??? Path ================================================================================ 1:?????? 4096 Mb CANDIDATE /dev/rlv_asm1 2:?????? 4096 Mb CANDIDATE /dev/rlv_asm2 3:?????? 4096 Mb CANDIDATE /dev/rlv_asm3 4:?????? 4096 Mb CANDIDATE /dev/rlv_asm4 -------------------------------------------------------------------------------- ORACLE_SID ORACLE_HOME ================================================================================ +ASM /oracle/product/10.2.0/db1  

A?? 创建ASM磁盘组

创建磁盘组： create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4'; SQL> create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4'; create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4' * ERROR at line 1: ORA-15018: diskgroup cannot be created ORA-15031: disk specification '/dev/rlv_asm4' matches no disks ORA-15014: location '/dev/rlv_asm4' is not in the discovery set ORA-15031: disk specification '/dev/rlv_asm3' matches no disks ORA-15014: location '/dev/rlv_asm3' is not in the discovery set ORA-15031: disk specification '/dev/rlv_asm2' matches no disks ORA-15014: location '/dev/rlv_asm2' is not in the discovery set ORA-15031: disk specification '/dev/rlv_asm1' matches no disks ORA-15014: location '/dev/rlv_asm1' is not in the discovery set create diskgroup data external redundancy disk '/dev/rlv_asm*'; SQL> create diskgroup data external redundancy disk '/dev/rlv_asm*'; create diskgroup data external redundancy disk '/dev/rlv_asm*' * ERROR at line 1: ORA-15018: diskgroup cannot be created ORA-15031: disk specification '/dev/rlv_asm*' matches no disks ORA-15014: location '/dev/rlv_asm4' is not in the discovery set ORA-15014: location '/dev/rlv_asm3' is not in the discovery set ORA-15014: location '/dev/rlv_asm2' is not in the discovery set ORA-15014: location '/dev/rlv_asm1' is not in the discovery set SQL>?alter system set asm_diskstring='/dev/rlv_asm*';??????????? System altered. SQL>?create diskgroup data external redundancy disk '/dev/rlv_asm*'; Diskgroup created. 查看ASM状态： SQL> select name,state from v$asm_diskgroup; NAME -------------------------------------------------------------------------------- STATE --------------------------------- DATA MOUNTED SQL> col name for a30 SQL> col path for a30 SQL> select name,path from v$asm_disk; NAME?????????????????????????? PATH ------------------------------ ------------------------------ DATA_0000????????????????????? /dev/rlv_asm1 DATA_0001????????????????????? /dev/rlv_asm2 DATA_0002????????????????????? /dev/rlv_asm3 DATA_0003????????????????????? /dev/rlv_asm4 select path_kfdsk,state_kfdsk,asmname_kfdsk from x$kfdsk; PATH_KFDSK???? STATE_KFDSK ASMNAME_KFDSK -------------- ----------- ---------------- /dev/rlv_asm1??????????? 2 DATA_0000 /dev/rlv_asm2??????????? 2 DATA_0001 /dev/rlv_asm3??????????? 2 DATA_0002 /dev/rlv_asm4??????????? 2 DATA_0003 ASMCMD> lsdg State??? Type??? Rebal? Unbal? Sector? Block?????? AU? Total_MB? Free_MB? Req_mir_free_MB? Usable_file_MB? Offline_disks? Name MOUNTED? EXTERN? N????? N???????? 512?? 4096? 4194304????? 1024????? 928??????????????? 0???????????? 928????????????? 0? DATA/ 1* select INDX,inst_id,group_kffil,number_kffil,filsiz_kffil,ftype_kffil from x$kffil SQL> / INDX??? INST_ID GROUP_KFFIL NUMBER_KFFIL FILSIZ_KFFIL FTYPE_KFFIL ---------- ---------- ----------- ------------ ------------ ----------- 0????????? 1?????????? 1??????????? 1????? 4194304????????? 15 1????????? 1?????????? 1??????????? 2????? 1048576????????? 15 2????????? 1?????????? 1??????????? 3???? 46137344????????? 15 3????????? 1?????????? 1??????????? 4????? 1392640????????? 15 4????????? 1?????????? 1??????????? 5????? 1048576????????? 15 5????????? 1?????????? 1??????????? 6????? 1048576????????? 15 6 rows selected. 至此AIX使用LV创建ASM磁盘组操作完成    

B?? 创建ASM?? init+ASM.ora文件

Cd? /oracle/product/10.2.0/db1/dbs Vi? init+ASM.ora *.asm_diskstring='/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4' *.background_dump_dest='/oracle/admin/+ASM/bdump' *.core_dump_dest='/oracle/admin/+ASM/cdump' *.instance_type='asm' *.large_pool_size=24M *.remote_login_passwordfile='exclusive' *.user_dump_dest='/oracle/admin/+ASM/udump'

创建admin目录

  $ mkdir -p /oracle/admin/+ASM/bdump $ mkdir -p /oracle/admin/+ASM/cdump $ mkdir -p /oracle/admin/+ASM/udump  

启动css进程

root? # /oracle/product/10.2.0/db1/bin/localconfig add /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. Configuration for local CSS has been initialized   Adding to inittab Startup will be queued to init within 30 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. oratest CSS is active on all nodes. Oracle CSS service is installed and running under init(1M)  

切换oracle用户ASM STARTUP

Export ORACLE_SID=+ASM Sqlplus / as sysdba SQL>STARTUP; ORA-15110? no diskgroups mounted   create diskgroup data external redundancy disk '/dev/rlv_asm*'; SQL>?select?name,state?from?v$asm_diskgroup;      

DBCA建库