Hi,
We have found no reason for using OCI driver so we use JNDI in production and JNDI and NG in development.
-Jukka Rahkonen-
···
Jonathan Moules wrote:
Hi Paulo,
Thanks for that. I do have the relevant files already installed, but don’t have an ORACLE_HOME set because other software breaks if I set it (I have both 32bit and 64 oracle installs, so if I set Oracle Home to one, then software for the other breaks).
Do you know if the OCI driver offers a performance advantage over the plain Oracle driver?
Thanks again,
Jonathan
On 14 December 2012 11:20, Paolo Crosato <paolo.crosato@anonymised.com0…> wrote:
Il 14/12/2012 11:39, Jonathan Moules ha scritto:
Hi Christian,
Thanks for the detailed information. I’m more inclined to picking between the OCI and the NG one’s myself. I have the NG one set up and working but the OCI one doesn’t work.
I get this error in the console when I hit “save” for a new OCI Oracle store:
109562 [btpool0-2] ERROR org.mortbay.log - Nested in org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
Hi,
it would seem you are missing ojdbc from oracle in your java library path, or the binaries like libocijdbc11.so. I had the same issue with other spring apps relying on oracle. It could be that ojdbc5/6 is missing, or it can’t find the oci layer because the libraries are not in the directories the linker is parsing.
I would first check if the ojdb6.jar is in the tomcat/lib directory, if not get it from oracle http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html .
For oci to work you will need the oci libraries too, you can get the instant client here if you haven’t got it already: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
This provides the jars too, so you can skip the ojdbc donwload.
Now all the pieces should be there, to make them work together you have to set ORACLE_HOME to the client path, like this: ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to the linker search path, either by LD_LIBRARY_PATH which works but is not recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.
If you are on windows setting ORACLE_HOME and adding the executables and the libs to the PATH var should be enough.
In summary what you need are the jars and the oci (libocci, libocijdbc1X.so) libs, when you have them it’s just about having them talk together.
Hope it helps, getting Oracle to work like you want it to is always troublesome 
Regards,
Paolo
On 13 December 2012 23:03, cmaul <Christian.Maul@anonymised.com> wrote:
Jonathan,
OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven’t used it.
The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.
I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.
One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.
NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html
where it says: The database schema to access tables from. Setting this value
greatly increases the speed… yes, but then you can only publish from this
schema.
JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:
http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi
Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.
Cheers
Christian
Dr Christian Maul
Project Manager
Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000
PO Box 500, East Melbourne Vic 3002
Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
[http://p.sf.net/sfu/logmein_12329d2d](http://p.sf.net/sfu/logmein_12329d2d)
________________
_________________________
______
Geoserver-users mailing list
[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)
--
Paolo Crosato
Software engineer/Custom Solutions
e-mail: [paolo.crosato@anonymised.com](mailto:paolo.crosato@...5250...)Office phone: +3904221722825
UBIEST S.p.A.
........................................................................................
[www.ubiest.com](http://www.ubiest.com)Via E. Reginato, 85/H - 31100 Treviso- ITALY Tel [+39] 0422 210 194 - Fax [+39] 0422 210 270 ........................................................................................
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.