############################################################################### # # # Simple Steps to Create a 10g ASM environment with Raw Devices on Suse Linux # # by thomas@guilleminot.org # # # ############################################################################### Disclaimer : This is only an example ! You use it at your own risks... I. ASSUMPTION. -------------- SuSE Linux SLES 8 Oracle Server Version 10.1.0.2.0 Storage : ASM Disks groups on Raw Devices Owner : oracle1010 Group : dba II. ACTIONS. ------------ 1. Create disk partitions (without format/file system defined) Eg : 4 partitions of 250Mb each : /dev/sda6 to /dev/sda9 2. Bind Raw Devices a) Automatic bind on machine startup Fill de /etc/raw file : raw6:sda6 raw7:sda7 raw8:sda8 raw9:sda9 Enable Raw service : chkconfig raw on Check with : chkconfig | grep raw Or /etc/init.d/raw start to enable it now if no reboot desired for the moment b) Manual bind raw /dev/raw/raw6 /dev/sda6 raw /dev/raw/raw7 /dev/sda7 raw /dev/raw/raw8 /dev/sda8 raw /dev/raw/raw9 /dev/sda9 Check with : raw -qa 3. Set ownership and permissions to Oracle kernel owner chown oracle1010:dba /dev/raw/raw6 chown oracle1010:dba /dev/raw/raw7 chown oracle1010:dba /dev/raw/raw8 chown oracle1010:dba /dev/raw/raw9 chmod 660 /dev/raw/raw6 chmod 660 /dev/raw/raw7 chmod 660 /dev/raw/raw8 chmod 660 /dev/raw/raw9 4. Creation via DBCA of the database V1010ASM If no ASM instance exists on the machine it will be also created (instance +ASM) At the end you should have the instances : +ASM : ASM instance V1010ASM : Database instance 5. Connection to +ASM instance export ORACLE_SID=+ASM sqlplus "/ as sysdba" select * from v$asm_disk ; select * from v$asm_diskgroup; select * from v$asm_file ; select * from v$asm_alias ; select * from v$asm_template ; select * from v$asm_operation; select * from v$asm_client ; 6. Connection to V1010ASM instance export ORACLE_SID=V1010ASM sqlplus "/ as sysdba" select * from v$asm_disk ; select * from v$asm_diskgroup; select * from v$asm_file ; select * from v$asm_alias ; select * from v$asm_template ; select * from v$asm_operation; select * from v$asm_client ;