Tuesday, January 16, 2018


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

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...