Update Oracle database password

The following are examples of an Oracle database password update using SQL*Plus and SQL Developer. Some steps may vary depending on the client tool and version used to perform the procedure.

Changing the Oracle database password using the SQL*Plus Client

  1. Invoke sqlplus.exe as an admin equivalent user (sys or system):

    sqlplus / as sysdba

    OR

    sqlplus sys/password@instanacename as sysdba

  2. Execute the following ALTER command from a SQL> prompt:

    ALTER USER <USERNAME> IDENTIFIED BY <NEWPASSWORD>;

Changing the Oracle database password using the SQL Developer Client

  1. Connect as an admin equivalent user (sys or system).

  2. Locate the Other Users node within the tree.

  3. In the Other Users branch, select the user, right-click, and select Edit Users.

  4. In the Edit User dialog, enter a new password in the New Password field and the Confirm Password field.

  5. Click Apply.