Re: Error with OCI8 driver installing sendmail/javamail

nick048 wrote:
> Hi to All,
>
> >From Dos window I run the command:
> loadjava -user sys/pwd_at_name_db -resolve -synonym activation.jar
>
> This is the first step in order to install a Sendmail package based on
> javamail, but I have this error:
>
> =============================
> Java.exe error
>
> Impossible to find the enterpoint kpufhndl0 of procedure in the library
> of dynamic link OCI.dll (Sorry, this is a translation of italian
> language)
> OK
> =============================
>
> After I click on OK and this is the next response:
>
> Error while connecting with OCI8 driver to
> namedb:oracle.aurora.server.tools.loadjava.ToolsException: The JDBC
> OCI8 Driver is not installed properly, use -thin to try the JDBC Thin
> Driver: C:\oracle\product\10.2.0\oradb10g\BIN\ocijdbc10.dll: Impossible
> to find the specified procedure.
> exiting: could not open connection
>

This means that you don't have OCI JDBC driver installed properly on the machine where you invoked loadjava. loadjava suggested that you try Thin JDBC driver.

> After, I have used the command:
> loadjava -thin C:\oracle\product\10.2.0\oradb10g\BIN\ocijdbc10.dll
>

...and you should've used

loadjava -thin user/password_at_db_name -resolve -synonym activation.jar

The command you gave is nonsense and loadjava reacted accordingly - it used default localhost:1521:ORCL connection and if it were to succeed connecting, it would try to load the DLL file you specified.

> This is the result:
>
> SQL error while connecting with driver to default database: Listener
> refused the connection with the following error:
> ORA-12505, TNS: listener does not currently know of SID given in
> connect descriptor
> The connection descriptor used by the client was:
> localhost:1521: orcl
> exiting: could not open connection
>
> But the connection descriptor that I use is eg COSFI, not orcl.
>
> Other applications works fine with my descriptor.
>
> Someone can help me in order to resolve this problem ?
>

Make sure you have Oracle JDBC drivers installed on the machine you loadjava from. If you only have Thin JDBC driver installed, always use -thin switch with loadjava. If you don't have any Oracle JDBC drivers - install some either using Oracle Client CD or by downloading the latest JDBC drivers from
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Thu Dec 14 2006 - 12:28:18 CST