First Time Oracle Connection

[rpk113]

I've read all the threads and set the variables.. no clue why my server wont connect to the DB..

Error Message
31315:20160712:140343.760 [Z3001] connection to database '//<IP Address>:49125/MDP_ZABBIX' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

LD_LIBRARY_PATH=/oracledb/client/11.2.0.4/exec/lib:
ORACLE_BASE=/oracledb/client/11.2.0.4
ORACLE_HOME=/oracledb/client/11.2.0.4/exec
PATH=/oracledb/client/11.2.0.4/exec/bin

I can connect to the DB via Squirrel but not the server. any ideas?

[valegator]

Drivers and libraries working

Error Message
31315:20160712:140343.760 [Z3001] connection to database '//<IP Address>:49125/MDP_ZABBIX' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The fact that you got an answer from the listener indicated that you don't have problems with libraries, drivers or similar since the error message would look alot different then.
This error usually occurs when you specify none or invalid database name. Did you specify the correct database name in the odbc.ini file as documented in https://www.zabbix.com/documentation...uring_unixodbc ?

What you can do on Oracle side:
- Check which services are currently known by the listener by executing: lsnrctl services <listener name>
- Check for an event in the listener.log file.

[rpk113]

Thanks for the response, I was using the wrong servicename of the DB. once I had that all was good..