RDBMS version: 11.2.0.4
OS : Oracle Linux 6.4
In one of my DBs I have 35 application users. When the application starts , it is throwing "ORA-01017: invalid username/password; logon denied" error in
the application logs. The application team does not know which user is having this issue.
All these users are in OPEN state (as shown in DBA_USERS.ACCOUNT_STATUS column ). There are two possibilities:
1. Application is trying to connect with the wrong password
2. Application is trying to login as a user which does not exist in the DB
I grepped for ORA-01017 error in the listener log and it didn't return any matches. Any way I can see which user is encountering "ORA-01017: invalid username/password; logon denied" error ?