Oracle ORA-25700 Transport Layer Secutiry (TLS) connection error

[lw24]

Hello, I've posted here about an issues I'm experiencing with Oracle connecting to Power BI... I'm looking for some guidance on the following and how to resolve this issue 

Oracle: ORA-25700: Current configuration does not use Transport Layer Security (TLS). Token based authentication requires TLS with server authentication.

I'm running Oracle Instant Client 21c and Power BI verion is 2.126. 

Thank you!

[lbendlin]

try with Oracle client 19

[lw24]

We have tried with Oracle 19. I was getting different error back then.... 

[v-kaiyue-msft]

Hi @lw24 ,

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.

[lw24]

Hi @v-kaiyue-msft - 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