Hi,
I am using Oracle RAC with 2 nodes,
Version 10.2.0.1 Standard Edition.
Red Hat 5.
kernel 2.6.18-308.el5
I just joined on this company.
I was doing my daily checks, and checked the v$ASM_DISKGROUP, i saw 2 of 4 Datagroups 'Disconnected', then i joined at ascmd and checked that the diskgroups were there, and had files inside.
So i decided to mount up the 2 datagroups missing:
Using asm instance, i used to sqlplus and: alter diskgroup data mount;
So it hanged, took too long, and i tried to cancel it by CTRL+C. It won't cancel. Then i quit sqlplus by closing the terminal. Then i tried to check if the the diskgroup was mounted with Select * from v$asm_diskgroup, and it hangs.
I tried to use asmcmd as well, and no sucess, hangs too.
So i checked the processes:
[oracle@xxxx [dbprod1] /]$ ps -ef | grep sqlplus
oracle 6672 27537 0 15:14 pts/2 00:00:00 grep sqlplus
root 32562 32561 0 Sep24 ? 00:00:00 sqlplus -S as sysdba @/tmp/32016_oenv2.sql
daemon 32565 32562 0 Sep24 ? 00:00:00 [sqlplus] <defunct>
I just found these 3 processes, no one looks like the one that i did to mount the DG DATA.
Why it is hanging ? What could i do to stop hanging?
Any help would be appreciated.
Thanks in advance.