This discussion is archived
12 Replies Latest reply: Jul 28, 2013 12:21 PM by REDO LOG RSS

... sqlplus / as sysdba ORA-1031

646595 Newbie
Currently Being Moderated
Hi Guys,

i need your advices.

I installed GridControl 10.2.0.4 with the feature new database. The Universal Installer installed a 10.1.0.4 Database and i have one big problem. I can`t login from console with sqlplus / as sysdba or sqlplus ' / as sysdba'.

For both methods i get the same error message:

##############################################

uxmon02:oracleg> sqlplus / as sysdba

SQL*Plus: Release 10.1.0.4.0 - Production on Wed Jun 25 13:11:50 2008

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

ERROR:
ORA-01031: insufficient privileges

Enter user-name:

#########################################

The User oracleg is the installation user and he is member of the groups oinstall, operator and dba.

What can be the problem?

best regards
  • 1. Re: ... sqlplus / as sysdba ORA-1031
    517724 Newbie
    Currently Being Moderated
    check whether operating system user is the member of ora_dba group or not and if not then add it.
    2nd go to oracle home bin nd run prompt from that location nd may be problem solved.
  • 2. Re: ... sqlplus / as sysdba ORA-1031
    Eduardo Legatti Explorer
    Currently Being Moderated
    Hi,

    There are many threads about this error in this forum, so first of all, I advise you to take a look at this [url http://forums.oracle.com/forums/search.jspa?forumID=61&threadID=&q=ORA-1031+%2F+as+sysdba&objID=f61&dateRange=all&userID=&numResults=15&rankBy=9]search results

    Cheers

    Legatti
  • 3. Re: ... sqlplus / as sysdba ORA-1031
    631262 Newbie
    Currently Being Moderated
    I just spent several hours fighting past this.

    If your windows operating system working directory has a .ora file in it, it will not let you log in using sqlplus / as sysdba

    I'm hoping that there is some clever reason for such an odd "feature" other than an april fools joke that someone forgot to remove from the code base.
  • 4. Re: ... sqlplus / as sysdba ORA-1031
    EdStevens Guru
    Currently Being Moderated
    I just spent several hours fighting past this.

    If your windows operating system working directory
    has a .ora file in it, it will not let you log in
    using sqlplus / as sysdba
    Sorry, but that's pure b.s. Show us the proof.
  • 5. Re: ... sqlplus / as sysdba ORA-1031
    646595 Newbie
    Currently Being Moderated
    @ user514721

    thanx for your advice the second way doesn`t work. I have one question about the ora_dba group, by the installation of the oracle home i specify the oracle installation group and the oracle dba group in both cases i said that the group is oracle.

    My user oracleg is member of the group oracle and this is also his main group.

    Is this the information that u want?

    @Eduardo

    Thank for your advice, but i still done it, but the result of the search didn`t help me.

    As Example, one poster in this forum had the idea to delete the config.o and to rebuil them with the relink command.

    BUT IT DOESNT HELP!!!

    I searched the whole metlink but there also no posts they worked for my problem. Thats the Reason why i`m posting.

    @ user628259

    Sorry i forgot to say that my database server is a sun sparc machin with sun solaris 5.10.



    thanx for your advices, i hope we find a solution i`m still working on this problem

    best regards

    sascha
  • 6. Re: ... sqlplus / as sysdba ORA-1031
    629537 Newbie
    Currently Being Moderated
    Hi........

    grant sysoper to system;


    SQL> grant sysoper to system;
    Grant succeeded.

    SQL> connect system as sysoperEnter password:Connected.


    this will definitely solve ur problem!!!!

    Regards,
    Nick.
  • 7. Re: ... sqlplus / as sysdba ORA-1031
    Sabdar Syed Oracle ACE
    Currently Being Moderated
    Check the Oracle Metalink Note:69642.1
    Subject: UNIX: Checklist for Resolving Connect AS SYSDBA Issues

    Regards,
    Sabdar Syed.
  • 8. Re: ... sqlplus / as sysdba ORA-1031
    631262 Newbie
    Currently Being Moderated
    I just spent several hours fighting past this.

    If your windows operating system working directory
    has a .ora file in it, it will not let you log in
    using sqlplus / as sysdba
    Sorry, but that's pure b.s. Show us the proof.
    Catch a plane to Addis Ababa, Ethiopia and I'll be glad to sit you down and show you. I'll even pick you up at the airport!

    Seriously, I know what I told you is too stupid to believe.

    I'm putting together a batch file that makes a few post-facto mods to the oracle xe install.

    I issued the following commands:

    sqlplus /nolog
    sql>connect / as sysdba;
    I got the insufficient privileges error.

    I tried all kinds of things.
    My working directory was on a flashdrive, so I switched to c:\.

    Same sqlplus commands and I connected.
    So, I copied my flashdrive directory to a new directory on the c drive and switched my working directory to that.

    Back to insufficient privileges error.

    Thought maybe the name of the directory was too long, so I shortened it. Also checked that the security on the new directory wasn't wonky.

    I connected just fine with my working directory in the new directory with the shorter name.

    I copied my install mod files to the new directory and tried to connect again.
    Back to the insufficient privileges error.

    I removed files with the same extension from the directory. When I removed the .ora files, the connect started working again. I put all the files back in except for the .ora files and the connect still worked.

    So, you tell me if I diagnosed it wrong or not!

    It took three of us to think of enough kooky things to try till we found one that worked.
  • 9. Re: ... sqlplus / as sysdba ORA-1031
    631262 Newbie
    Currently Being Moderated
    Forgot to mention that my test was on 64bit Windows Vista.

    I have (very unhappily!!!) discovered that I can't connect on 32bit Windows XP using the same install script (other than changing Program Files (x86) to Program Files).

    :(
  • 10. Re: ... sqlplus / as sysdba ORA-1031
    NajeebKhan Newbie
    Currently Being Moderated

    The answer is simple check the below and try to connect.



    1] The Windows user ID with which you signed in is part of the ORA_DBA group.

    2] SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora file.

  • 11. Re: ... sqlplus / as sysdba ORA-1031
    sb92075 Guru
    Currently Being Moderated

    Consider to examine & consider the date of the FIRST & LAST entry in any thread BEFORE responding

  • 12. Re: ... sqlplus / as sysdba ORA-1031
    REDO LOG Newbie
    Currently Being Moderated

    Hi,

    You can connect to the database without giving a password if the user under witch you logged to the operating system is a member of the ora_dba under Windows or dba under Linux/Unix. otherwise you will have to provide a password so that oracle can authenticate you using the password file.