Skip to main content

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.

Comments

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID