Agent query to Oracle

[mrocha]

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?

[victor]

Hi,

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

Best regards,
Victor

[mrocha]

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.

[victor]

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

[mrocha]

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