Oracle Error: "ORA-12505 Connection refused, the specified SID (;SID_NAME;) was not recognized by the Oracle server while connecting to Oracle Database" when connecting from TIBCO Spotfire

Oracle Error: "ORA-12505 Connection refused, the specified SID (;SID_NAME;) was not recognized by the Oracle server while connecting to Oracle Database" when connecting from TIBCO Spotfire

book

Article ID: KB0071058

calendar_today

Updated On:

Products Versions
Spotfire Server All

Description

Resolving ORA error received while connecting to Oracle Database.
 
ORA-12505 Connection refused, the specified SID (<SID_NAME>) was not recognized by the Oracle server.
OR
ORA-12505TNS:listener does not currently know of SID given in connect descriptor.

Symptoms:
While connecting to Oracle Database through Information Designer or while creating a bootstrap file for Spotfire Database on Oracle, users see the following ORA error: 

ORA-12505 Connection refused, the specified SID (<SID_NAME>) was not recognized by the Oracle server.
OR
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.

Cause:
There can be two causes for this error:
 
1). Incorrect SID name or Oracle Listener has not configured for the specified SID.
2). Listener is configured for Service Name not the SID.

Issue/Introduction

Oracle Error: "ORA-12505 Connection refused, the specified SID (;SID_NAME;) was not recognized by the Oracle server while connecting to Oracle Database" when connecting from TIBCO Spotfire.

Resolution

 
Resolution 1). Confirm with the Oracle DBA the correct SID. Use the "tnsping" command to check the DB status.
Resolution 2): Modify the connection URL to use the Service Name instead of the SID. If the listener is configured for Service Name then use the following connection URL:
jdbc:oracle:thin:@hostname:1521/<service_name> 
Connection URLs for Oracle Native JDBC Driver
---------------------------------------------------------------------
For SID: jdbc:oracle:thin:@hostname:1521:<SID>  
for Service Name: jdbc:oracle:thin:@hostname:1521/<ServiceName>
The connection URL for Oracle DataDirect Driver
----------------------------------------------------------------------
For SID: jdbc:tibcosoftwareinc:oracle://<host>:<port1521>;SID=<sid>
For Service Name: jdbc:tibcosoftwareinc:oracle://<host>:<port1521>;ServiceName=<ServiceName>

Additional Information

Powered by Wolken Software