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
-
Invoke
sqlplus.exe
as an admin equivalent user (sys or system):sqlplus / as sysdba
OR
sqlplus sys/password@instanacename as sysdba
-
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
-
Connect as an admin equivalent user (sys or system).
-
Locate the Other Users node within the tree.
-
In the Other Users branch, select the user, right-click, and select Edit Users.
-
In the Edit User dialog, enter a new password in the New Password field and the Confirm Password field.
-
Click Apply.