Forum Discussion
Oracle ORA-25700 Transport Layer Secutiry (TLS) connection error
correct! yeah it was an issue with company system. We all switched to 21c instant client, connectied via database option and it appears to be working!!
Hi Anonymous ,
I want to acknowledge valuable input provided by lbendlin . However, I noticed that more details are needed to fully understand this issue.
1. If you are using the market version of Power Bi Desktop and receive this error, try the following:
In the oracle client home directory you should be able to find oraons.dll. Copy this file to the \bin folder in the same directory.
Close any open Power BI Desktop and reopen it.
You should be able to connect now.
For example, the directory of files is:
c:\app\client\OraHome
copy it to
c:\app\client\OraHome\bin
2. Here are some solutions related to your problem, I hope they can be helpful to you.
Solved: Re: PowerBI desktop 64Bit oracle connection error ... - Microsoft Fabric Community
Solved: PowerBI desktop 64Bit oracle connection error Obj... - Microsoft Fabric Community
Solved: Oracle: Object reference not set to an instance of... - Microsoft Fabric Community
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous - really appreciate the reply and resources!
Looks like the suggestions are for error "Object reference not set to an instance of an object"?? The file you mentioned above, oraons.dll, is already in the /bin folder.
Because I downloaded 21c, I was able to bypass that issue (possibly) and now see this one "Current configuration does not use Transport Layer Security (TLS). Token based authentication requires TLS with server authentication."
Possibly an issue with 21c this is my folder structure.... might need to uninstall one of the versions?
C:\Oracle\Product
C:\Oracle\Product\21.12.0\instantclient_64
C:\Oracle\Product\21.12.0\instantclient_64\network
C:\Oracle\Product\21.12.0\instantclient_64\network\admin