Hi, I am using agent v4 to monitor Oracle 10g. I have a few questions:
#1 The TNS listener was not auto detected. Is this normal? #2 I want to manually add the TNS listener as a service. Do I give the complete path in the tnslistener field, like: C:\oraclexe\app\oracle\product\10.2.0\server\BIN\TNSLSNR ? #3 In one of the services, I see a "Logons Current (active)" metric. Does this give the number of logons for all the users? Or is it only for the user that HQ uses to track oracle? If it is the latter, how do I track the total concurrent logons? I see that I can add a new "User instance". My guess is that if I create a service for every user then I'll get the number of concurrent sessions for every user. But, for this I'll have to manually add all the users. Is there a better way (since I only want the total and not the per-user number)?
TNS Ping is done by calling 'tnsping' through script included in hq-plugin.xml. This script is meant to be used in unix. This service is not marked as plain unix service on xml file, but I don't see how it could work on windows.
Janne wrote: > TNS Ping is done by calling 'tnsping' through script included in hq-plugin.xml. This script is meant to be used in unix. This service is not marked as plain unix service on xml file, but I don't see how it could work on windows. >
Will it work on Linux? How do I configure it for that?
Janne wrote: > I should work if you install oracle client libraries and programs to your linux box. If you can 'tnsping' from your linux system, HQ should be able to do it. > Thanks for your reply. How do I configure this service properly? I see a text box in the config settings called tns listener. What am I supposed to put in here?
First the same user which is running hq agent needs to be able to run tnsping succesfully. Oracle db id is given tnsping as argument, like 'tnsping ORADB1'. This ORADB1 needs to be same as found from YOUR oracle tnsnames.ora.
This ORADB1 is your 'listener' name and is the one what can be used in HQ. Also remember that tnsping need ORACLE_HOME environment variable to your oracle installation.