lost sys password 9i

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

Regards hamhey

Have you forgotten system password also?

Tamil

Have you tried Orapwd?

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

Thanks Amar for the response.

// hamhey

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

Quote:

---

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

Quote:

---

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

set authentication mode nts