Hello,
I installed oracle instant client on solarwinds main pooling engine and APE by following the document below.(I installed under the agent path.)
support.solarwinds.com/.../Use-the-SAM-Oracle-Database-template-and-Oracle-User-Experience-monitor-without-ODBC
Then I set the necessary enviroment variables and restarted the Solarwinds server. I did a connection test with SQL*PLUS and I can connect. However, when I configure the component via Solarwinds UI, I got the following error.
‘Oracle returned an error. ORA-12541: TNS:no listener’
I took the application to debug mode and examined it a little and saw that it uses 127.0.0.0.1, that is, localhost as host. In other words, solarwinds does not use the tnsnames.ora connection file that I actually created. And it tries to access the db through the server I assigned the application. (I assigned the application to the main pooling engine.) How can I prevent this? How can I ensure that solarwinds uses the tnsnames.ora file?
Does anyone have any experience in this subject before?
When I examined the document below, I realised that they added the oracle db as a node to solarwinds and assing the application to the server where the oracle db is located. But this is ridiculous, since I do not want to monitor the oracle db server, I am already trying to install oracle instant client and monitor it via pooling engine. Do you have any comments on this?
https://documentation.solarwinds.com/en/success_center/sam/content/sam-oracle-user-experience-monitor-sw3275.htm
