ora-1031
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-1031

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    ora-1031

    Hi

    I am new to Oracle 9.2.0.1.0. I have installed and database has been created. But when I try to connect using

    sqlplus /nolog
    SQL>connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges

    I found $ORACLE_HOME/dbs/spfileSID.ora containing remote_login_passwordfile='EXCLUSIVE'

    How to solve this problem. Please advice. Please consider this is an urgent.

    Thanks In Advance
    Nagesh

  2. #2
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    More info.

    When I try to configure a database using dbca, I am getting
    ORA-01031: insufficient privileges

    Is this because of my user(oracle) level setting problem? According to my knowledge it should be oinstall as primary group, dba as secondary group. But in this case group defined as other.

    Please advice.

    Thanks In Advance
    Nagesh

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    primary and secondary are optional, you can perfectly have a single dba or oinstall group

  4. #4
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by pando
    primary and secondary are optional, you can perfectly have a single dba or oinstall group
    Thank You very much. In my case oracle user is defined with group other not dba/oinstall. Is this causing problem? Do I need to reinstall Oracle with oinstall/dba group? Please advise.

    Thanks in Advance
    Nagesh

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes that's your problem

    seems like you have not followed the steps in the installation guide

  6. #6
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by pando
    yes that's your problem

    seems like you have not followed the steps in the installation guide
    Thank You very much. Actually some one installed oracle, and I was assigned to create database. I am going to reinstall it. Thanks Once again.

    Regards
    Nagesh

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