Products | Versions |
---|---|
Spotfire Server | 7.5 and higher |
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
jdbc:oracle:thin:@//host_name:port_number/service_nameHence, the bootstrap command will look like the following:
>config.bat bootstrap --driver-class=oracle.jdbc.OracleDriver --database-url= "jdbc:oracle:thin:@//host_name:port_number/service_name" --username=spotuser --password=spotuser
>./config.sh bootstrap --driver-class=oracle.jdbc.OracleDriver --database-url= "jdbc:oracle:thin:@//host_name:port_number/service_name" --username=spotuser --password=spotuser