Yesterday night I was able to sucessfully installed ASM on Linux by referring Video by Mr.Kamran Agayev Refer link (http://kamranagayev.com/2011/02/07/video-tutorial-installing-asm-on-linux-and-windows/).
Everything worked like charm after installation. Thank you Mr.Kamran Agavey for the wonderful video.
Today morning when I started the server to find below
===================================================================================
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [+ASM] ?
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 18 11:10:47 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASMGROUP"
===================================================================================
...hmm got a challange.
After Googling couple of site and trying different suggestions. I end up finding this blog by Mr.Arul ( http://arulselvaraj.blogspot.in/2007/02/asm-and-raw-devices-on-rhel-4.html ).
Yes, it the ownership of the raw devices which is overwritten from oracle to root after reboot.
Though the problem got resolved temporarily by changing the owner of the raw devices by entering the below commands.
chown oracle:oinstall /dev/raw/*
chmod 660 /dev/raw/*
Now I tried again
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [+ASM] ?
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 18 11:43:45 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMGROUP DISMOUNTED
SQL> alter diskgroup ASMGROUP MOUNT;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMGROUP MOUNTED
The problem pops up again when the server is rebooted. To fix the problem permanently
I took Mr.Arul 1st suggestion
and edited "/etc/rc.local" and added as below
chown oracle:oinstall /dev/raw/*
chmod 660 /dev/raw/*
to make the ownership persistent across the reboot.
It worked fine, thanks to Mr.Kamran and Mr.Arul for your contribution to the Oracle community.
Everything worked like charm after installation. Thank you Mr.Kamran Agavey for the wonderful video.
Today morning when I started the server to find below
===================================================================================
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [+ASM] ?
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 18 11:10:47 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASMGROUP"
===================================================================================
...hmm got a challange.
After Googling couple of site and trying different suggestions. I end up finding this blog by Mr.Arul ( http://arulselvaraj.blogspot.in/2007/02/asm-and-raw-devices-on-rhel-4.html ).
Yes, it the ownership of the raw devices which is overwritten from oracle to root after reboot.
Though the problem got resolved temporarily by changing the owner of the raw devices by entering the below commands.
chown oracle:oinstall /dev/raw/*
chmod 660 /dev/raw/*
Now I tried again
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [+ASM] ?
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 18 11:43:45 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMGROUP DISMOUNTED
SQL> alter diskgroup ASMGROUP MOUNT;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMGROUP MOUNTED
The problem pops up again when the server is rebooted. To fix the problem permanently
I took Mr.Arul 1st suggestion
and edited "/etc/rc.local" and added as below
chown oracle:oinstall /dev/raw/*
chmod 660 /dev/raw/*
to make the ownership persistent across the reboot.
It worked fine, thanks to Mr.Kamran and Mr.Arul for your contribution to the Oracle community.
No comments:
Post a Comment