cx_Oracle Connection Timeout

2
votes

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/[email protected]: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

1
pythonpython-3.xoracle
can you please check are you able to connect db form something like dbeaver or some other client. - Poojan
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
Is database on same machine? - Karan Sethi
No, its on a different machine - django-unchained

1 Answers

0
votes

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.