Hi All,
The steps to reset the SYS user password in oracle database is shown below
Assuming that ORACLE_HOME variable is set to the database home directory:
Open a command prompt. (START->RUN->cmd)
At the prompt type ‘sqlplus /nolog’
connect / as sysdba
Once your connected to the DB, you can change the SYS password by typing the following sql statement:
ALTER USER sys IDENTIFIED BY new_password;
Also check how to reset weblogic password in obiee 11g
Thanks,
Sandeep Venu
6 comments:
thanks ...
MFOConsulting
when i connect as sysdba, error occured, it shows insufficient privilege
i m also very thankful to u.....
Thanks. I should have remember this. There are some criteria for make this work of course... Like: Can you become the owner of the software, eg "oracle" OS user. I believe so long as Oracle recognizes the OS user then this can be done.
Much helpful thank you.....
it is asking for oldpassword
but i forgot my old password
Post a Comment