Forum Discussion
Oracle Data Source "Oracle: ORA-01005: null password given; logon denied"
Hello All,
I'm trying to connect to an Oracle Data Source but it never works.
It's giving me ORA-01005: null password given; logon denied
but I was never asked for a username password. I reinstalled Power BI and I still have the same issue.
Any suggetions ?
Eric
Found the solution
#1:
Make sure you have installed:https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
[Released October 5, 2015]
Download ODAC121024_x64.zip - 287 MB (301,348,751 bytes)#2:
Make sure your TNS Name file (tnsnames.ora) is correct
Test with Toad or other SQL Utility that uses the TNS NAME file
not SQL Developer (that does not use the tnsnames.ora file to Connect)
C:\app\client\your_windows_user_name\product\12.1.0\client_1\Network\Admin#3:
In the Power BI Get Data Oracle databaseIn the box Server:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=service_name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))#4:
Use the database credentials to access your dataThat's it, hope it helps someone.
Eric
1 Reply
Found the solution
#1:
Make sure you have installed:https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
[Released October 5, 2015]
Download ODAC121024_x64.zip - 287 MB (301,348,751 bytes)#2:
Make sure your TNS Name file (tnsnames.ora) is correct
Test with Toad or other SQL Utility that uses the TNS NAME file
not SQL Developer (that does not use the tnsnames.ora file to Connect)
C:\app\client\your_windows_user_name\product\12.1.0\client_1\Network\Admin#3:
In the Power BI Get Data Oracle databaseIn the box Server:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=service_name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))#4:
Use the database credentials to access your dataThat's it, hope it helps someone.
Eric