Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Joorge_C
Resolver II
Resolver II

Desktop refresh error: Oracle: ORA-12569: TNS:packet checksum failure

Hi All,

Anyone has seen this error in the past? ..trying to refresh a dashboard with Oracle Database.

I have already installed Oracle ODAC and continue to get the error.

 

Error:   Oracle: ORA-12569: TNS:packet checksum failure

 

Any thoughts?

Thanks!!

6 REPLIES 6
V-pazhen-msft
Community Support
Community Support

@Joorge_C 

 

This is a oracle database error rather than power bi. The data received is not the same as the data sent: follow the suggested actions:

ORA-12569: TNS:packet checksum failure - Oracle 10.2 to MySQL 5.0 (wmlcloud.com)

Oracle 12cR1 ORA-12569 TNS:packet checksum failure - ORA-12569 (oraexcel.com)

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Thanks @V-pazhen-msft 

The issue is, I have tested the connection on a whole brand new dashboar.

When I select get data, I get the same error. How can the data be in a different format if its a whole brand new connection set up?

 

Thanks again!

amitchandak
Super User
Super User

@Joorge_C , Have added the oracle driver install directory into the Environment path of Windows

Thanks @amitchandak 

So when the installation is completed, it is not added into the program files folder paths?

Or perhaps Im not selecting the right path?

Sorry Im a lil confused

oracle.png

@Joorge_C , Windows, Env Path 

 

For me it only worked, after I added the path 

Screenshot 2021-02-04 08.11.09.pngpath.PNG

Thanks @amitchandak feel like Im almost there, I have installed it in this two locations after seeing the same error Oracle: ORA-12569: TNS:packet checksum failure"

Any other ideas?

oracle2.png

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.