5 Replies Latest reply: Aug 8, 2013 6:50 AM by Simo Kemppinen RSS

    Start up problem with Oracle RAC 11g

    AndreGil

      Hi all,

       

       

      After a power failure I can not start a oracle database it give me the ORA-01031: insufficient privileges error

       

      [oracle@hostname ~]$ sqlplus /nolog

       

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 23 19:06:41 2013

       

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.

       

      SQL> show sga

       

      Total System Global Area  283930624 bytes
      Fixed Size            2212656 bytes
      Variable Size          256552144 bytes
      ASM Cache           25165824 bytes
      SQL> disconnect
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Real Application Clusters and Automatic Storage Management options
      SQL> connect as sysdba
      Enter user-name: system
      Enter password:
      Connected.
      SQL> startup
      ORA-01031: insufficient privileges
      SQL> quit
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Real Application Clusters and Automatic Storage Management options
      [oracle@hostname ~]$ lsb_release -a
      LSB Version:    :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch
      Distributor ID:    EnterpriseEnterpriseServer
      Description:    Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)
      Release:    5.7
      Codename:    Carthage
      [oracle@hostname ~]$

       

      [oracle@hostname ~]$ crs_stat -t
      Name           Type           Target    State     Host       
      ------------------------------------------------------------
      ora.DATA.dg    ora....up.type ONLINE    ONLINE    sil-rac1   
      ora....ER.lsnr ora....er.type ONLINE    ONLINE    sil-rac1   
      ora....N1.lsnr ora....er.type ONLINE    ONLINE    sil-rac2   
      ora....N2.lsnr ora....er.type ONLINE    ONLINE    sil-rac1   
      ora....N3.lsnr ora....er.type ONLINE    ONLINE    sil-rac1   
      ora.asm        ora.asm.type   ONLINE    ONLINE    sil-rac1   
      ora.eons       ora.eons.type  ONLINE    ONLINE    sil-rac1   
      ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
      ora....network ora....rk.type ONLINE    ONLINE    sil-rac1   
      ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    sil-rac2   
      ora.ons        ora.ons.type   ONLINE    ONLINE    sil-rac1   
      ora.orcl.db    ora....se.type ONLINE    ONLINE    sil-rac1   
      ora.scan1.vip  ora....ip.type ONLINE    ONLINE    sil-rac2   
      ora.scan2.vip  ora....ip.type ONLINE    ONLINE    sil-rac1   
      ora.scan3.vip  ora....ip.type ONLINE    ONLINE    sil-rac1   
      ora....SM1.asm application    ONLINE    ONLINE    sil-rac1   
      ora....C1.lsnr application    ONLINE    ONLINE    sil-rac1   
      ora....ac1.gsd application    OFFLINE   OFFLINE              
      ora....ac1.ons application    ONLINE    ONLINE    sil-rac1   
      ora....ac1.vip ora....t1.type ONLINE    ONLINE    sil-rac1   
      ora....SM2.asm application    ONLINE    ONLINE    sil-rac2   
      ora....C2.lsnr application    ONLINE    ONLINE    sil-rac2   
      ora....ac2.gsd application    OFFLINE   OFFLINE              
      ora....ac2.ons application    ONLINE    ONLINE    sil-rac2   
      ora....ac2.vip ora....t1.type ONLINE    ONLINE    sil-rac2   
      [oracle@hostname ~]$

       

      [oracle@hostname ~]$ crsctl check crs
      CRS-4638: Oracle High Availability Services is online
      CRS-4537: Cluster Ready Services is online
      CRS-4529: Cluster Synchronization Services is online
      CRS-4533: Event Manager is online
      [oracle@hostname ~]$

       

      Does anyone know what can be the problem?

       

      Thanks,

       

      Andre Gil

        • 1. Re: Start up problem with Oracle RAC 11g
          sb92075

          >Does anyone know what can be the problem?

           

          Problem Exists Between Keyboard And Chair

           

           

          You must be logged onto the OS as the same OS user  who owns the Oracle software

           

          post results from following OS commands

           

          id

          env | sort

          • 2. Re: Start up problem with Oracle RAC 11g
            AndreGil

            Thanks for your answer

             

            The OS user I'm log is ORACLE that own the filesystem, Before you ask ORACLE is part of OINSTALL and DBA group

             

            Any other suggestion

             

             

            [oracle@sil-rac1 ~]$ id
            uid=1100(oracle) gid=1200(dba) groups=4(adm),100(users),1000(oinstall),1200(dba)
            [oracle@sil-rac1 ~]$ env | sort
            BASE_PATH=/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
            _=/bin/env
            CLASSPATH=/u01/app/11.2.0/grid/JRE:/u01/app/11.2.0/grid/jlib:/u01/app/11.2.0/grid/rdbms/jlib
            DB_HOME=/u01/app/oracle/product/11.2.0/db_1
            G_BROKEN_FILENAMES=1
            GRID_HOME=/u01/app/11.2.0/grid
            HISTSIZE=1000
            HOME=/home/oracle
            HOSTNAME=sil-rac1
            INPUTRC=/etc/inputrc
            LANG=en_US.UTF-8
            LD_LIBRARY_PATH=/u01/app/11.2.0/grid/lib:/lib:/usr/lib
            LESSOPEN=|/usr/bin/lesspipe.sh %s
            LOGNAME=oracle
            LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
            MAIL=/var/spool/mail/oracle
            ORACLE_BASE=/u01/app/oracle
            ORACLE_HOME=/u01/app/11.2.0/grid
            ORACLE_HOSTNAME=sil-rac1.silanis.com
            ORACLE_SID=+ASM1
            ORACLE_TERM=xterm
            ORACLE_UNQNAME=RAC
            PATH=/u01/app/11.2.0/grid/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
            PWD=/home/oracle
            SHELL=/bin/bash
            SHLVL=1
            SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
            TERM=xterm
            TMPDIR=/tmp
            TMP=/tmp
            USER=oracle
            [oracle@sil-rac1 ~]$

            • 3. Re: Start up problem with Oracle RAC 11g
              Billy~Verreynne

              ORACLE_HOME is set to /u01/app/11.2.0/grid. That is Grid Infrastructure's (GI) home and not the RDBMS RAC home? 

               

              Likewise ORACLE_SID is set to +ASM1 - and not the RAC instance's SID.

               

              How was the s/w installed? Did you follow Oracle's recommendation of separating GI and RAC s/w via o/s users grid and oracle? Or did you use the oracle o/s user for both?

               

              Keep in mind that sqlplus uses ORACLE_HOME and ORACLE_SID to identify the shmem segment (SGA) to create or attach to. Either wrong (even a trailing slash in ORACLE_HOME) results in sqlplus being unable to create a server process to attach to an existing SGA - or creating a SGA that no one else can connect to without the exact same settings.

              • 4. Re: Start up problem with Oracle RAC 11g
                AndreGil

                Oracle was installed as recommend. Just one more information it was working since January, after the power failure I could not start it anymore.

                 

                My think is some thing wrong with the file permission or a lock file was left on the OS.

                • 5. Re: Start up problem with Oracle RAC 11g
                  Simo Kemppinen

                  Check file permissions from $ORACLE_HOME/bin    that you are using.

                  Typically problem is with this file:

                  ls -la oracle

                  -rwsr-s–x 1 oracle oinstall 13735754 May 10 11:14 oracle

                   

                  If it is wrong you can fix it with:

                  chmod 6751 oracle

                   

                  But it is wise to compare privileges of all bins with problematic server and from backup or from other working environment.