Unix Technical Forum

Error with OCI8 driver installing sendmail/javamail

This is a discussion on Error with OCI8 driver installing sendmail/javamail within the Oracle Database forums, part of the Database Server Software category; --> Hi to All, >From Dos window I run the command: loadjava -user sys/pwd@name_db -resolve -synonym activation.jar This is the ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 03:54 AM
nick048
 
Posts: n/a
Default Error with OCI8 driver installing sendmail/javamail

Hi to All,

>From Dos window I run the command:

loadjava -user sys/pwd@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
namedbracle.aurora.server.tools.loadjava.ToolsEx ception: 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.dl l: Impossible
to find the specified procedure.
exiting: could not open connection

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

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 ?

Thank You and Best Regards.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 03:55 AM
Vladimir M. Zakharychev
 
Posts: n/a
Default Re: Error with OCI8 driver installing sendmail/javamail


nick048 wrote:
> Hi to All,
>
> >From Dos window I run the command:

> loadjava -user sys/pwd@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
> namedbracle.aurora.server.tools.loadjava.ToolsEx ception: 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.dl l: 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.dl l
>


....and you should've used

loadjava -thin user/password@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/sof...dbc/index.html

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:12 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com