12 Replies Latest reply: Jul 28, 2013 2:21 PM by REDO LOG RSS

    ... sqlplus / as sysdba ORA-1031

    646595
      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
          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
            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
              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
                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
                  @ 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
                    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
                      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
                        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
                          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

                            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

                              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

                                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.