Home » RDBMS Server » Networking and Gateways » JDBC connection error (Red Hat, Oracle ODA)
JDBC connection error [message #593845] Wed, 21 August 2013 08:10 Go to next message
Messages: 63
Registered: January 2013
Location: Pune
I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.

URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

Any suggestion pls..

Re: JDBC connection error [message #593849 is a reply to message #593845] Wed, 21 August 2013 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 67885
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *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.
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.

Re: JDBC connection error [message #593865 is a reply to message #593849] Wed, 21 August 2013 08:54 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
- Check for an event in the listener.log file.
post excerpt from listener.log file showing 12505 status code plus a few lines above & below ir
Previous Topic: nText columns not showing up in SELECT
Next Topic: about port number
Goto Forum:

Current Time: Sun Jun 20 14:47:21 CDT 2021