Forum Discussion

apsaunders5's avatar
apsaunders5
Regular Visitor
8 years ago

Oracle DB connection

  I have read through the various threads on here to identify recommended steps, to no avail. I am trying to connect Power BI desktop to an oracle DB for reporting.    Power BI version: 2.55.5010....
FredTheFrog's avatar
FredTheFrog
Advocate I
8 years ago

From a command prompt, can you successfully TNSPING the SID name of the database?  If not, your tnsnames.ora file isn't configured correctly.  Once you can successfully TNSPING the SID name, then just put only the SID name in the form.  I'm currently using Oracle XE on my local laptop, and enterprise networked Oracle 12 at work, and they both connect quite simply and easily.

 

 C:\Users\FredTheFrog>tnsping XE
TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 02-MAR-2018 20:42:52
Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Fred)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)

C:\Users\FredTheFrog>