NetXMS Support Forum

English Support => General Support => Topic started by: madmucho on March 26, 2018, 02:57:23 PM

Title: Oracle Subagent windows server cannot load
Post by: madmucho on March 26, 2018, 02:57:23 PM
Dear Support team,
I have problem with oracle subagent, cannot load it correctly at agent side.

In config i have line Subagent = oracle.nsm 
But starting agent from comand line for check if loads correctly gives me
DB Library: Unable to load database driver module "oracle.ddr": %1 is not a valid Win32 application.

I have oracle.ddr and oracle.nsm files in bin directory after install, looks like it calls something from oracle client installation, which is installed and working on same win server as agent is.

Any hints what can be wrong or what is prerequirments on windows installation for oracle subagent to load correctly?

Netxms agnet 2.2.4
Oracle client 11.2.0
Title: Re: Oracle Subagent windows server cannot load
Post by: Victor Kirhenshtein on March 26, 2018, 05:36:03 PM
Hi,

oracle.ddr from Windows installer is built for Oracle client 12. You can use Oracle Instant Client - put it into NetXMS bin folder or add to system PATH.

Best regards,
Victor
Title: Re: Oracle Subagent windows server cannot load
Post by: madmucho on March 27, 2018, 03:12:14 PM
Quote from: Victor Kirhenshtein on March 26, 2018, 05:36:03 PM
Hi,

oracle.ddr from Windows installer is built for Oracle client 12. You can use Oracle Instant Client - put it into NetXMS bin folder or add to system PATH.

Best regards,
Victor

Thank you,
i copied content of instantclient-basic-windows.x64-11.2.0.4.0.zip to nxagent bin folder , set up credentials, copied tnsnames.ora to bin folder

*ORACLE
ID = USER
TNSName = XYZ.WORLD
Username = USER
Password = PASS

Connected and queries are retrieved, Working ok.

:)