What is the possible root cause of an error like ERROR DB_LOGIN SQL_RC=28002
Scenario, We are getting this error from an application server that is connected to the Oracle Database 11g, Version 11.2.0.4.
Validating the Oracle database alerts logs does not show any ORA related to the said error, idealy this should be equal to ORA-28002 where the error is specific to a password expiration.
But upon checking oracle database, we can see that the user password (service account) has a grace period.
Checking the database sesssion, we can see as well that the application server was able to connect to the oracle database successfully. but from the application server . the logs are throwing the error "ERROR DB_LOGIN SQL_RC=28002".