Configuring Oracle for JDBC

Giganews Newsgroups
Subject: Configuring Oracle for JDBC
Posted by:  jme…
Date: 27 Aug 2006

Configuring Oracle for JDBC

I am trying to set up a Linux (I am using Fedora Core 4) server with
Oracle 10g on it but can't seem to be able to connect to it using
JDBC.  I don't know how to get my machine to respond to a specific
name, but can ssh into it from within my own network by using:

ssh jme…@

so I am trying the same with my JDBC connection string:


I modified the listener.ora file to


and started this service using lsnrctl.  I still get a "The Network
Adapter could not establish the connection" error though.

The problem may be in the DB setup though, as I can't login even using
sqlplus from accounts that are not part of the 'oinstall' &
'dbus' groups.  The 'oinstall' group gives too many permissions, so I
shouldn't give this out to other users and anyway I don't know if
a JDBC connection even assumes any particular user profile.

Any input would be appreciated.