Thursday, 20 February 2020

Oracle Database password expired

Tags


Possible Error During SAP Upgrade.

1. Oracle Password expired and required that this be changed.
2. Once changed unable to connect to the database. Sourcing no longer functions.
3. Error: "attempted connection to System Database [jdbc:oracle:thin:@somehost:1527:ABC(source/source)]:0 failed. Reason: ORA-28001: the password has expired"

Run the below Command to reset or extend Password Lifetime in DB Level.

 In the Oracle case simply applying the following SQL command as an admin user will allow the specified profile (and users assigned to it) to have a nonexpiring password:

    SQL> ALTER PROFILE PASSWORD_LIFE_TIME UNLIMITED;

 


EmoticonEmoticon

Note: only a member of this blog may post a comment.