Forum Discussion
Oracle ORA-25700 Transport Layer Secutiry (TLS) connection error
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!
9 Replies
try with Oracle client 19
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\bin2. 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.
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?
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.
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.
