dcsimg
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: ORA-01031: insufficient privileges

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    ORA-01031: insufficient privileges

    This might be a silly question...
    But on one particular database I recently created, 10.2.0.3, I get this error when I try this:

    $ sqlplus '/ as sysdba'

    I dont understand because the O/S user I'm using the Oracle user that installed the Oracle home for the database. And I logging on from the server itself, not from a client.

    I haven't dealt with this error in such a long time, I can't even remember what to check for why this happening.

    Thanks.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I see. How about checking oerr?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    oerr?
    What's that?

  4. #4
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    Are you talking about the utility that comes with Oracle?

  5. #5
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    $ ./oerr ORA 01031
    01031, 00000, "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.

    ... that wasn't much help.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    What's your REMOTE_LOGIN_PASSWORDFILE setting?

    If EXCLUSIVE or SHARED you might have to recreate your password file via orapwd
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Which OS? You don't have privileges.

    Hope the following are set,

    remote login passwordfile= EXCLUSIVE

    SQLNET.AUTHENTICATION_SERVICES=(NTS) -- in sqlnet.ora

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Which OS?

  9. #9
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44

    Ora-01031

    WHICH OS??

    U CAN FOLLOW WHT dbasan SAY

  10. #10
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    Sorry... the OS is Solaris 9.
    Both of the above paramters are set as you have specified. And I have tried re-creating the orapwSID file (with orapwd), but still not working.
    Any clue to why this is happening....?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width