cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
XaviOV
Helper V
Helper V

Trouble connection to Oracle

Hello,

 

I want to connect to a database, but when I tried to connect I get this message -> Oracle: ORA-12170: TNS: Connection timed out.

 

When I put the server I have put mlxsga I already installed Oracle version 12.2.0, and the Network / Admin file there are two .txt (sqlnet and tsname).


File sqlnet:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

File tsname:
MLXSGA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mlxsga)
)
)


How can I connect to this database??

 

Thanks!!

 

Xavi

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @XaviOV 

 

The problem is that the Oracle service is running on a IP address, and the host is configured with another IP address.

You can reference the sovled question:oracle - ORA-12170: TNS:Connect timeout occurred - Stack Overflow

How to Resolve ORA-12170: TNS:Connect timeout occurred - Ed Chen Logic

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

View solution in original post

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @XaviOV 

 

The problem is that the Oracle service is running on a IP address, and the host is configured with another IP address.

You can reference the sovled question:oracle - ORA-12170: TNS:Connect timeout occurred - Stack Overflow

How to Resolve ORA-12170: TNS:Connect timeout occurred - Ed Chen Logic

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

View solution in original post

amitchandak
Super User IV
Super User IV

@XaviOV , Make sure the driver is installed, mentioned on this page

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database

 

And path of driver is added to windows environment variable



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors