Forum Discussion

aspirationalbec's avatar
aspirationalbec
Frequent Visitor
1 year ago

ORA-12560: TNS:protocol adapter error

I am connecting Power BI to oracle database via odbc and a system dsn. Trying to add the data source to our on-prem gateway, I'm coming up with two errors: ODBC: ERROR [HY000] [Oracle][ODBC][Ora]OR...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi aspirationalbec -while connecting Power BI to an Oracle database via ODBC and a system DSN typically point to issues with the Oracle client configuration or the ODBC driver settings.

check once the tnsname.ora correctly configured and accessible by the Oracle client on the machine where the on-premises gateway is installed. The TNS names should match exactly what you are using in your ODBC connection.

Oracle Instant Client Downloads | Oracle India

Check if the Oracle environment variables (ORACLE_HOME and TNS_ADMIN) are set correctly on the gateway machine. The TNS_ADMIN variable should point to the directory containing the tnsnames.ora file.

firewall on the gateway machine is not blocking the Oracle listener port (default is 1521). 

 

hope this helps.

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Also, use tnsping if you have that installed.  That will tell you if the client is using the correct tnsnames.ora file.