On Wed, Jun 6, 2012 at 10:29 AM, helix84 <[email protected]> wrote: > 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.
What I wrote is what you should try first, however, there might be a way to bypass tnsnames.ora completely, but I don't know exactly how. Instead of SID, you should be able to use it's value: (description=(address_list=(address=(protocol=TCP)(host=localhost)(port=1521)))(connect_data=(service_name=DSPACE))) I would try something like this in dspace.cfg: db.url = jdbc:oracle:thin:@//host:port/(description=(address_list=(address=(protocol=TCP)(host=localhost)(port=1521)))(connect_data=(service_name=DSPACE))) I don't guarantee that it will work. 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
