Hi helix84.

tnsnames.ora is in /usr/lib/oracle/11.2/client/network/admin

The ORACLE_HOME is in /usr/lib/oracle/11.2/client

I've be Fedora 16 and Tomcat was downloaded by tomcat.apache.org source, 
version 7.0.27

Other environment variable:

OLDPWD=/usr/lib/oracle/11.2/client
LD_LIBRARY_PATH=:/usr/lib/oracle/11.2/client/lib
TNS_ADMIN=/usr/lib/oracle/11.2/client
PATH=...:/usr/lib/oracle/11.2/client/bin:...

What should I do in Tomcat configuration to connect to the Oracle database?


Regards,

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: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] En nombre de helix84 
Enviado el: lunes, 04 de junio de 2012 06:13 p.m.
Para: Walter Blandón
CC: dspace-tech@lists.sourceforge.net
Asunto: Re: [Dspace-tech] DSPACE with ORACLE

On Tue, Jun 5, 2012 at 12:03 AM, Walter Blandón <cblan...@eafit.edu.co> wrote:
>     [java] ORA-12514, TNS:listener does not currently know of service 
> requested in connect descriptor
>
> Configuration to connect database in dspace.cfg is correct.
>
> I installed Oracle Instant Client and I've configure <tnsnames.ora> 
> file

Hi Walter,

this usually means that the ORACLE_HOME environment variable (with path to the 
instant client and in turn tnsnames.ora) was not set correctly. Where did you 
set it so that Tomcat could use it? What OS are you using? Did you install 
Tomcat from your distribution's packages or from tomcat.apache.org source?

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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to