Forum Discussion
Helper VTrouble 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
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.
2 Replies
- amitchandak
Super User
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
- v-janeyg-msft
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.
