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
deepak416
Messages: 63
Registered: January 2013
Location: Pune
Member
Hi,
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@10.66.12.229:1521:OVPINHA
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..

-Thanks
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: 68625
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.
 *Action:
  - 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.

Regards
Michel
Re: JDBC connection error [message #593865 is a reply to message #593849] Wed, 21 August 2013 08:54 Go to previous message
BlackSwan
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: Fri Mar 29 02:07:35 CDT 2024