DX Unified Infrastructure Management

Hi Everyone,

How can I configure the sql_response probe to execute query in Oracle database?

Hi Martin, 

Have you had a chance to look at sql_response documentation:

sql_response AC Configuration - CA Unified Infrastructure Management Probes - CA Technologies Documentation 

Please let us know if it is not clear, or if you have any specific questions.

Regards

Anu

Hi Anu, Thanks for your answer. Can you tell me if I need to install a new drive? Where and how can I specify the port?

Carlos,

Not sure what is meant by a 'new drive', and as for the port, it does not have a place to specify a port.

sql_response is limited, for more complete monitoring consider the oracle probe.

oracle (Oracle Database Monitoring) - CA Unified Infrastructure Management Probes - CA Technologies Documentation 

This is some what depended on the OS type and version you install the sql_response probe on.

So if you install the sql_response probe on a windows machine, Download oracle client for windows, setup an ODBC connection to the oracle database you can then use that connection in the sql_response probe to run queries.

below is a connection string information for creating an OLEDB connection string to oracle as well.

Oracle Provider for OLE DB Connection Strings - ConnectionStrings.com 

Microsoft OLE DB Provider for Oracle Connection Strings - ConnectionStrings.com 

but you should be able to do this without too much trouble.