Monday, March 18, 2019

[Oracle Database] How to reset EXPIRED password ?


As a DBA, I've gotten many requests for changing the password.

There are steps that you can use to change your password via Oracle SQL Developer by yourself without need to seek help from DBA.

You can also use this way to change the password which is already expired !

Step 1: Open Oracle SQL Developer

Step 2: Right click on your connection.
If you have not created your connect yet, you need to create one.













Step 3: Choose "Reset Password"
You need to provide the current password, and the new password.
=> Depend on password policy, It may require complex password/ or you can not reuse the old one.
















>>>Below video will shows you steps for the same.

How to install ORACLE DATABASE 19c on Virtual machine LINUX 7

Oracle Database 18c Express WITHOUT container database architecture.

Oracle has introduced multitenant architecture from Oracle Database 12c. In Oracle Database 18c Express edition, the CDB database (multiten...