This site is in read only mode. Please continue to browse, but replying, likes, and other actions are disabled for now.

⚠️ We've moved!

Hi there!

To reduce project dependency on 3rd party paid services the StackStorm TSC has decided to move the Q/A from this forum to Github Discussions. This will make user experience better integrated with the native Github flow, as well as the questions closer to the community where they can provide answers.

Use 🔗 Github Discussions to ask your questions.

Unable to connect to oracle using sql pack

Platform Pack Management
#1

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.