Wednesday, May 25, 2011

How to change SYS / SYSTEM password


1) Backup the pwd file or folder :$ORACLE_HOME/dbs/orapw$ORACLE_SID


2) Run the below command as Oracle User   give the correct path and the file name... 
      orapwd file=<path>orapwSID password=oracle entries=5


3) Login sys as sysdba and check the new password.






Some Info...........


Create a new password file:
orapwd file=orapwSID password=oracle entries=5


If the password file already exists:
orapwd file=orapwSID password=oracle entries=5 FORCE=Y


Default location and file name:


The default location for the password file is:$ORACLE_HOME/dbs/orapw$ORACLE_SID on Unix
and %ORACLE_HOME%\database\PWD%ORACLE_SID%.ora on Windows.

No comments:

Post a Comment