I have created a sql.yaml to setup connection for oracle as below
connections:
oracle:
host: databaseIpAddress
username: username
password: password
database: dbServiceName
drivername: oracle
But, I am receiving error like
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-12505: TNS:listener does not currently know
of SID given in connect descriptor
(Background on this error at: http://sqlalche.me/e/14/4xp6)
how do i setup oracle connection correctly ? pl suuggest.