Our listener for the Oracle database quit working around 3pm. We don't know if Spotlight killed the listener or the listener died and then Spotlight tried to connect but could not.
We started the listener back around 4pm and need to know how Spotlight gets information from the database. Does it connect and stay connected, getting data from the database throughout the day (ie once connect that stays live with the database; therefore, only one connection through the listener), or does it connect and then reconnect each time it polls the database for data.
oracle bug
Essentially Spotlight makes just one connection and it stays connected through the life of the Spotlight session. If the user goes into Top Sessions, the user will see the Spotlight connection using the single Session ID (SID).
There is another scenario where a second session is temporarily connected; for example, when performing an Explain Plan, a separate connection will be made, but Spotlight mostly uses a single permanently connected session.
However, A listener crash is by definition the result of an Oracle bug. We have had no record of Spotlight causing a listener crash in the 10 years of its product life. If the problem re-occurs, one would expect that the user would report it to Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center