Trouble connection to Oracle

[XaviOV]

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

[v-janeyg-msft · Accepted solution]

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.

[amitchandak]

@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