9 Replies Latest reply: Oct 20, 2004 6:39 AM by 343717 RSS

    sys password

    415008
      When i installed oracle9i server i changed sys's password and system's password as well .But later on i forget them both .I hardly tried to remember them.Is there any way to solve this dilemma.

      I would highly appreciate any help.it's a real problem.
        • 1. Re: sys password
          dvohra21
          Alter the password.
          ALTER USER SYS IDENTIFIED BY <password>
          • 2. Re: sys password
            430925
            If you do not have any DBA privileges, then you can not use alter user commmand to change the sys/system passwords.

            I assume, the password file is sitting in
            D:\ORACLE\ORA92\DATABASE\PWDdatabase1.ora

            Go to command prompt, Goto BIN directory,

            orapwd.exe file=D:\oracle\ora92\database\PWDstandby1.ora password=sys

            Rename the PWDSTADNBY1.ora with actual file.

            Shutdown and restart the database.

            Govind

            • 3. Re: sys password
              429221
              If iam a DBA and I lost my sysdba or sys password, what is th ealternative option i have? Could any one tell this...


              bala
              • 4. Re: sys password
                426250
                you can log to system/pwd@service and use alter user ys identified by password ;
                • 5. Re: sys password
                  430650
                  If you can't login at all, how would you get into SqlPlus to type those commands?

                  Thanks
                  • 6. Re: sys password
                    430368
                    Hi
                    I am facing problem similar to this.But my problem is that while installing oracle i changed the password.But i can connect with sys and system using any pwd.Any reasons for so.

                    Regards
                    • 7. Re: sys password
                      415008
                      I tried to recreate the password file with new password for sys ,but the problem still unsolved .Did anyone have successfuly solve it ?

                      with regards
                      • 8. Re: sys password
                        Sudhanshu
                        There should be no problem in doing this.

                        1. Do you have access to the system? Administrator or root user? OR
                        2. Do you have a OS user that is member of the group DBA?
                        3. What is the parameter remote_login_passwordfile?

                        We can go step by step for this once you tell us What steps you have followed?
                        • 9. Re: sys password
                          343717
                          Go to the server, in windows log in with an account in the ora_dba group, in unix log on with the oracle account.

                          Then log on to Oracle with / as sysdba. You can then alter user the sys and system accounts.

                          If you are using an older version of oracle that still has svrmgrl you can start svrmgrl and connect as internal.