java.sql.SQLException: Listener refused the connection
MarGurMay 20 2008 — edited Nov 20 2014Hi gurus, please help me to resolve the problem:
Exception:
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:
199.94.92.51:1521:pds1_TEST
Hi, I'm trying to create a jdbc thin connection from my oracle application server to my database server. There is a valid tns-entry in the place (on app server), i can tnsping my database, i can connect trough sql* from app server to database, but I cannot connect via jdbc.
all opnmctl startall processes are running.. what else should i check to fix it?
app server: oracle 10.1 application server on RHEL4
db server: oracle 10.2 database server on RHEL 4
Thanks beforehand.