Enabling the Reset Password Feature in Oracle SQL Developer

It happens. We forget our password and it becomes a headache all of a sudden. Here is one way to reset the password from Oracle SQL Developer.

You might have noticed the 'Reset Password' option, when you right click on any connection. It might be grayed out if you do not have the Oracle Client installed. Here's how you can enable that option by installing the client.

Download the Oracle Client from http://www.oracle.com/technetwork/topics/winsoft-085727.html

UnZip the same and place it at your convenient location. You need the location to map the client later in the setup.

Add the above path to the Environment Variable

Go to Tools > Preferences > Database > Advanced and check 'Use Oracle Client' & 'Use OCE/Thick Driver'

Click on 'Configure' and locate the Oracle Client. Select Client Type as 'Instant Client'.

Then click on 'Test' button and make sure you get the success message as given below.

Re-start the SQL Developer, then on the corresponding Connections, right click and make sure that the 'Reset Password' option is enabled.

And you have it!

This is really really handy. Wooh!

Error Viewing Reports/Logs

On opening View log/trace, and clicking the corresponding filename,a warning message “Your User ID and/or Password are invalid.”pops up. On entering the UserID and password, “An error has occurred.” message is displayed.

- Check if the SYSADM user password was recently modified. If this is the case then delete process scheduler cache and restart the process scheduler.

- Check if the password was modified for the operator id (userid) that is configured in psprcs.cfg. If this is the case then delete process scheduler cache and restart the process scheduler.