December 06, 2024

Failed to start ASMB (connection failed) state=0x1

Issue with Oracle ASM


For a standalone database which is setup with ASM, if Database startup failed mentioning " cannot access control file see alert log for more details." Check for the below mentioned entries in alert log and trace file around that time.

Error codes in Oracle Alert log and trace file: 

Fatal NI connect error 12547, connecting to:

Tracing not turned on.

  Tns error struct:

    ns main err code: 12547

TNS-12547: TNS:lost contact

    ns secondary err code: 12560

    nt main err code: 517

WARNING: failed to start ASMB (connection failed) state=0x1 sid='+<asm_sid>'

DDE encountered the following error:

ORA-49204: Recursive DDE invocation at Phase I

ORA-00202: control file: '+<controlfile>'

ORA-17503: ksfdopn:2 Failed to open file +<controlfile>

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-12547: TNS:lost contact

ORA-12547: TNS:lost contact

 

One of the probable cause is the permission issue on oracle binary.

Login with grid user and do the following:

    cd $GRID_HOME/bin
    ls -ll oracle 
       -rwxrwx---   <----- oracle

 

change the permission :
    chmod 6751 oracle
    ls -ll oracle

        -rwsr-s--x   < -- oracle

    


Now try to start the database and it should be able to start the ASMB connection.


Best Wishes!!


No comments:

Post a Comment

If you have any queries/ any suggestion please do comment and let me know.

Recent Post

Check progress on expdp and impdp

 Check progress on expdp and impdp: In few cases we need to monitor the progress of an export or import job in oracle. below are the steps c...