Installation of Alfresco against Oracle instance

[janet1969]

created an oracle database on a remote server with a user called alfresco and the privilege grant any granted to the user
installed tomcat 6 and Oracle JDBC driver ocdbc14.jar on tomcat server
environment is Linux
Environment
Operating System Linux:

Web server:
Tomcat version  6.0.18

Database
Database version: is 10g 10.2.0.4 Enterprise edition

JDK and JRE
install JDK and JRE version
java version "1.6.0_23"
Java(TM) SE Runtime Environment (build 1.6.0_23-b05)
Java HotSpot(TM) Client VM (build 19.0-b09, mixed mode, sharing)

Configuration
One server with Oracle installed
One server  with tomcat, JDK and alfresco installed no other tomcat instances on the server

Testing
Tested that app server can connect to database by writing a test java classs
followed the instructions for installing using a war file contained in unzip file alfresco-community-3.4.c.zip ie copied alfresco and share war to webapps directory of tomcat server software

started the server and enter the url to alfresco got following errors

17:33:20,085 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
17:33:26,985 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'SearchService' while setting bean property 'searchService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SearchService' defined in class path resource [alfresco/public-services-context.xml]:

This is repeated for each bean… any ideas

janet

[mrogers]

Alfresco community edition only supports open source databases.   In particular MySql and PostgreSql.

You need Alfresco Enterprise to run with Oracle.

[janet1969]

What is the difference between the community version and the enterprise  version. We are currently attempting to test if it wil work against an oracle database. Would it be possible to obtained the Enterprise version for evaluation purposes only.

[mrogers]

Yes.   Sign up for an Enterprise trial.

http://www.alfresco.com/try/

[vk02169]

I am also facing the same issue as you, I tried installing the trial version and that doesn't seem to help either.

Did it work for you?

[janet1969]

not yet

but I did a  wrote a test jsp to test that tomcat could connect to the remote oracle database it worked after setting the classpath

However I have noticed there is a repository.properties file dor the alfresco application which still refers to mysql.  I wonder if this is overriding the properties in the alfresco-global.properties file


Does this file need to be updated as well ? Are there any other files that need to be updated?

Does anyone else have experience of installing Alfresco against oracle?

Any help would be appreciated
:?

[mrogers]

Alfresco Enterprise is tested against Oracle so there's no need for you to "test" it yourself.    And Alfresco support will help with getting your Enterprise trial started.

In addition you are not posting sufficient details to the forums to enable people to help.   There was a bit of a stack trace in the initial posting but the important information was chopped off.

[janet1969]

We need to deploy it against an oracle database so we need to know how to configure it and install it.

I have not tried the enterprise edition as yet

will try that and get back to you with logs

[janet1969]

mrogers

Just had a thought. If we are using oracle as opposed to the default mysql wont we have to change a spring.xml configuration file to make it recogonise the oracle driver

Jan :?:

[janet1969]

sorry for the delay folks

success at last.

i installed the trial version  of the zip file on an instance of tomcat 6.0.

They were a few things I needed to do

As stated in the installation and configuration guide

ie copy the ojdbc14.jar file from  the installation direcory for oracle instant client to <TOMCAT HOME>/shared/lib directory

Configure the alfresco-global.properties file and place it in the  <TOMCAT HOME>/shared/classes directory

similar to below:
db.name=alfresco
db.username=alfresco
db.password=********
db.host=<ip address or name of server>
db.port=<port the database listener listens on>
db.driver=oracle.jdbc.OracleDriver
db.url=jdbcracle:thin:@<ip address or name of server>
:<port the database listener listens on>
:alfresco
db.pool.validate.query=SELECT 1 FROM SYS.DUAL
img.root=/ImageMagick
img.exe=/usr/local/bin/convert
swf.exe=/usr/local/bin/pdf2swf

Ensure the file ojdbc.jar is owned by tomcat

ensure the path for the oracle driver jar file is on the classpath. I explicitly  set this via an environmental variable in a script I use to start apache tomcat and export it

Ensure the LD_LIBRARY_PATH is set to the location where oracle instant client is installed so the driver can find it's library
Ensure the JAVA_HOME is set to jdk 1.6

Set the Java MaxPermSize to avoid Java Heap error

Last word ensure pre-requisite software components listed in installation guide are installed
export JAVA_OPTS="$JAVA_OPTS -Xms512m -Xmx1024m -XX:MaxPermSize=512m -server"