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?
I would recommend opening Task Manager on the Orion server and killing (ending task) on the "jsl.exe" process
Thanks, that worked!
I think I'm almost there but I'm I have a question about part of the installation. Do these two additional components need to be install on the database or the server where SAM lives in?
SAM requires two additional components in order to monitor Oracle databases:
Oracle's Instant ClientSolarWinds Oracle Plug-in.
The steps below should result in a successfully tested and monitored database.
One of those ODBC drivers should be installed on the Orion server before you will be able to connect to an Oracle database server. You can use the SolarWinds Oracle Plug-in available in your Customer Portal, or download Oracle's Instant Client from Oracle's website.
I installed the Basic Lite Oracle Client. Should be good enough right? Still getting this TNS error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
This error can be seen when the listener has been started, but the database has not been started (yet) or automatic database service registration has not been performed (yet) or it has been disabled. Additionaly, the error can be returned when an incomplete or wrong service name is specified in the TNSNAMES.ora file or in the connector descriptor.
Note that a bad service name or a bad SID name in the tnsnames.ora file may easily lead to ORA-12514, however the fact you got ORA-12514 is a confirmation that at least the client could connect to the listener, because otherwise you'd get ORA-12541. The problem must be then either in the service name or in the associated database process.
The case of ORA-12514 may represent a special situation, where you provided the SERVICE_NAME including a valid domain, however the instance was not configured with the necessary initialization parameters (SERVICE_NAMES and/or DB_DOMAIN), resulting in ORA-12514. Note however that if you try to connect using the SID or you specify the SERVICE_NAME without the domain portion of it, the connection will succeed.
There can be also other situations. If the listener has been bounced or it has been started after the database, there could be a period of up to 60 seconds during which the database service is not known to the listener.
More detail explanations you can find here: http://oraclequirks.blogspot.com/2008/03/ora-12514-tnslistener-does-not.html.
Also you may try to use another 'Destination Point Type' monitor configuration option, for example choose 'SID' instead of 'SERVICE_NAME'.
Looks like the ODBC driver was installed but you have not configured the template with the SID or service name of your Oracle instance.
I get this error now after installing the full oracle client software on the solarwinds server. Any ideas?
Exception in Oracle provider: Exception has been thrown by the target of an invocation., Inner exception: Object reference not set to an instance of an object.
That error is returned by the Oracle driver itself, not by SAM. I would recommend uninstalling the Oracle client and use the Microsoft .NET Data Provider that can be downloaded from your Customer Portal
