Hi helix84.
I could install DSPACE with Oracle. The sintaxis to the database connect in
[dspace-source]/dspace/config/dspace.cfg is:
db.url = jdbc:oracle:thin:@database.host:1521/sid
For own case, isn't SID dspace.
Previously, I installed Oracle JDBC driver (ojdbc6.jar) and modified POM file
in [dspace-source]/pom.xml with current drive version:
<project ...>
<dependencies>>
<!-- ORACLE database driver -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
</dependencies>
</project>
The last step is not in Dspace documentation
https://wiki.duraspace.org/display/DSDOC18/Installation
Another point is that own database server is not in the same DSPACE server, so
you also must install the Oracle client to the DSpace server and to modify
tnsnames.ora and listener.ora files.
Thanks for your support.
Walter Blandón
Analista Técnico
Centro Cultural Biblioteca Luis Echavarría Villegas
Universidad EAFIT, Medellín, Colombia
Carrera 49 No. 7 Sur-50, Av. Las Vegas
Tel: (57)(4)2619500 ext. 9365
http://www.eafit.edu.co/biblioteca
-----Mensaje original-----
De: [email protected] [mailto:[email protected]] En nombre de helix84
Enviado el: miércoles, 06 de junio de 2012 03:29 a.m.
Para: Walter Blandón
CC: [email protected]
Asunto: Re: [Dspace-tech] RV: DSPACE with ORACLE
On Tue, Jun 5, 2012 at 10:16 PM, Walter Blandón <[email protected]> wrote:
> What should I do in Tomcat configuration to connect to the Oracle database?
The important information here is that you're using the tomcat.apache.org
source. You have to make sure that Tomcat gets the ORACLE_HOME (and maybe also
ORACLE_SID, I'm not sure) environment variable. I think you should set it in
startup.sh.
Regards,
~~helix84
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
