[WARN ] ORACLE: no databases to monitor, exiting -ORACLE Subagent problem

[maciek_ml]

Hi All

I have a problem to configure Subagent for Oracle database  - after startup it seems not connect to database
[19-Nov-2014 15:59:36.998] Log file opened
[19-Nov-2014 15:59:36.998] [INFO ] Additional configs was loaded from /etc/nxagentd.conf.d
[19-Nov-2014 15:59:36.998] [INFO ] Debug level set to 0
[19-Nov-2014 15:59:38.002] [INFO ] Subagent "linux.nsm" loaded successfully
[19-Nov-2014 15:59:38.015] [INFO ] DB Library: Database driver "oracle.ddr" loaded and initialized successfully
[19-Nov-2014 15:59:38.015] [WARN ] ORACLE: no databases to monitor, exiting
[19-Nov-2014 15:59:38.015] [ERROR] Initialization of subagent "/opt/netxms/lib/netxms/oracle.nsm" failed
[19-Nov-2014 15:59:39.016] [INFO ] Listening on socket 0.0.0.0:4700
[19-Nov-2014 15:59:40.018] [INFO ] NetXMS Agent started

I have  prepared only one instance so applied it on nxagentd.conf  ( config bellow)

SubAgent=/opt/netxms/lib/netxms/oracle.nsm
DBDriver=/opt/netxms/lib/netxms/dbdrv/oracle.ddr
*oracle
DBServer = 172.29.10.149:1549/NTS8
DBName = NTS8
DBLogin = apps
DBPassword = apps
DebugLevel=0

+++
OS - Centos ,
DB - 11g  on HPUX  - external machine

----

cheers
Maciek

[victor]

Hi,

you are using wrong configuration parameters. Correct will be

ID = NTS8
Name = 172.29.10.149:1549/NTS8
Username= apps
Password = apps

ID is an arbitrary string. You will use it in parameters, like this:

Oracle.Cursors.Count(NTS8)

See Oracle subagent documentation for more information: https://www.netxms.org/documentation/adminguide/subagents.html#oracle

Best regards,
Victor

[maciek_ml]

Hi Victor

It seems too working as well.
great thank you

Maciek