This discussion is archived
9 Replies Latest reply: Oct 20, 2004 4:39 AM by 343717 RSS

sys password

415008 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    Alter the password.
    ALTER USER SYS IDENTIFIED BY <password>
  • 2. Re: sys password
    430925 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    you can log to system/pwd@service and use alter user ys identified by password ;
  • 5. Re: sys password
    430650 Newbie
    Currently Being Moderated
    If you can't login at all, how would you get into SqlPlus to type those commands?

    Thanks
  • 6. Re: sys password
    430368 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.