Forum Stats

  • 3,839,156 Users
  • 2,262,456 Discussions
  • 7,900,869 Comments

Discussions

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

User_CHZ04
User_CHZ04 Member Posts: 6 Red Ribbon

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

Answers

  • rchem
    rchem Member Posts: 972 Bronze Trophy
    edited Mar 12, 2015 2:12PM

    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

  • User_CHZ04
    User_CHZ04 Member Posts: 6 Red Ribbon
    edited Mar 12, 2015 3:09PM

    @rchem 

       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 D:\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 D:\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 D:\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

  • rchem
    rchem Member Posts: 972 Bronze Trophy
    edited Mar 12, 2015 6:24PM

    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

  • User_CHZ04
    User_CHZ04 Member Posts: 6 Red Ribbon
    edited Mar 13, 2015 9:26AM

    @rchem

     

      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%

    D:\oracle\product\11.2.0.4\grid

    C:\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>

  • Levi Pereira
    Levi Pereira Member Posts: 2,676 Gold Trophy
    edited Mar 13, 2015 12:49PM

    cd %ORACLE_HOME%  works?


    post here:


    crsctl check has

    crsctl status res -t

    srvctl status asm

  • User_CHZ04
    User_CHZ04 Member Posts: 6 Red Ribbon
    edited Mar 13, 2015 4:49PM

    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:

    D:\oracle\product\11.2.0.4\grid>

    D:\oracle\product\11.2.0.4\grid>crsctl check has

    CRS-4638: Oracle High Availability Services is online

    D:\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

    D:\oracle\product\11.2.0.4\grid>

    D:\oracle\product\11.2.0.4\grid>srvctl status asm

    ASM is running on schora02

    D:\oracle\product\11.2.0.4\grid>

  • Levi Pereira
    Levi Pereira Member Posts: 2,676 Gold Trophy
    edited Mar 13, 2015 10:08PM

    Check if you current OS User is a member of ORA_DBA Operating System Groups (Windows). If not add current OS User as member of ORA_DBA group logoff/logon and try again.

  • User_CHZ04
    User_CHZ04 Member Posts: 6 Red Ribbon
    edited Mar 16, 2015 9:57AM

    Yes the user is a memeberof the ORA_DBA group.

This discussion has been closed.