Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASMCMD can not connect to Oracle ASM having ASM up and running. Also database can not access ASM

User_CHZ04Mar 12 2015 — edited Mar 16 2015

Hi,

 

I am presenting  problems with ASM , ASMCMD and databases that uses the ASM.  


The ASM seems to be working properly, but the database can not start and the asmcmd can not connect to the ASM.


This is a not cluster installation.


Thanks in advance.  Please check below.





---- Database trying to start up and connect to ASM ---

C:\Users\a-user38>echo %oracle_sid%

db

C:\Users\a-user38>echo %oracle_home%

D:\oracle\product\11.2.0\dbhome_1

C:\Users\a-user38>sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 12 12:15:15 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn sys/sys_password as sysdba

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/db/spfiledb.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/apex/spfiledb.ora

ORA-01017: invalid username/password; logon denied

   -- Using ASMCMD ---


C:\Users\a-981738>echo  %oracle_home%

D:\oracle\product\11.2.0.4\grid

C:\Users\a-981738>echo %oracle_sid%

+asm

C:\Users\a-981738>asmcmd

Connected to an idle instance.

ASMCMD> ls

ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run

ASMCMD> exit




  ---    connecting to the ASM instance ---

C:\Users\a-user38>echo %oracle_sid%

+ASM

C:\Users\a-981738>echo %oracle_home%

D:\oracle\product\11.2.0.4\grid

C:\Users\a-user38>sqlplus sys/Syspassword as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 12 12:01:29 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Automatic Storage Management option

SQL> select name, state from v$asm_diskgroup;

NAME                           STATE

------------------------------ -----------

DATA                           MOUNTED

FRA                            MOUNTED

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 13 2015
Added on Mar 12 2015
8 comments
8,203 views