Using Oracle as Arcadia Visualization server metadata DB (TNS-12505: TNS:listener does not currently know of SID given in connect descriptor)

When using Oracle as the viz server metadata DB you generally want to use the SERVICE NAME instead of SID.

But within Arcadia you might hit error around SID not found
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

This is because by default Arcadia will use SID. Ideally with Django we specify the NAME as the full service name with host information & port. https://stackoverflow.com/questions/19246643/how-do-i-force-django-to-connect-to-oracle-using-service-name

To get around that we can override the setting in Arcadia safety valve within Cloudera Manager as shown here:

DATABASES['default']['HOST']=''
DATABASES['default']['PORT']=''
DATABASES['default']['NAME']='host.db.com:1699/oracle_service.db.com'

1 Like