1 2 Previous Next 21 Replies Latest reply: Jan 23, 2013 6:21 AM by Harsh_v RSS

    Can not able to log in into sys as sysdba

    piku
      Hi all,

      I have one instance name is skydb and once upon a time i used it when i created it.i did set one password for the sys user and created password file.but right now i have forgot the password of sys.again creating the password file using below command.
       orapwd file=orapwdskydb password=oracle entries=10
      but can not able to log in into sys as sysdba using this 'oracle' password .

      for your information now the database is down.we also need to up it.

      please help.
      thanks a lot in advance.

      atanu
        • 1. Re: Can not able to log in into sys as sysdba
          sb92075
          piku wrote:
          Hi all,

          I have one instance name is skydb and once upon a time i used it when i created it.i did set one password for the sys user and created password file.but right now i have forgot the password of sys.again creating the password file using below command.
           orapwd file=orapwdskydb password=oracle entries=10
          but can not able to log in into sys as sysdba using this 'oracle' password .

          for your information now the database is down.we also need to up it.

          please help.
          thanks a lot in advance.

          atanu
          do EXACTLY as below

          sqlplus
          / as sysdba
          • 2. Re: Can not able to log in into sys as sysdba
            Catfive Lander
            An operating system would be nice to know.
            Also confirmation that your ORACLE_SID is set to "skydb"
            And that you created the password file in the correct location (which depends on the answer to the first point)

            Additionally, you should be able to do a password-less SYS connection directly on the server itself. (i.e, connect / as sysdba) if your OS user is a member of the DBA group.
            • 3. Re: Can not able to log in into sys as sysdba
              Niket Kumar
              AS sb suggested.....

              first check oracle service for database skydb is running in windows from services.msc

              cmd>set ORACLE_SID=skydb
              cmd>sqlplus / as sysdba
              sql>startup
              sql>alter user sys identified by password;



              you can change sys user password using alter user command as stated above....
              • 4. Re: Can not able to log in into sys as sysdba
                Catfive Lander
                How do you know he's running on Windows?

                Both you and sb are wrong, too, in just saying '/ as sysdba' will fix it. If our user was a member of the ORA_DBA or DBA group, then sqlplus "sadjhdjkf/djfhskjfhksdj as sysdba" would work regardless of what password has been set in the password file. Conversely, if he's NOT a member of the ORA_DBA or DBA group, then trying to "connect / as sysdba" isn't going to work.

                So we can deduce he's using an OS account that isn't privileged. Perhaps because he's connecting remotely. But either way, that will require the use of a proper SYS password at connection time.
                Meaning we can't just fob him off with "try typing "sqlplus / as sysdba exactly", because that's not going to work.
                • 5. Re: Can not able to log in into sys as sysdba
                  Niket Kumar
                  hey catfive.....

                  he don't know how to login into oracle database so I Assume he will not be on NIX system.....lets wait for op reply if he get any error we will give NIX way also...... :-)
                  • 6. Re: Can not able to log in into sys as sysdba
                    Catfive Lander
                    Bad assumption to make on flimsy grounds, I think.

                    But that still doesn't make telling him "use / as sysdba" any better, because that obviously cannot work in his situation, whatever OS he turns out to be on. If he's getting an error using "oracle" as the password, then he's not a member of an OS privileged group. Therefore, he **can't** use "/ as sysdba".

                    Which is why I was careful to say that he could try "/ as sysdba" if he was directly connected to the database server AND that he was a member of the OS privileged group. Without those caveats, your advice (and sb's) was simply wrong.
                    • 7. Re: Can not able to log in into sys as sysdba
                      Niket Kumar
                      I'm sorry catfive....I will ask OS before giving advice.....thanks for reminding .....

                      I am using / as sysdba always at home....as op said he has install it so he will automatically became member of ORA_DBA group....
                      • 8. Re: Can not able to log in into sys as sysdba
                        piku
                        Hi All,

                        first of all thaks a lot for your promt reply.now for your information my os info is
                        Linux oracleDB11g 2.6.32-71.el6.i686 #1 SMP Fri Nov 12 04:17:17 GMT 2010 i686 i686 i386 GNU/Linux
                        my account user is in DBA group and its confirm.
                        now am giving the output of the
                        each command
                        [oracle@oracleDB11g admin]$ sqlplus / as sysdba
                        
                        SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:04:25 2013
                        
                        Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                        
                        ERROR:
                        ORA-01031: insufficient privileges
                        and
                        [oracle@oracleDB11g admin]$ sqlplus /nolog
                        
                        SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:05:59 2013
                        
                        Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                        
                        SQL> connect / as sysdba
                        ERROR:
                        ORA-01031: insufficient privileges
                        also want to tell you I have created that password file on location is
                        /oracle/app/oracle/product/11.2.0/dbhome_1/dbs
                        thanks once again
                        atanu
                        • 9. Re: Can not able to log in into sys as sysdba
                          ora_tech
                          Hi,

                          Please check proper ORACLE_SID is set and password file contains valid SID name.

                          thanks,
                          X A H E E R
                          • 10. Re: Can not able to log in into sys as sysdba
                            Niket Kumar
                            paste output for

                            ps -ef|grep pmon
                            • 11. Re: Can not able to log in into sys as sysdba
                              asahide
                              Hi,

                              Could you show us output of "env" command?
                              Check ORACLE_SID parameter.

                              And also check follows.
                              cd $ORACLE_HOME/rdbms/lib
                              cat config.c
                              regards,
                              • 12. Re: Can not able to log in into sys as sysdba
                                piku
                                FYI
                                [oracle@oracleDB11g dbs]$ export ORACLE_SID=skydb
                                [oracle@oracleDB11g dbs]$ echo $ORACLE_SID
                                skydb
                                [oracle@oracleDB11g dbs]$ sqlplus / as sysdba
                                
                                SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:25:32 2013
                                
                                Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                                
                                ERROR:
                                ORA-01031: insufficient privileges
                                
                                [oracle@oracleDB11g dbs]$ ps -ef|grep pmon
                                oracle    3082  2915  0 11:25 pts/1    00:00:00 grep pmon
                                • 13. Re: Can not able to log in into sys as sysdba
                                  633234
                                  Hi,

                                  Can you please post output of "id" command? and group permission given to Oracle user?

                                  Regards,
                                  Amit.
                                  • 14. Re: Can not able to log in into sys as sysdba
                                    Niket Kumar
                                    your database is not running.....
                                    as you can see from pmon command....
                                    check permissions for insufficient privileges....
                                    1 2 Previous Next