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!

[jeancosta2024]

I have found the solution to your problem. The error occurs because when you connect to the database, Oracle asks you to authenticate the information to connect to the database.

On this screen:

Autenticação do banco de dados.

You will need to enter the username and password you created in the database. If you have SQL Developer installed, you can easily view it.

If you have already connected to the bank and you get this error when you click on Update, do the following:

In Power BI go to Power Query -> at the top click on "Data source settings" -> click on the name of the database that has a cylinder icon, for example "testebase" or as written in yours. -> A window will open with "Credentials in bold" and below it "Type: Database" and below that there will be two options "Edit" or "Delete". -> Click on "Edit". -> When it opens, as in the picture above, go to "Database" and enter your bank username and password and that's it. Problem solved.

[lw24]

Appreciate the reply. The company I work for uses the "Microsoft Account" option here which connect us directly

When I try with the "Database"option this is the error message I get. Not sure I can work around this...

[lbendlin]

that's a "good"  error message. Check your Power Query or Oracle SQL code - somewhere you are referencing a table that is either not there or not visible to your user.

[lw24 · Accepted solution]

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!! 

[lbendlin]

try with Oracle client 19

[lw24]

Thanks @lbendlin . I tried this and now get this error? Oracle: ORA-25700: Current configuration does not use Transport Layer Security (TLS). Token based authentication requires TLS with server authentication. 

Do you know how to resolve?

[lw24]

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

[Anonymous]

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 @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