-
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
-
-
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."
-
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
-
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."
-
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|