cx_Oracle Connection Timeout

Question

I am trying to connect to Oracle database but getting below error:

curcon = cx_Oracle.connect(conn_str) cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred

Here's block of code:

conn_str = u'user/pwd@111.22.33.444:8000/service'
curcon = cx_Oracle.connect(conn_str) 
cursor = curcon.cursor()

I tried solutions from these two threads but none of them works:

Set database connection timeout in Python

ORA-12170: TNS:Connect timeout occurred

can you please check are you able to connect db form something like `dbeaver` or some other client. — Poojan, Oct 04 '19 at 19:15
Yes, I validated this multiple times as that was my first guess. But it works just fine from dbeaver and doesn't timeout. — django-unchained, Oct 04 '19 at 19:19

score 1 · Answer 1 · answered Feb 23 '21 at 20:17

If the error is occurring because of a slow network or system, you may fix the error by reconfiguring the following parameter in sqlnet.ora to larger values:

SQLNET.INBOUND_CONNECT_TIMEOUT = 0

Your sqlnet.ora file can be found in your $ORACLE_HOME/network/admin directory.

cx_Oracle Connection Timeout

1 Answers1

Linked