NetXMS Support Forum

AH!!  Ok, got it.  Yea, I assumed the map coordinates would be the center of the map.  Now I understand.  

Map coordinates begin the map, starting from the top left. 

It is working now with below config:

ID = DB1
Name = <IPADDRESS>:<PORT NUMBER>/<SERVICE NAME>
Username = dbuser
Password = mypass123

I mean that coordinates set in map properties correspond to what's in the upper left corner of the map. So e.g. if I take latitude 51°30'N and longitude 0, I'll have London in the corner of my map.

I am not big expert in oracle stuff, but here's config that works for me (we can now use just subagent name withou .nsm, but it does not change anything):

SubAgent = oracle
[ORACLE]
ID = DB1
Name = //10.10.1.1/orcl.office.companyname.com
Username = user
Password = password

On 6-th level of debug the following lines are in agent log:

2024.05.29 12:19:33.495 *D* [db.drv.oracle      ] OCI version 19.9.0.0.0
2024.05.29 12:19:33.497 *D* [db.drv.oracle      ] OCI statement caching is ENABLED
2024.05.29 12:19:33.497 *I* [db.drv            ] Database driver "oracle.ddr" loaded and initialized successfully
2024.05.29 12:19:33.498 *D* [oracle            ] ORACLE: poller thread for database oracle started
2024.05.29 12:19:33.498 *I* [subagents          ] Subagent "ORACLE" (/opt/netxms-master/lib/netxms/oracle.nsm) loaded successfully (version 5.0.0-rc141)
2024.05.29 12:19:33.605 *D* [db.drv.oracle      ] Connected to Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
2024.05.29 12:19:33.605 *D* [db.conn            ] New DB connection opened: handle=0x7f083c08b100
2024.05.29 12:19:33.605 *D* [db.query          ] DB Library: long running query threshold for session 0x7f083c08b100 set to 5000
2024.05.29 12:19:33.610 *I* [oracle            ] Connection with database oracle restored (version 12.1, connection TTL 3600)

What it's saying for you in the line with db.drv.oracle tag?

Got it.   That works.  Thanks!  

Can you send a screenshot of "Map coordinates are set on the upper left corner" ?    I'm not sure if I'm missing something.

If I set the map coordinates in the properties, it refuses to even show me that part of the world. https://ibb.co/dbVqwM7
(please see map coordinates as they are set, vs the map that is displayed).     I can't even get my part of the world to load in the map view, at all... that's sort of my biggest problem.

Map coordinates are set on the upper left corner (this may change in the future, but that's how it currently is).

Geographical map acts only as a backdrop on network maps, there is no link with object geographical coordinates. There were thoughts to introduce network map type that would use objects coordinates, but we are not there yet.

There is, however a way to view devices positioned on a map - it's Tools->World map, or on devices which have geolocation entered there's Geolocation tab.

UI is a bit unclear, just enter 28 in the network mask field

Thanks for the '--with-oracle' suggestion. It worked.
Now, Oracle.DBInfo.IsReachable(DB1) is coming NO

SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = TEST
Username = dbuser
Password = "mypass123"
I also tried below config but that didn't work either.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
TnsName = TEST
Username = dbuser
Password = "mypass123"
I gave full connection string as below. Also didn't work.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = dbuser@//localhost:1521/TEST
Username = dbuser
Password = "mypass123"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Requesting metric "Oracle.DBInfo.IsReachable(DB1)"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] GetMetricValue("Oracle.DBInfo.IsReachable(DB1)"): 0 (SUCCESS) value = "NO"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Outgoing message dump:
  ** 000000 | 00 1D 50 00 00 00 00 30 00 00 05 3E 00 00 00 02 | ..P....0...>....
  ** 000010 | 00 00 00 1C 00 00 00 00 00 00 00 00 00 00 00 00 | ................
  ** 000020 | 00 00 00 15 07 00 00 00 00 00 00 02 4E 4F 00 00 | ............NO..
  ** code=0x001D (CMD_REQUEST_COMPLETED) version=5 flags=0x0000 id=1342 size=48 numFields=2
  ** 000000: [    28] INT32       0
  ** 000010: [    21] UTF8-STRING "NO"
Is there any difference between the INI formats of 4.5.0 and 5.x ? Id or ID? TnsName or Name?
Can't find Administration Guide for old versions.

Only confirmation. The upgrade was successfull now.
Thank you. Martin