CHANGE SYS PASSWORD IN ORACLE
1. Re-create password file
If you want to reset the password of sys. you can recreate the password file with below cmd.
$ orapwd
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosysdba=<y/n>
where
file – name of password file (mand),
password – password for SYS (mand),
entries – maximum number of distinct DBA,
force – whether to overwrite existing file (opt),
nosysdba – whether to shut out the SYSDBA logon (opt for Database Vault only).
There are no spaces around the equal-to (=) character.
[root@test devapps]# su - oradev
[oradev@test ~]$ . /u01/dev/devdb/tech_st/11.2.0/DEV_test.env
[oradev@test ~]$ orapwd file=$ORACLE_HOME/dbs/orapwDEV password=oracle entries=30
2. Type the following commands:
$ sqlplus "/ as sysdba"
SQL> ALTER USER SYS IDENTIFIED BY [password];
SQL> ALTER USER SYSTEM IDENTIFIED BY [password];
No comments:
Post a Comment