Hi,
Below are the steps i m following for ASM creation and below error i m getting while creating ASM disk group. I dnt know why i m unable to create diskgroup when i have raw devices configured
mkdir -p $ORACLE_BASE/admin/+ASM/bdump
mkdir -p $ORACLE_BASE/admin/+ASM/cdump
mkdir -p $ORACLE_BASE/admin/+ASM/hdump
mkdir -p $ORACLE_BASE/admin/+ASM/pfile
mkdir -p $ORACLE_BASE/admin/+ASM/udump
Run cssd service for ASM as a root user:
./u01/app/oracle/product/10.2.0/db_1/bin/localconfig add
ASM Configuration
Create a Pfile named as init+ASM.ora in $ORACLE_BASE/admin/+ASM/pfile folder
Mark the following entries
*.INSTANCE_TYPE = ASM
*.DB_UNIQUE_NAME = +ASM
*.ASM_POWER_LIMIT = 1
*.ASM_DISKSTRING = '/dev/raw/raw*'
*.ASM_DISKGROUPS = ''
*.background_dump_dest=/u01/app/oracle/admin/+ASM/bdump
*.core_dump_dest=/u01/app/oracle/admin/+ASM/cdump
*.user_dump_dest=/u01/app/oracle/admin/+ASM/udump
*.compatible=10.2.0.1.0
*.large_pool_size=12M
*.remote_login_passwordfile=exclusive
ln -s $ORACLE_BASE/admin/+ASM/pfile/init+ASM.ora $ORACLE_HOME/dbs/init+ASM.ora
ORACLE_SID=+ASM; export ORACLE_SID
sqlplus / as sysdba
SQL>startup nomount pfile='$ORACLE_BASE/admin/+ASM/pfile/init+ASM.ora';
SQL>create spfile from pfile;
SQL>shut immediate;
sqlplus / as sysdba
SQL>startup nomount
SQL>CREATE DISKGROUP DGROUPA NORMAL REDUNDANCY
FAILGROUP failure_group_1 DISK
'/dev/raw/raw1' name disk1,
'/dev/raw/raw2' name disk2
failgroup failure_group_2 disk
'/dev/raw/raw3' name diskb1,
'/dev/raw/raw4' name diskb2
failgroup failure_group_3 disk
'/dev/raw/raw5' name diskc1,
'/dev/raw/raw6' name diskc2;
CREATE DISKGROUP DGROUPA NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/raw/raw6' matches no disks
ORA-15025: could not open disk '/dev/raw/raw6'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 42
Additional information: 141148497
Additional information: 213724448
ORA-15031: disk specification '/dev/raw/raw5' matches no disks
ORA-15025: could not open disk '/dev/raw/raw5'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 42
Additional information: 141148497
Additional information: 213724448
ORA-15031: disk specification '/dev/raw/raw4' matches no disks
ORA-15025: could not open disk '/dev/raw/raw4'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 42
Additional information: 141148497
Additional information: 213724448
ORA-15031: disk specification '/dev/raw/raw3' matches no disks
ORA-15025: could not open disk '/dev/raw/raw3'
ORA-27041: unable to open file
Linux Error:
Raw devices details
[root@asmprod bin]# raw -qa
/dev/raw/raw1: bound to major 8, minor 9
/dev/raw/raw2: bound to major 8, minor 8
/dev/raw/raw3: bound to major 8, minor 7
/dev/raw/raw4: bound to major 8, minor 6
/dev/raw/raw5: bound to major 8, minor 5
/dev/raw/raw6: bound to major 8, minor 3
[root@asmprod bin]#
[root@asmprod bin]#
[root@asmprod bin]# ls -ltr /dev/raw/raw*
crw------- 1 oracle oinstall 162, 1 Mar 6 16:04 /dev/raw/raw1
crw------- 1 oracle oinstall 162, 2 Mar 6 16:04 /dev/raw/raw2
crw------- 1 oracle oinstall 162, 3 Mar 6 16:04 /dev/raw/raw3
crw------- 1 oracle oinstall 162, 4 Mar 6 16:04 /dev/raw/raw4
crw------- 1 oracle oinstall 162, 5 Mar 6 16:04 /dev/raw/raw5
crw------- 1 oracle oinstall 162, 6 Mar 6 16:04 /dev/raw/raw6
[root@asmprod bin]# cat /etc/sysconfig/rawdevices
# raw device bindings
# format: <rawdev> <major> <minor>
# <rawdev> <blockdev>
# example: /dev/raw/raw1 /dev/sda1
# /dev/raw/raw2 8 5
/dev/raw/raw1 /dev/sda9
/dev/raw/raw2 /dev/sda8
/dev/raw/raw3 /dev/sda7
/dev/raw/raw4 /dev/sda6
/dev/raw/raw5 /dev/sda5
/dev/raw/raw6 /dev/sda3
[root@asmprod bin]# cat /etc/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.
touch /var/lock/subsys/local
chown oracle:oinstall /dev/raw/raw1
chown oracle:oinstall /dev/raw/raw2
chown oracle:oinstall /dev/raw/raw3
chown oracle:oinstall /dev/raw/raw4
chown oracle:oinstall /dev/raw/raw5
chown oracle:oinstall /dev/raw/raw6
chmod 600 /dev/raw/raw1
chmod 600 /dev/raw/raw2
chmod 600 /dev/raw/raw3
chmod 600 /dev/raw/raw4
chmod 600 /dev/raw/raw5
chmod 600 /dev/raw/raw6