-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
Yes,
as a client install you'll have 2 programs installed.
tnsping
sqlplus
tnsping only test the connection to the listener.
For configuration you should have a sqlnet.ora file, and if no naming
servers/services are available then you'll also have a tnsnames.ora file.
Both files live in the $ORACLE_HOME/network/admin directory.
If you can tnsping, then you can use sqlplus to connect to the database.
Generally when debuging a connection to Orace start with the following
steps:
1. ping the host running the Oracle RDBMS
2. tnsping the tns_alias verifying the listener is responding.
3. sqlplus to connect to the database (you can then try your SQL directly).
Good luck,
Thor HW
----- Original Message -----
From: Rodrigo Zerlotti <[EMAIL PROTECTED]>
To: Java Apache Users <[EMAIL PROTECTED]>
Sent: Friday, September 03, 1999 11:29 AM
Subject: oracle oci8 trying to get it to work.. not solve yet....
> -----------------------------
> Please read the FAQ!
> <http://java.apache.org/faq/>
> -----------------------------
>
> Hi,
> I tried all the steps described on the past 6 emails, but I still can
> not get Oracle OCI to work. Thin JDBC works just fine....
> Is there a way I can test if I have all the files installed for
> Oracle(client), that are needed by the Oci driver? My sysadmin did the
> Oracle install, but I ma not user if we have all....
>
> I am using oracle 8.04 (we are updating to 8.05) and I am using the latest
> drivers downloaded from oracle. Here the error:
>
> java.lang.UnsatisfiedLinkError: no ocijdbc8 in shared library path
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:341)
> at org.apache.jserv.JServConnection.run(JServConnection.java:197)
> at java.lang.Thread.run(Thread.java)
>
> I have LD_LIBRARY_PATH and all the other env variables set on
> jserv.properties. And libocijdbc8.so is on LD_LIBRARY_PATH.....
>
> Any help will be greatly appreciated.
>
> Rodrigo
>
> [EMAIL PROTECTED] wrote:
>
> > -----------------------------
> > Please read the FAQ!
> > <http://java.apache.org/faq/>
> > -----------------------------
> >
> > thanks for all the replies to my question. now it works.
> >
> > After applying all solutions and drop one by one, I
> > found that "jserv.properties" has to include: (enough and necessary)
> > wrapper.classpath=...
> > wrapper.env=LD_LIBRARY_PATH=....
> > wrapper.env=ORACLE_HOME=...
> > (ORACLE_HOME is critical.).
> >
> > That's all for my setup, on condition that your standalone java
> > application works fine
> > already in the environment where you start apachectl.
> >
> > have a nice weekends, /wenbo
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, September 03, 1999 1:58 PM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: oracle oci8 jdbc on jserv fails to get connection, ...
> >
> > -----------------------------
> > Please read the FAQ!
> > <http://java.apache.org/faq/>
> > -----------------------------
> >
> > Hi,
> > On Fri, 3 Sep 1999 [EMAIL PROTECTED] wrote:
> > | I check the log file for my servlet. it said that jdbc shared library
> > | for ocijdbc driver is not found. In fact, it's setup to
> > | LD_LIBRARY_PATH=$ORACLE_HOME/jdbc/lib
> > In my setup, its sufficient to have the LD_LIBRARY_PATH defined in the
> > apache environment, that is, in apachectl:
> > export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/Oracle/lib
> >
> > In jserv.properties, you need to set the classpath that contains the
> > jdbc-driver:
> > wrapper.classpath=/path/to/oracle/jdbc/driver.jar
> > _AND_ the location of ORACLE_HOME as environment:
> > wrapper.env=ORACLE_HOME=/my/oracle/home
> > Seems, that the Oracle driver needs this to lookup its message files
> > etc.
> >
> > hope this helps,
> > -hen
> > ---
> > Henner Zeller [EMAIL PROTECTED]
> > PGP pub key [77F75B39]: finger [EMAIL PROTECTED]
> >
> > If Microsoft is the answer, it must have been a VERY silly question.
> >
> > --
> > --------------------------------------------------------------
> > Please read the FAQ! <http://java.apache.org/faq/>
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Archives and Other: <http://java.apache.org/main/mail.html>
> > Problems?: [EMAIL PROTECTED]
> >
> > --
> > --------------------------------------------------------------
> > Please read the FAQ! <http://java.apache.org/faq/>
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Archives and Other: <http://java.apache.org/main/mail.html>
> > Problems?: [EMAIL PROTECTED]
>
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
