Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledgebase
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Krauss, Donald
  • Updated
Product:TIBCO Spotfire Server
Versions:All

Summary:
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.

Details:
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.


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>

Related articles

Comments

0 comments

Article is closed for comments.