14 Replies Latest reply: Aug 28, 2011 10:49 AM by EdStevens RSS

    I cannot login as SYSDBA

    566450
      Hi.
      I'm running Oracle 8i for Windows NT (8.0.5) on Windows Server 2000. Somewhere I read that I need to be in ora_dba group on Windows NT platform in order to login as sysdba to database. But I cannot find this group. When I try to login as sysdba as system/manager, login fails with ORA-01031: insufficient privileges. I need to execute startup and shutdown commands from SQL*Plus.
      Thx for help

      C:\>sqlplus /nolog
      SQL*Plus: Release 8.0.5.0.0 - Production on Mon Mar 26 8:13:23 2007

      (c) Copyright 1998 Oracle Corporation. All rights reserved.

      SQL> connect system/manager as sysdba
      ERROR:
      ORA-01031: insufficient privileges

      SQL>


      Message was edited by:
      paulie.x
        • 1. Re: I cannot login as SYSDBA
          488408
          Hi,

          you dont have permission to access the database,

          Do this:

          C:/>Sqlplus/nolog
          SQL>Conn/as sysdba
          SQL> Startup

          Then Create a user and grant t he connect/resource privilage

          Regards
          S.Senthil Kumar
          • 2. Re: I cannot login as SYSDBA
            VipinK
            This type of errors comes only when u have forgotten uar password for sys.

            So create a new password file ora%SID% and give some new password to this file and then connect as sysdba using that password only .

            It will works...


            Vipin
            • 3. Re: I cannot login as SYSDBA
              566450
              I have permissions to connect to database, but I haven't permissions to connect as SYSDBA.

              C:\>sqlplus /nolog

              SQL*Plus: Release 8.0.5.0.0 - Production on Mon Mar 26 8:46:56 2007

              (c) Copyright 1998 Oracle Corporation. All rights reserved.

              SQL> connect /as sysdba
              Invalid option.
              Usage: CONNECT <username> [AS SYSDBA|SYSOPER]

              SQL> connect system/manager
              Connected.

              SQL> connect system/manager as sysdba
              ERROR:
              ORA-01031: insufficient privileges

              Warning: You are no longer connected to ORACLE.

              SQL>
              • 4. Re: I cannot login as SYSDBA
                556902
                hi ,
                are you trying to connect from any remote machine in your LAN??

                SKP
                • 5. Re: I cannot login as SYSDBA
                  Maran Viswarayar
                  system user dont have the privileges to access to the Db as sysdba

                  login as a user who has sysdba privileges.

                  System dont have SYSDBA privileges
                  • 6. Re: I cannot login as SYSDBA
                    556902
                    i'm also in agree with maran.. system user dont have sysdba privileges .. try to connect as sys user might help..

                    connect sys/pwd@hoststring as sysdba;
                    • 7. Re: I cannot login as SYSDBA
                      566450
                      Sorry I cannot format to the output...

                      SQL> connect USER/PASSWORD
                      Connected.

                      SQL> select * from user_role_privs;

                      USERNAME GRANTED_ROLE ADM DEF OS_
                      -------- ------------ --- --- ---
                      USER CONNECT NO YES NO
                      USER DBA NO YES NO
                      USER RESOURCE NO YES NO

                      SQL> connect USER/PASSWORD as sysdba
                      ERROR:
                      ORA-01031: insufficient privileges

                      Warning: You are no longer connected to ORACLE.

                      SQL> connect sys/change_on_install as sysdba;
                      ERROR:
                      ORA-01031: insufficient privileges

                      Warning: You are no longer connected to ORACLE.

                      SQL> connect sys/change_on_install
                      Connected.

                      SQL> select * from v$pwfile_users;
                      ERROR:
                      ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]

                      no rows selected

                      SQL>


                      I found that password file doesn't exist so I created it.

                      C:\>orapwd file=PWDORCL.ORA password=password

                      I cannot restart server until one hour to update change.
                      • 8. Re: I cannot login as SYSDBA
                        Maran Viswarayar
                        Again as a user who has password cannot login as sysdba

                        create a user,grant him sysdba privilge,create a password file,

                        then try to login as the USER and see
                        • 9. Re: I cannot login as SYSDBA
                          469351
                          Check the following parameter in your init.ora

                          remote_login_passwordfile string EXCLUSIVE

                          Should be set to EXCLUSIVE. Then make sure that the password file exists in $ORACLE_HOME/dbs in this format - orapw$ORACLE_SID
                          • 10. Re: I cannot login as SYSDBA
                            Maran Viswarayar
                            The parameter is for login from remote machine as sysdba not for local login am i right?

                            Message was edited by:
                            Maran Viswarayar
                            • 11. Re: I cannot login as SYSDBA
                              469351
                              Yes, that's true. Also true if you try to login thru two-task from the local machine. However, irrespective of that you do need the orapw<$ORACLE_SID> file in $ORACLE_HOME/dbs.

                              And when you execute this query, you should get the following row(s):

                              SQL> select * from v$pwfile_users;

                              USERNAME SYSDB SYSOP
                              ------------------------------ ----- -----
                              SYS TRUE TRUE
                              • 12. Re: I cannot login as SYSDBA
                                566450
                                What is the purpose of internal account in Oracle please ? Because now I'm connected to internal.
                                • 13. Re: I cannot login as SYSDBA
                                  885029
                                  thanx
                                  working..
                                  from command prompt
                                  sqlplus "/as sysdba" also works:-)
                                  • 14. Re: I cannot login as SYSDBA
                                    EdStevens
                                    user13574172 wrote:
                                    thanx
                                    working..
                                    from command prompt
                                    sqlplus "/as sysdba" also works:-)
                                    Did you notice you were thanking someone from a thread that is over 4 years old, dealing with a version of oracle that hasn't been supported in this millennium?