1 Reply Latest reply on Oct 5, 2018 8:54 AM by Jessica Tung

    Oracle connection works on Desktop 2018.2.0 but not Prep 2018.2.3 (error 12541)

    Jessica Tung

      Hi, I used the same credential for Desktop 2018.2.0 and Prep 2018.2.3.

      The connection worked on Desktop but not Prep.

      I made sure Prep driver was installed (instead of Desktop driver), restarted the machine, but still not working.

      1.png

      I also tried the port based on this page. (https://kb.tableau.com/articles/issue/troubleshooting-oracle-connection-errors#listener2 )

       

      Here is the error message I got.

      An error occurred while communicating with Oracle.

      Detailed Error Message

      Oracle database error 12541: ORA-12541: TNS:no listener

      Unable to connect to the server "xxxx". Check that the server is running and that you have access privileges to the requested database.

       

      Thank you for any input!

       

      -Jessica