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
Step3. Enter old and new password and click “Execute”
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
4. Get help from DBA
DBAs also can change/reset password for you.
