Change password Oracle

How to change password in Oracle

Data is the back bone of any Organization, so we must protect it from un-authorize access. First step is protect the Oracle Account is enforce strong password which people cannot guess or brute force. If you think that Oracle account password is weak, you can use any of the below method to change it

1. Using SQL Plus

Step 1. Connect to SQL Plus
Step 2. Issue below command
SQL> password
Changing password for MANOJ
Old password:
New password:
Retype new password:
Password changed
SQL>

Please make sure that password policies are met. In general password must contain a capital letter,one symbol and one numeric.

2. Using TOAD

a) Using GUI

Step1. Connect to TOAD
Step2. Open Session –> Change Password

change password TOAD
change password TOAD

Step3. Enter old and new password and click “Execute”

change password TOAD window
change password TOAD window

b) Using Command
Step1. Connect to TOAD
Step2. Open SQL Editor

 

 

 

 

 

Step3. type keyword “password” and run. It will popup a password change window

3. Using SQL Developer

Step1. Connect to SQL eveloper
Step2. Open SQL Editor
Step3. type keyword “password” and run. It will popup a password change window

change password SQL Developer
change password SQL Developer

4. Get help from DBA

DBAs also can change/reset password for you.

Advertisements