Forum Discussion

jm1's avatar
jm1
Occasional Contributor
3 years ago

Error Connection Oracle DB (SQLDeveloper 12.1.0.2.0) to ReadyAPI

Hello,  I have been trying to connect to an Oracle DB for some time. I have tried quite a few different drivers adding them to my bin folder and always end up with a similar error for example: Fai...
jm1's avatar
jm1
Occasional Contributor
3 years ago

Hello nmrao 

If I understand you correctly. 

I can and have been connecting to the DB through SQL Developer through SID and not service name. However, doing the same with ReadyAPI has not yet worked for me which is my current issue. I have read though your insightful link about SID vs Service name but still am unsure where to proceed.  

Thanks.

  • nmrao's avatar
    nmrao
    Icon for Champion Level 2 rankChampion Level 2
    3 years ago
    If same connection string or connection details worked from SQL Developer
    of your machine, then i don't see why ReadyAPI failing to connect. Strange.
    • jm1's avatar
      jm1
      Occasional Contributor
      3 years ago

      Hello nmrao 

      Could this still be a driver/version issue?

      I am unsure what other reasoning there could be if my connection details are correct and working for Oracle SQL Developer. 

      Thanks!

  • KarelHusa's avatar
    KarelHusa
    Super Contributor
    3 years ago

    jm1,

    if you are still getting the ORA-12514 error most probable cause seems to be some difference in your configuration. Often it's some tiny detail that can be easily overlooked.

     

    Regarding the version mismatch, could you check your target database version (not the SQL Developer version) and compare it with the list of supported DB versions by ojdbc11?