3 Replies Latest reply: Mar 5, 2012 4:06 AM by SPA2 RSS

    ORA-01031: insufficient privileges error

    919781
      Hi.
      My DB system consisted of RAC.

      Yesterday, i modified a sqlnet.ora, configuring a sqlnet.authentication_services=(none)

      I checked it using sqlplus.
      DB1 was OK but DB2 was failed

      This is DB2 message.
      /oracle/app/11.2.0/network/admin]sqlplus /nolog
      SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 22 22:37:42 2012
      Copyright (c) 1982, 2010, Oracle. All rights reserved.
      SQL> connect sys/oracle as sysdba
      ERROR:
      ORA-01031: insufficient privileges

      I didn't know why sys user didn't have sysdba privilege.

      Then I downloaded DB1's sqlnet.ora and uploaded it at DB2.
      But DB2 was failed.

      Please answer a questions....

      Edited by: user1080096 on 2012. 2. 24 오전 2:44
        • 1. Re: ORA-01031: insufficient privileges error
          Levi Pereira
          user1080096 wrote:
          Hi.
          My DB system consisted of RAC.

          Yesterday, i modified a sqlnet.ora, configuring a sqlnet.authentication_services=(none)

          I checked it using sqlplus.
          DB1 was OK but DB2 was failed

          This is DB2 message.
          /oracle/app/11.2.0/network/admin]sqlplus /nolog
          SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 22 22:37:42 2012
          Copyright (c) 1982, 2010, Oracle. All rights reserved.
          SQL> connect sys/oracle as sysdba
          ERROR:
          ORA-01031: insufficient privileges

          I didn't know why sys user didn't have sysdba privilege.

          Then I downloaded DB1's sqlnet.ora and uploaded it at DB2.
          But DB2 was failed.

          Please answer a questions....

          Edited by: user1080096 on 2012. 2. 24 오전 2:44
          Hi,

          Check your variables env ORACLE_HOME and ORACLE_SID or try connect using easy connect method.
          sqlplus sys/oracle@hostanme:<port>/<service_name> as sysdba
          Levi Pereira

          Edited by: Levi Pereira on Feb 24, 2012 11:10 AM
          • 2. Re: ORA-01031: insufficient privileges error
            CKPT
            Yesterday, i modified a sqlnet.ora, configuring a sqlnet.authentication_services=(none)
            Welcome to OTN.

            What are the earlier parameters & values in DB1 & DB2 of sqlnet.ora ?
            Have you Changed password file?

            also
            $id
            • 3. Re: ORA-01031: insufficient privileges error
              SPA2
              Hi,
              You, have to check or recreate the oracle password file.

              Recreate the file otherwise please send more details.

              reagards
              SPA2