Oracle - How do you change your Oracle database password?
Here are several methods for changing or resetting the password for an Oracle database. You will need to know the existing password.
Method 1: Using SQL*Plus (command line tool)
- At the command line, enter sqlplus user@database, where user is your user ID, and database is the specific database you are connecting to.
- Enter your current password.
- Once you have connected to the database, use the password command to change your database password.
SQL> password Changing password for <user> Old password: New password: Retype new password: Password changed SQL>
Method 2: Using the TOAD GUI
- Connect to your Oracle database from within TOAD.
- Select Session -> Change Password
- Enter your old password and new password and click Execute
Method 3: Using the TOAD command line
- Connect to your Oracle database from within TOAD.
- Open a SQL Editor window
- Type keyword password and run. It will pop up a password change window.
Method 4: Using SQL Developer
- Connect to your Oracle database from within SQL Developer.
- Open a SQL Editor window
- Type keyword password and run. It will pop up a password change window.