SAM noob here,
I'm trying to set up a simple query to return a value (select count(*) from ent_flash_traffic_5min where create_date >= SYSDATE-15/1440). How do i go about creating a connection the database and what monitor template should I use?
http://www.solarwinds.com/documentation/en/flarehelp/sam/default.htm#OrionAPMPHComponentTypesSqlQA.htm?Highlight=SQL%20Monitors
How do I setup a connection to my oracle database in SAM?
Adding an Oracle Database Server to SAM
This document should answer everything you need to know about setting up Oracle User Experience Monitors in SAM
http://www.solarwinds.com/documentation/apm/docs/Configuring_and_Integrating_Oracle.pdf
Thanks for the information guys!!! I followed the to install the basic lite oracle client and on step 10 it has me shutdown everything. Everything stopped except for SolarWinds JMX Bridge. It's status says stopping but its been well over 15 minutes. I've tried start and stoping but the status doesn't change. Any ideas what i should try next?