I hit this error during try to start my asm instance
I am working standalone Oracle 11.2.0.1 database wiht ASM option on AIX 6.1. I hit below error after i reboot my server.
$export ORACLE_SID=+ASM $sqlplus "/as sysasm" SQL> startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service
I checked services by using:
$crs_stat –t Name Type Target State Host ------------------------------------------------------------ ora.asm ora.asm.type OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE OFFLINE ora.diskmon ora....on.type ONLINE OFFLINE
Than i am going to start ora.cssd services
crsctl start resource ora.cssd
Than i run below command:
$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.asm ora.asm.type OFFLINE OFFLINE oracle ora.cssd ora.cssd.type ONLINE ONLINE oracle ora.diskmon ora....on.type ONLINE ONLINE oracle $ sqlplus "/as sysasm" SQL> startup ORA-00099: warning: no parameter file specified for ASM instance ASM instance started Total System Global Area 283930624 bytes Fixed Size 2206088 bytes Variable Size 256558712 bytes ASM Cache 25165824 bytes ORA-15110: no diskgroups mounted SQL> select group_number, name, total_mb, free_mb, state from v$asm_diskgroup; GROUP_NUMBER NAME TOTAL_MB FREE_MB STATE ------------ -------------------------------- ---------- --------- ---- 0 ORADATA 0 0 DISMOUNTED SQL> alter diskgroup ORAODM mount; Diskgroup altered.
Issue solved
Hope it helps
7 yorum
Comments feed for this article
Mayıs 24, 2011 7:05 pm
sandeep
That was great !!
I was wondering where I lost the diskgroups.. this saved me
Mayıs 27, 2011 8:28 pm
Gunes Erol
Hi Sandeep;
Nice to hear it 😉
Mart 2, 2012 2:26 am
AB
same thing happened to me – followed steps above – solved problem
Thanks,
AB
Mart 2, 2012 9:50 am
Gunes Erol
Hi AB;
Nice to hear your issue is also solved 😉
Regards
Gunes
Haziran 23, 2012 9:50 pm
Daniel Chris
Hey
Thank you that really helped.
Just wondering for every restart we need to run it.
Can we just put this command in a script after setting the oracle_sid to ASM ?
Just ignore if i don’t make sense ! am new buddy.
Haziran 25, 2012 11:54 am
Gunes Erol
You may use script or you can make this steps manually, it depends you my friend 😉
Regards
Gunes
Ocak 22, 2013 8:47 am
sreedhar
Thanks forHelios..it greatly helped me in resolving my issue..
Regards,
Sreedhar.