lost sys password 9i

[hamhey]

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

Regards hamhey

[tamilselvan]

Have you forgotten system password also?

Tamil

[gandolf989]

Have you tried Orapwd?

[adewri]

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

[hamhey]

Thanks Amar for the response.

// hamhey

[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

[adewri]

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

[davey23uk]

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

[abhaysk]

set authentication mode nts