Search code examples
databaseoracle-databaseoracle12c

How to change SYS and SYSTEM password in oracle 12c?

Hi i am new to programming. I was trying to install oracle 12c on my windows 10. I was following the tutorials. But unfortunately i missed a step. When Database configuration Assistant window popped up i was supposed to click on Password Management but instead i clicked ok.

enter image description here

So i can not access to the following step

enter image description here

So how do i get back this window to change SYS and SYSTEM password?

Solution

  • You can try this:

    Login as SYSDBA:

    sqlplus "/ as sysdba"

OR

sqlplus /nolog
connect / as sysdba

    Change password using ALTER Command:

    SQL> ALTER USER SYS IDENTIFIED BY [password]; 
SQL> ALTER USER SYSTEM IDENTIFIED BY [password];