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
MajedAK
Regular Visitor

Cannot Connect to Oracle Database

Hello everyone,

I'm quite new to Power BI and I'm working on a report and need to take data from an Oracle Database. I've downlaoded the Oracle Client for Microsoft Tools and installed it, but when I try to connect to the database on Power BI, I get the following error.

error.png

I've not been able to find solutions for this. Any help is appreciated.

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @MajedAK 

 

The error message "ORA-12541: TNS:no listener" typically indicates that Power BI cannot establish communication with the Oracle Listener when attempting to connect to an Oracle Database. This issue can be caused by several different factors:

 

  1. Listener Not Running: Ensure that the listener on the Oracle Database is running. You can check the status of the listener using Oracle's  'lsnrctl' command-line tool. If the listener is not running, it needs to be started.

  2. Network Issues: Confirm that your computer can access the server hosting the Oracle Database. There might be network connectivity issues, such as firewalls or incorrect network configurations, that are preventing the connection.

  3. Configuration Issues: Check the configuration of the 'tnsnames.ora' and 'listener.ora'  files. These files are located in the 'NETWORK/ADMIN' folder within your Oracle installation directory. Ensure that these configuration files correctly define the database service and that the listening port (usually 1521) is correct.

  4. Service Name: The service name entered in Power BI needs to match the service name defined in the 'tnsnames.ora' file. Make sure you are using the correct service name in your connection string.

  5. Port Number: Ensure that the port number used by the Oracle Listener (default is 1521) is open on the server and not blocked by a firewall.

  6. Oracle Client Version: Check if the version of the Oracle Client installed is compatible with the version of your database. Sometimes, incompatibility in versions can lead to connection issues.

If you are not the administrator of the database server, you may need to contact the administrator for assistance with this issue. The administrator can check the status of the listener, ensure that the network settings are correct, and that there are no firewalls or other network security tools blocking the connection.

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors