lost sys password 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: lost sys password 9i

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    lost sys password 9i

    Dear DBAs,
    I 've lost my sys password. Do you know any way to recreate a new pass.

    Regards hamhey

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Have you forgotten system password also?

    Tamil

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Have you tried Orapwd?
    this space intentionally left blank

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Login to the server where the oracle database resides as user oracle(user who installed the oracle software and belongs to the dba group) and connect to the database (make sure you export ORACLE_SID to the required/target database) using sqlplus as "sys as sysdba". When prompted for password just press enter. This will login you to the database as sysuser. Then do "alter user sys identified by new_password;".

    In windows the user should be a member of ORA_DBA group. Then connecting as sys as sysdba will not prompt for the password. Change password as show above.

    Else you can always work use orapwd to create a new password file.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Thanks Amar for the response.

    // hamhey

  6. #6
    Join Date
    Jan 2002
    Posts
    146
    Hi,

    I got similar problem...I login to Administrator which is member of
    ORA_DBA group in win2000 Ora9i. I run sqlplus as "sys as sysdba"
    but i got ora-1031 insufficient privileges.
    Can u help pls

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by rommel
    Hi,

    I got similar problem...I login to Administrator which is member of
    ORA_DBA group in win2000 Ora9i. I run sqlplus as "sys as sysdba"
    but i got ora-1031 insufficient privileges.
    Can u help pls
    Did you set the ORACLE_SID before trying sqlplus
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by rommel
    Hi,

    I got similar problem...I login to Administrator which is member of
    ORA_DBA group in win2000 Ora9i. I run sqlplus as "sys as sysdba"
    but i got ora-1031 insufficient privileges.
    Can u help pls
    whats in your sqlnet.ora file - this can effect it

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    set authentication mode nts
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width