I am trying to connect from a Python client, but seeing this error intermittently
(oracledb.exceptions.DatabaseError) DPY-4011: the database or network closed the connection
Code that I am using:
from sqlalchemy import create_engine
import sys
oracledb.version = "8.3.0"
sys.modules["cx_Oracle"] = oracledb
engine = create_engine(
f'oracle://:@',
connect_args={
"user": username,
"password": password,
"host": host,
"port": port,
"service_name": service_name,
"protocol": "tcps",
})
engine.connect()