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:
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
