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