How to Change an Oracle Password

by Qiana EaglinUpdated September 28, 2017
laptop with database record on 15.4" wide screen image by .shock from Fotolia.com

Items you will need

  • Computer

  • Oracle

Oracle is a relational database management system that stores data in tables. Users who access Oracle databases and tables must supply their log-in credentials (user name and password) in order to access the data. As a database administrator (DBA), you can change your Oracle password and the password for other Oracle users using the SQL*Plus to submit a Structured Query Language (SQL) command and a password command.

SQL Command Method

Log in to the system where you installed the Oracle database, using your DBA credentials.

Change to the directory where Oracle is installed, and then change to the bin directory by running the following commands:

cd cd bin

where is the directory where Oracle is installed.

Start SQL*Plus and make a connection as the DBA by running the following commands: ./sqlplus/nolog connect / as sysdba

Run the following SQL command from the command line to change the password for the specified user: ALTER USER IDENTIFIED BY ;

where is the name of the user whose account you want to update and is the new password that will be associated with the account. You will receive a message if the password is successfully changed.

Changing Your Password Using SQL*Plus Method

Log in to the system where you installed the Oracle database, using your DBA credentials.

Start SQL*Plus by running the following command: SQLPLUS

Run the following command from SQL*Plus to change your own password: password

Type your old password, when prompted for it.

Type your new password, when prompted for it.

Retype your new password, when prompted for it. You will receive a message if the password is successfully changed.

Changing Another User's Password Using SQL*Plus Method

Log in to the system where you installed the Oracle database, using your DBA credentials.

Start SQL*Plus by running the following command: SQLPLUS

Run the following command from SQL*Plus to change the password for another user: password user_name

Type the new password for the user, when prompted for it.

Retype the new password, when prompted for it. You will receive a message if the password is successfully changed.

Warnings

The user name and password for an Oracle account is not case sensitive.

References

Photo Credits

  • laptop with database record on 15.4" wide screen image by .shock from Fotolia.com

About the Author

Residing in Durham, N.C., Qiana Eaglin has been writing technical documentation for software companies since 2003. She received a Bachelor of Science in electrical engineering from Morgan State University and a Master of Business Administration from Pfeiffer University. She writes for eHow and Trails Travel.

More Articles

×