Thursday, 14 August 2014

Command to change database sys user password

We can change oracle database sys user password with below command.
Password file location:
location in linux is $ORACLE_HOME/dbs
location in Windows is $ORACLE_HOME/database

Take backup of the existing file and try below command in  respective platform, 

$ orapwd file=orapw$ORACLE_SID.ora entries=100 ignorecase=y password=manager force=y (in linux)

C:\>orapwd file=PWD$ORACLE_SID.ora entries=100 ignorecase=y password=manager force=y

No comments:

Post a Comment