NetXMS Support Forum

Hello,

I am trying to configure the agent to perform a query with DBQuery on an Oracle database.

I must connect to Oracle with TNS name, and it works fine with sqlplus, but the agent allways gives the error:

ORA-12154: TNS:could not resolve the connect identifier specified

I'm running NetXMS on ubuntu server with mysql database, but I need to run queries on an Oracle database.

I allready do it in another setup I have in windows, but through ODBC.

Best regards.

Can you please show me some way to do it?

Hi,

try to use connect string in form //server_address/SID instead of TNS name.

Best regards,
Victor

Hi,

Thank you, it worked!

My only concern now is to be connected to only one server of a cluster. Any chance in the future to be able to connect by TNS name?

Again, thank you very much.

It should be able to use TNS names. Most likely it's client configuration or environment issue. Can you check what Oracle client is used by oracle.ddr?

Best regards,
Victor

I'm using the Oracle Instant Client 12.1 x64. It's the only one installed.

The sqlplus connects fine with TNS.

Best regards,
Manuel