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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Problem connecting with Oracle Database

Hello!

 

I can connect to Oracle database with Oracle SQL Developer but, when i try to connect with Power BI, whit same TNSNAMES.ora configuration i get this error:

ORA-12638: Credential retrieval failed.

 

I try to connect whit this tnsnames:

Prod =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = XXXX)
)
)

 

¿Can you help me?

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Please try to change the entry to "SQLNET.AUTHENTICATION_SERVICES= (NONE)"

Best Regards,

Teige

View solution in original post

5 REPLIES 5
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Please try to change the entry to "SQLNET.AUTHENTICATION_SERVICES= (NONE)"

Best Regards,

Teige

I am having the same issue.  

I made the change to SQLNET.AUTHENTICATION_SERVICES= (NONE) but this didn't help.

 

Any other ideas?

 

Anonymous
Not applicable

Yes! I try it last night and fine!!!! 

 

THX!!!!

TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Could you please tell us which connector and driver did you use to connect to Oracle?

Best Regards,

Teige

Anonymous
Not applicable

Thx for your interest, @TeigeGao 

 

I use the last version of ODAC, 12c (12.2.0.1).

I try with 32 and 64 bits versions.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors