ASM problem
647600Apr 28 2009 — edited Apr 28 2009Dear DBAs
The issue is that the database can't access the asm and below is the error while starting it:
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ORADATA/imal/spfileimal.ora'
ORA-17503: ksfdopn:2 Failed to open file +ORADATA/imal/spfileimal.ora
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
there is no problem when i try to connect to the asm instance and also while querying the v$asm_diskgroup i can see my diskgroups.
Further i had to recreate the password file to be able to use the "asmcmd" command and now it works fine and i can see my files.
could you please help?