Category Archives: ASM

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

When I tried to create a  new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: … Continue reading

Posted in ASM, Oracle RAC | 1 Comment

HOW TO GENERATE ARCHIVE LOG FROM ASM TO LOCAL DISK

HOW TO GENERATE ARCHIVE LOG FROM ASM TO LOCAL DISK SQL> CREATE or replace DIRECTORY archdir AS ‘+ARCH/mscdxb/arch/’;SQL> Directory created.SQL> CREATE or replace DIRECTORY tempdir AS ‘/u01/starch/’;Directory created. spool archmove.sql set linesize 250 set pagesize 250 select ‘EXECUTE DBMS_FILE_TRANSFER.COPY_FILE(”ARCHDIR”,”’|| SUBSTR(NAME,INSTR(NAME,’/’,-1) … Continue reading

Posted in ASM | Leave a comment

ASM rpm installation and configuration

Automatic Storage Management (ASM) ASM was a new storage option introduced with Oracle Database 10gR1 that provides the services of a filesystem, logical volume manager, and software RAID in a platform-independent manner. ASM can stripe and mirror your disks, allow … Continue reading

Posted in ASM | Leave a comment

kfed script for ASM disk troubleshooting

Linux script for ASM disk troubleshooting called kfed [oracle@rac-node2 bin]cd /u01/app/oracle/product/10.2.0/db_1/bin [oracle@rac-node2 bin]$ vi kfed #! /bin/sh rm /tmp/kfed_DH.out /tmp/kfed_FS.out /tmp/kfed_BK.out for i in `ls /dev/oracleasm/disks/*` do echo $i >> /tmp/kfed_DH.out ./kfed read $i >> /tmp/kfed_DH.out echo $i >> /tmp/kfed_FS.out … Continue reading

Posted in ASM | Leave a comment

ASM Instance startup problem on node2

One of our production server one node node2 got rebooted. After OS came up , ASM instance was not able to startup Troubleshooting SQL> startup ASM instance started Total System Global Area 130023424 bytes Fixed Size 2071000 bytes Variable Size … Continue reading

Posted in ASM | Leave a comment

How to add disk to ASM

How to add disk to ASM (DATABASE) runing in production server We have database running on ASM, after two years we faced the problem of space deficiency. Now we planed to add disk to ASM diskgroup DATAGROUP. SQL> @asm NAME       … Continue reading

Posted in ASM | 1 Comment