Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ASMCMD can not connect to Oracle ASM having ASM up and running. Also database can not access ASM
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%
\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%
\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%
\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
Answers
-
Is this a new installation ? or DB was already there and it is not coming up now only?
Can you create a pfile on disk instead of ASM and try starting the DB? Check alert log of ASM and DB for any additonal information
-
It is not a new installation. The DB was already there and it is not coming up now.
How can i create a pfile on disk instead of ASM ? if the init is not on disk , it is on the ASM.
--- DATABASE ALER LOG ---
Errors in file
\ORACLE\PRODUCT\11.2.0.4\diag\rdbms\apex\apex\trace\apex_j000_20132.trc:ORA-12012: error on auto execute of job "SYS"."DOC_ALERTS"
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-06512: at "SYS.MONITOR_RENDER", line 4
Tue Mar 10 10:35:16 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Mar 10 10:36:52 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Mar 10 10:37:02 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Mar 10 10:38:20 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Mar 10 10:40:04 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Mar 10 10:40:37 2015
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file
\ORACLE\PRODUCT\11.2.0.4\diag\rdbms\apex\apex\trace\apex_w000_22084.trc:ORA-15055: unable to connect to ASM instance
ORA-01017: invalid username/password; logon denied
ORA-15055: unable to connect to ASM instance
ORA-01017: invalid username/password; logon denied
NOTE: deferred map free for map id 6214
Tue Mar 10 10:41:03 2015
Errors in file
\ORACLE\PRODUCT\11.2.0.4\diag\rdbms\apex\apex\trace\apex_j000_21412.trc:ORA-12012: error on auto execute of job "SYS"."DOC_ALERTS"
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-06512: at "SYS.MONITOR_RENDER", line 4
Tue Mar 10 10:42:16 2015
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
AUD: OS Error = 1717 encountered while writing audit record
ASM ALERT LOG
***********************************************************************
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 11-MAR-2015 16:10:01
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Thu Mar 12 09:37:57 2015
***********************************************************************
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 12-MAR-2015 09:37:57
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
-
It seems the SID is not same when you used ASMCMD, check by setting SID with same case. If ASMCMD works see if the spfile exist from ASMCMD prompt.
you can create pfile temporarily from checking DB alertlog when DB was last started, it will have information about mandatory parameters .
This may help to see if you can bring the DB up.
-- Using ASMCMD ---
C:\Users\a-981738>echo %oracle_sid%
+asm
--- connecting to the ASM instance ---
C:\Users\a-user38>echo %oracle_sid%
+ASM
-
I made the changes having the Oracle_SID with value +ASM, but still can not get ASMCMD work.
C:\Users\a-user38>echo %oracle_sid%
+asm
C:\Users\a-user38>set oracle_sid=+ASM
C:\Users\a-user38>echo %oracle_home%
\oracle\product\11.2.0.4\gridC:\Users\a-user38>echo %oracle_sid%
+ASM
C:\Users\a-user38>asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
ASMCMD>
-
cd %ORACLE_HOME% works?
post here:
crsctl check has
crsctl status res -t
srvctl status 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> cd %ORACLE_HOME%
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
ASMCMD> exit
C:\Users\a-981738>cd %ORACLE_HOME%
C:\Users\a-981738>d:
\oracle\product\11.2.0.4\grid>\oracle\product\11.2.0.4\grid>crsctl check hasCRS-4638: Oracle High Availability Services is online
\oracle\product\11.2.0.4\grid>crsctl status res -t-------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
-------------------------------------------------------------------------------
Local Resources
-------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE schora02
ora.FRA.dg
ONLINE ONLINE schora02
ora.LISTENER.lsnr
ONLINE ONLINE schora02
ora.asm
ONLINE ONLINE schora02 Started
ora.ons
OFFLINE OFFLINE schora02
-------------------------------------------------------------------------------
Cluster Resources
-------------------------------------------------------------------------------
ora.apex.db
1 ONLINE OFFLINE
ora.carsprd.db
1 ONLINE OFFLINE
ora.cssd
1 ONLINE ONLINE schora02
ora.evmd
1 ONLINE ONLINE schora02
\oracle\product\11.2.0.4\grid>\oracle\product\11.2.0.4\grid>srvctl status asmASM is running on schora02
\oracle\product\11.2.0.4\grid> -
Check if you current OS User is a member of
ORA_DBAOperating System Groups (Windows). If not add current OS User as member of ORA_DBA group logoff/logon and try again. -
Yes the user is a memeberof the ORA_DBA group.
