How to reset the password Oracle SYS and SYSTEM

Sometimes we forget the Oracle SYS and system passwords, and don't worry, you can change the password by Sqlplus. Can only be modified, can not be retrieved.

Here's how:

1. Open cmd interface, enter Sqlplus/nolog

The results appear as follows:

2. Enter conn/@orcl as SYSDBA in the DOS window Note: ORCL is your db instance. The following is displayed after carriage return:

3, after the connection, we can make any change password, wait!

in the DOS window, type alter USER SYS identified by 123456789; Note: Be sure to use a semicolon concluding sentence

The results are as follows:

At this point the password modification succeeds, the client login sys to log in as SYSDBA role.

How to reset the password Oracle SYS and SYSTEM