Troubleshooting
Problem
We received the following error message after we click the "Test Database Connection" button in FileNet Configuration Manager for creating a new data source.
DSRA8040I: Failed to connect to the DataSource. Encountered java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
Symptom
The following error message pops up after click "Test Database Connection"
Cause
The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener, specified a SID for an instance (usually a database instance), that either has not yet dynamically registered with the listener, or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Environment
Oracle 10g, Windows 2008
Diagnosing The Problem
1. Review the data source information in the "Configure GCD JDBC Datasources" task for FileNET Configuration Manager.
2. Make sure you are able to successfully connect to the database via SqlPlus
3. Make sure tnsping is able to resolve the database name.
Resolving The Problem
Based on the output of tnsping, it's shown that the SID of the database instance should be s0bd. Therefore, the problem is resolved after replacing the database name from rimd to s0bd in data source configuration
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21962241