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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 namedb 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. |
| ||||
| 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 > namedb > 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 |