• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Using oracle conn. manager - connection refused

 
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Instead of using RMI to connect an applet to a remote database, my dba installed Oracle Connection Manager on the web host, and I am now trying to connect to it from the applet as described at Cman.

Here is my connection string:


Where webhost, dbhost, mydomain have been replaced with values specific to my company.

When ever the applet attempts to connect to the database, I get a error, with error code 12504. As I understand it, this error code means that I didn't supply the sid as part of my connection string.

According to the oracle documentation on the configuration syntax, it's this:


For the SRV parameter, it goes on to say:


SRV: Specify database service name of the Oracle9i or Oracle8i database... or Oracle System Identifier (SID) value of the pre-release 8.1 database



We are using Oracle8i, so we specified the service name. Our service name is the name of the webhost followed by a hyphen followed by the sid, so webhost-testdb. In addition to the connection string above, I have also tried the following connect_data values:


Any suggestions would be appreciated.

Deb
 
"How many licks ..." - I think all of this dog's research starts with these words. Tasty tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic