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.
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
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.
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?
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.