This discussion is archived
3 Replies Latest reply: Nov 28, 2012 3:08 AM by moreajays RSS

11g ASM issue

824160 Newbie
Currently Being Moderated
DB: 11g R2 and 11g ASM OEL 5, when i am trying to bring up database, its failing with below error..

Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/grid/bin/oracle)


(ARGV0=oracle+ASM_asmb_project1)(ENVS='ORACLE_HOME=/u01/app/oracle/product/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=unic.com)(USER=oracle))))

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 07-APR-2011 14:31:17
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

TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_project1)(ENVS='ORACLE_HOME=/u01/app/oracle/product/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
  • 1. Re: 11g ASM issue
    824160 Newbie
    Currently Being Moderated
    got it.
  • 2. Re: 11g ASM issue
    user13683823 Newbie
    Currently Being Moderated
    I am getting same error... If you found solution, please let me know. :(

    Regards,
    Sam
  • 3. Re: 11g ASM issue
    moreajays Pro
    Currently Being Moderated
    Hi,

    The issue is caused by incorrect permission of $GRID_HOME/bin/oracle and $ORACLE_HOME/bin/oracle, which lead to connection failure to ASM instance:

    ls -al $GRID_HOME/bin/oracle
    -rwxr-x--x 1 grid oinstall 200678464 Feb 28 14:54 oracle

    ls -al $ORACLE_HOME/bin/oracle
    -rwxr-x--x 1 oracle asmadmin 228886191 Feb 28 15:41 oracle

    Change as belo

    cd $GRID_HOME/bin
    chmod 6751 oracle

    cd $ORACLE_HOME/bin
    chmod 6751 oracle


    After the change, permission should show:

    ls -l $GRID_HOME/bin/oracle
    -rwsr-s--x 1 grid oinstall 203974257 May 11 09:30 oracle

    ls -l $ORACLE_HOME/bin/oracle
    -rwsr-s--x 1 oracle oinstall 232399431 May 14 13:47 oracle


    Restart database


    Thanks,
    Ajay More

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points