I have successfully configured monitors for monitoring windows/iis but I would like to monitor the oracle db as well.

I've been having problems getting the connection check to succeed. It comes back with connection failed: java.sql.SQLR|ecoverableException IO Error: The network adapter could not establish the connection.

Can you confirm what details are required. I am attempting to connect using the classic mode

Under Oracle Db Monitor Configuration I am entering
Name oracledbMonitor (I'm assuming this is just a name you see in the list of monitors
hostname (name of the server where my application being load testsed is running)
Database - the database name

Authentication
Login: I assume this is the schema name
Password schema password.

I guess I want to check that the username and password are those relating to the db and not my windows credentials.

Should the hostname be the physical server where the db resides or is it sufficient to have e.g a webserver hostname where that webserver has oracle client installed and the relevant TNS NAMES/ LDAP.

Any ideas how to diagnose if this is a firewall issue?