Oracle database error 12514: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

11,728

Here is an article from tableau which suggests that the ORA-12514 error occurs when SERVICE value is incorrect.

To resolve this issue, find out what the correct SERVICE value is, open the TNSNames.ora file located in your %ORACLE_HOME%\network\admin\ folder. Refer to the steps under ORA_12154 if necessary.

Share:
11,728
MurugananthamS
Author by

MurugananthamS

I'm a software developer, coding Android(java,kotlin) mostly. Recently learning developing Java web application using spring boot and learning Tableau Data analysis.

Updated on June 04, 2022

Comments

  • MurugananthamS
    MurugananthamS almost 2 years

    Now I am using Tableau business intelligence tool for data visualization,i tried to connect Oracle database with tableau,at that time i got below Error'

     Unable to connect to the server. Check that the server is running and that 
     you have access privileges to the requested database.
    
     Oracle database error 12514: ORA-12514: TNS:listener does not currently 
      know of service requested in connect descriptor
    
     Unable to connect to the Oracle server "192.176.10.145". Check that the 
     server is running and that you have access privileges to the requested 
    database.
    

    in what mistake i did,kindly help me out ,give any suggestion to resolve this

  • MurugananthamS
    MurugananthamS about 5 years
    i will try and let you know,thanks for your response,if the question is valid one please aprriciate with your upvote @Daniel Sims
  • MonteCarloSims
    MonteCarloSims about 5 years
    Appreciated. Just a quick note - the error in your title name differs from that in the error message.
  • MurugananthamS
    MurugananthamS about 5 years
    yes corrected title,and your answer is correct,thank you @Daniel Sims