"ORA-12505TNS:listener does not currently know of SID given in connect descriptor" error is returned when connecting to an Oracle Database using the SERVICENAME in Spotfire Server

"ORA-12505TNS:listener does not currently know of SID given in connect descriptor" error is returned when connecting to an Oracle Database using the SERVICENAME in Spotfire Server

book

Article ID: KB0071059

calendar_today

Updated On:

Products Versions
Spotfire Server 7.5 and higher

Description

When creating a bootstrap file for the TIBCO Spotfire Server to connect to an Oracle database using a service name, it may throw the following error: 

   ORA-12505TNS:listener does not currently know of SID given in connect descriptor

Issue/Introduction

We may see the following error "ORA-12505TNS:listener does not currently know of SID given in connect descriptor" although we are using a SERVICENAME and not SID in the connection URL

Resolution

When using the SERVICENAME, the connection URL should be of the following format in the Spotfire configuration tool or in the bootstrap command (replace the host_name, port_number & the service_name in the example below with relevant values): 
jdbc:oracle:thin:@//host_name:port_number/service_name
Hence, the bootstrap command will look like the following:
  • TIBCO Spotfire Server on Windows:  
    >config.bat bootstrap --driver-class=oracle.jdbc.OracleDriver --database-url=
"jdbc:oracle:thin:@//host_name:port_number/service_name" --username=spotuser --password=spotuser
  • TIBCO Spotfire Server on Linux:  
    >./config.sh bootstrap --driver-class=oracle.jdbc.OracleDriver --database-url=
"jdbc:oracle:thin:@//host_name:port_number/service_name" --username=spotuser --password=spotuser

Additional Information

Doc: Database drivers and database connection URLs
Powered by Wolken Software