Hell Experts-
I'm trying to find details on failed logins to DB from 2 different systems one is java application and the other is Cognos and they both connect to Oracle 11.2.0.3 database. There are some instances where the app comes back with unable to connect however this is intermittent as of now.
- The database alret log did not record any ora errors during the timeframe of failed logins as well as the listener log did not have any errors. Is the next approach to look into audit trail ? ASSUMING there is small possibility the issue can be traced to/from the DB server ?
The database has audit_trail set to DB & I wanted to look at audit trail to see if it captures any of those failed attempts. I'm still in the process of understanding why the apps fail to connect and if this is purely network related but since I've started to look into audit trial I ran into something: The audit entries were last logged from Oct-2015 until dec 2016.
2. Do I need to set the audit trai lto something else to get the logins recorded again ?