Spotlight on Oracle- sysdba login attempts twice a day
Weve recently installed Spotlight on Oracle with OS monitoring. After we started the OS monitoring, were started having login problems. Every day at approximately 3:45am and pm, the user tries to log in, but cant connect because of our logon trigger. (We dont let in sessions that dont have an IP, OS_USERNAME and PROGRAM values.) It appears to be connecting as sysdba through server authentication. (We know that its connecting as sysdba because we dont see a corresponding record in dba_audit_session. We know thats OS authentication because theres nothing in the listener log.)
I know this is very little information, but Im hoping you can tell me what is trying to make these attempts so that we can change the parameters.
All that I know about the sessions are the time (3:45am or pm) and that the attempts are using the user we set up for spotlight- connecting as sysdba- probably coming directly from the server.
Spotlight on Oracle Predictive Diagnostics feature runs an Oracle job every 12 hours by default
WORKAROUND1 If the Predictive Diagnostics feature is not needed and the Oracle account used for Spotlight on Oracle is used only for Spotlight (and no other applications), drop cascade the Spotlight user then re-run the Spotlight Oracle User wizard to recreate the user and do not select the Predictive Diagnostics option. This way the Predictive Diagnostics objects are removed and the Predictive Diagnostics collection job will not run.
You can stop the jobs from running in the Option dialog.
In Spotlight v6.0 using the menu, click View Options | Spotlight on Oracle Professional | Data Collection.
In both tabs (SQL and Bottlenecks) change the Data Collection Interval to ZERO.
This will stop the jobs but the objects will still remain.