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

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

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 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

Doc: Database drivers and database connection URLs

• https://docs.tibco.com/pub/spotfire_server/10.3.4/doc/html/TIB_sfire_server_tsas_admin_help/GUID-1E0517F4-9C0C-4C75-A8E3-7FA69B7947FF.html