Re: Cannot connect to one Oracle DB using JDBC



davis@xxxxxxxxxxxx wrote:
[SNIP]
The message I am getting looks like this

Driver: oracle.jdbc.driver.OracleDriver
Connecting to jdbc:oracle:thin:@db5.netaspx.com:1521:c0ujP0...
Driver registered: oracle.jdbc.driver.OracleDriver
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869824)
(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

I have a strange feeling of déja vu. We had similar questions in this
newsgroup back in September and October last year. Here'swhat I said back then:

Oracle error code 12505 means "TNS:listener could not resolve SID given
in connect descriptor".

Apparently, this means that the TNS listener service does not recognise
the service ID which you specified in your JDBC connection URL. Perhaps
you gave the wrong service ID? Or perhaps the Oracle instance has not
registered that service ID with the TNS listener?

Caveat: I'm *not* an Oracle expert!

David Harper
Cambridge, England
.



Relevant Pages

  • [Full-disclosure] Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Full-Disclosure)
  • Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Bugtraq)
  • RE: Oracle DB Audity
    ... For Oracle you have a few remote options. ... commands (if the default non-existent TNS Listener authentication model is ... techniques from a world-class research group. ...
    (Pen-Test)
  • RE: Oracle connect hangs forever
    ... While this process hangs, others are connecting ... Oracle version 10.2.0.1.0. ... and it is hanging on a read of fd 6, which is the Oracle tns listener. ...
    (perl.dbi.users)
  • Re: Mail merge filter
    ... Oracle is a database app, I think, but I don't know more than that. ... please post all follow-ups to the newsgroup so ... > Thanks for replying Suzanne. ... >> Microsoft MVP ...
    (microsoft.public.word.docmanagement)