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/[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

Answer 1

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.