1 2 Previous Next 15 Replies Latest reply: Jan 4, 2011 10:19 AM by Chinar RSS

    ORA-01031: insufficient privileges

    user522961
      Hi,
      on 10g R2 on AIX 6.1 I receive when connecting with user sys as sysdba :
      #sqlplus sys@mydb as sysdba
      
      SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 4 13:49:02 2011
      
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      
      Enter password:
      ERROR:
      ORA-01031: insufficient privileges
      In documentations :
      ORA-01031: insufficient privileges
          Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
          Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
      But I can connect :
      #sqlplus / as sysdba
      
      SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 4 13:51:05 2011
      
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      
      
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      I have no sqlnet.ora file.

      Any idea.

      thanks.
        1 2 Previous Next