29/03/2014

[Oracle] Reset/recover SYS password

In Oracle, it's possible to connect to the database without specifying a password if the user account on the machine where the DB is running is a member of the DBA group.

Then it will be possible to reset the password for any user (even SYS); this is especially useful if you forgot what your password was. First, connect to the machine where the DB is running then open a command prompt and type:

SQLPLUS / AS SYSDBA

to log in, then type

ALTER USER USER_NAME IDENTIFIED BY "NEW_PASSWORD";

to change the password for USER_NAME

No comments:

Post a Comment

With great power comes great responsibility.

Da grandi poteri derivano grandi responsabilità.