Unable to connect to Oracle database - TNS error

[sanvaibhav75]

I have created a sql.yaml to setup connection for oracle as below
connections:
oracle:
host: databaseIpAddress
username: username
password: password
database: dbServiceName/databasename
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 suggest.

[gnudiff]

use just databasename in "database".
for example, i have in tnslistener.ora:

fancy_name =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MY_DB_IP )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SERVICE_XXX)
    )
  )

i use

host:  MY_DB_IP 
...
database: SERVICE_XXX

This works for me on Stackstorm 3.6.0