Default passwords of Oracle 11g? [closed]

It is possible to connect to the database without specifying a password. Once you’ve done that you can then reset the passwords. I’m assuming that you’ve installed the database on your machine; if not you’ll first need to connect to the machine the database is running on.

  1. Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.

  2. Enter sqlplus / as sysdba in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.

  3. Once you’re logged in, you can then enter

    alter user SYS identified by "newpassword";
    

    to reset the SYS password, and similarly for SYSTEM.

(Note: I haven’t tried any of this on Oracle 12c; I’m assuming they haven’t changed things since Oracle 11g.)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)