Product:TIBCO Spotfire Server
Versions:7.5 and higher
Summary:
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
Details:
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
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):
Versions:7.5 and higher
Summary:
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
Details:
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
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_nameHence, 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