3 Replies Latest reply: Nov 28, 2012 5:08 AM by moreajays RSS

    11g ASM issue

      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:


      TNS for Linux: Version - Production
      Oracle Bequeath NT Protocol Adapter for Linux: Version - 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
          got it.
          • 2. Re: 11g ASM issue
            I am getting same error... If you found solution, please let me know. :(

            • 3. Re: 11g ASM issue

              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

              Ajay More