Hi All,
We have a remote Oracle DB for which we were trying to access using jdbc connector and use oracle thin client to connect to the database.we tried with the below
URL: jdbc:oracle:thin@x.x.x.xSID
AND
URL: jdbc:oracle:thin@x.x.x.x:1521/SID
We were able to find the instance as CD12,CD14 using the query (select instance from v$thread;) and pass it as the above SID.
When we use :(colon before DB SID)
Fatal Error: The connector failed to connect to the data source. The reported error is: 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
When we use /(slash before DB SID)
Fatal Error: The connector failed to connect to the data source. The reported error is: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Kindly help us out to overcome this issue.
Thanks,
Satheesh.R
JDBC Connector issue while connecting Oracle Database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am