Thursday, January 30, 2014

Reset forgeted Oracle 10G/11G login password... !!!

       
  Hey.. Dear Folks..... Are you forget your Oracle 10G/11G login password... !!!  And are you Worried.. fully Tensed... now what to do...??? 
            Don't worry my Dear friends.... just  follows given steps... Now you can change youe oracle Password... no need to enter Previous Password. Lets..Start..                                          


Steps to Reset SYS user password in Oracle 10g/11g



Hi Folks,

If you want to reset the oracle database sys user password then follow the steps below:

Assuming that ORACLE_HOME variable is set to the database home directory:

STEP 1:
Open a command prompt. (START->RUN->cmd)

STEP 2:
At the prompt type ‘sqlplus /nolog’

STEP 3:
connect / as sysdba

STEP 4:
Once your connected to the DB, you can change the SYS password by typing the following sql statement:

STEP 5:
ALTER USER sys IDENTIFIED BY new_password;


NOTE: in place of "new_password"..pls.. Enter your new Password. Don't use Special characters.. it may raise exception.