Ad Widget

Collapse

First Time Oracle Connection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rpk113
    Junior Member
    • Jul 2016
    • 2

    #1

    First Time Oracle Connection

    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
    Junior Member
    • Jul 2016
    • 18

    #2
    Drivers and libraries working

    Originally posted by rpk113
    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.

    Comment

    • rpk113
      Junior Member
      • Jul 2016
      • 2

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

      Comment

      Working...