topic Re: Installation of Alfresco against Oracle instance in Alfresco Archive

Installation of Alfresco against Oracle instance

janet1969 — Sun, 30 Jan 2011 18:06:10 GMT

created an oracle database on a remote server with a user called alfresco and the privilege grant any granted to the userinstalled tomcat 6 and Oracle JDBC driver ocdbc14.jar on tomcat serverenvironment is LinuxEnvironmentOperating System Linux:Web server:Tomcat version 6.0.18 DatabaseDatabase vers

Re: Installation of Alfresco against Oracle instance

mrogers — Sun, 30 Jan 2011 20:17:14 GMT

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

You need Alfresco Enterprise to run with Oracle.

Re: Installation of Alfresco against Oracle instance

janet1969 — Tue, 01 Feb 2011 12:35:39 GMT

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.

Re: Installation of Alfresco against Oracle instance

mrogers — Tue, 01 Feb 2011 14:18:08 GMT

Yes. Sign up for an Enterprise trial.

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

Re: Installation of Alfresco against Oracle instance

vk02169 — Wed, 02 Feb 2011 20:49:00 GMT

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?

Re: Installation of Alfresco against Oracle instance

janet1969 — Thu, 03 Feb 2011 10:45:28 GMT

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
:?

Re: Installation of Alfresco against Oracle instance

mrogers — Thu, 03 Feb 2011 11:11:19 GMT

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.

Re: Installation of Alfresco against Oracle instance

janet1969 — Thu, 03 Feb 2011 13:04:05 GMT

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

Re: Installation of Alfresco against Oracle instance

janet1969 — Thu, 03 Feb 2011 13:55:58 GMT

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 :?:

Re: Installation of Alfresco against Oracle instance

janet1969 — Fri, 04 Feb 2011 15:37:02 GMT

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"

Re: Installation of Alfresco against Oracle instance

gangadharjwala — Fri, 11 Apr 2014 09:16:30 GMT

i tried below steps in my location.but the tables were not registering on the DB and the alfersco & share dash boards were not comming through browesr

below is the db details i placed in alfresco-global.properties file.

db.name=xe
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=1521
db.driver=oracle.jdbc.OracleDriver
db.url=jdbcracle:thin:@${db.host}:${db.port}:${db.name}
db.pool.validate.query=SELECT 1 FROM DUAL
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect

And i placed ojdbc14.jar file on /tomcat/lib folder.

i attached the alfresco.log file.

can u please help me out on this…

Re: Installation of Alfresco against Oracle instance

mrogers — Fri, 11 Apr 2014 09:40:44 GMT

What version of alfresco are you using?