Saturday, September 19, 2015

Change Oracle Database System Schema Password

We might forget the Oracle database system schema password and thus we cannot proceed to any Fusion middleware Installation. But, when we try the sys connection and it is working fine. 

Please follow the below steps to change the db schema password on such situations.

Open command prompt or sql command line.

Sqlplsus “/as sysdba”

Execute the below commands in the sql prompt.

Sql > alter user sys identified by <new_password>;
Sql > alter user system identified by <new_password>;
Sql > alter user <schema_name> identified by <new_password>;

After changing the sys and system schema passwords, we can continue the remaining tasks.

No comments:

Post a Comment