Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Oracle Error: "ORA-12505 Connection refused, the specified SID (;SID_NAME;) was not recognized by the Oracle server while connecting to Oracle Database".
Solution:
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 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/<serivce_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> | |||
Comments
0 comments
Article is closed for comments.