topic Can Alfresco be installed using Oracle or MS SQL server? in Alfresco Archive

Can Alfresco be installed using Oracle or MS SQL server?

mcai7gh2 — Tue, 25 Aug 2009 13:56:58 GMT

Hi,Does any body know how to, or has anybody tried to, install Alfresco with an Oracle or MS SQL Server backend?If so, has anybody tried running it on Oracle 11g RAC?ThanksGeorgina

Re: Can Alfresco be installed using Oracle or MS SQL server?

jayjayecl — Tue, 25 Aug 2009 14:04:25 GMT

This link might be useful :
http://www.alfresco.com/services/support/stacks/

Hope this helps

Re: Can Alfresco be installed using Oracle or MS SQL server?

mikeh — Tue, 25 Aug 2009 14:05:57 GMT

Although note those are for Enterprise only. For the Community Edition, we support MySQL and PostgreSQL.

Thanks,
Mike

Re: Can Alfresco be installed using Oracle or MS SQL server?

mcai7gh2 — Tue, 25 Aug 2009 14:24:21 GMT

Great thanks! That is just want I was looking for!

Do you know how much the enterprise licence is?

Re: Can Alfresco be installed using Oracle or MS SQL server?

jayjayecl — Tue, 25 Aug 2009 14:33:02 GMT

Feel free to contact sales@alfresco.com

Re: Can Alfresco be installed using Oracle or MS SQL server?

burnsbrs — Tue, 25 Aug 2009 17:34:57 GMT

Hi,

Does that mean that Community version WON'T run on SQL Server or only that it's not supported?

Thanks,

Burns

Re: Can Alfresco be installed using Oracle or MS SQL server?

mrogers — Tue, 25 Aug 2009 20:10:30 GMT

It won't run because the database files for Oracle and MS SQL server are Enterprise only features.

Re: Can Alfresco be installed using Oracle or MS SQL server?

burnsbrs — Tue, 25 Aug 2009 20:34:17 GMT

Ok, thanks.

Burns

Re: Can Alfresco be installed using Oracle or MS SQL server?

gboudreau — Thu, 27 Aug 2009 13:35:21 GMT

It won't run because the database files for Oracle and MS SQL server are Enterprise only features.

You mean the JDBC drivers (ojdbc14.jar for Oracle)?
Because I'm currently running Community 3.0 on Oracle; I simply added the above file in ./tomcat/lib/, and configured custom-repository.properties with

db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@hostname.myself.com:1521:db_sid‍‍

and all seems to work fine..?

Re: Can Alfresco be installed using Oracle or MS SQL server?

mikeh — Thu, 27 Aug 2009 13:44:18 GMT

To be clear: Community Edition v3.2 only supports MySQL and PostgreSQL.

Thanks,
Mike

Re: Can Alfresco be installed using Oracle or MS SQL server?

ra74 — Fri, 28 Aug 2009 13:51:05 GMT

Hi,

Does any body know how to, or has anybody tried to, install Alfresco with an Oracle or MS SQL Server backend?

If so, has anybody tried running it on Oracle 11g RAC?

Thanks

Georgina

For a typical developer it takes 15 minut to run alfresco 3.2 on the oracle database. But upgrading the instance in the future may be tough or impossible if the alfresco team will block it somehow

Re: Can Alfresco be installed using Oracle or MS SQL server?

mikeh — Fri, 28 Aug 2009 14:21:02 GMT

For a typical developer it takes 15 minut to run alfresco 3.2 on the oracle database. But upgrading the instance in the future may be tough or impossible if the alfresco team will block it somehow

We're not going to block it - we're just not going to support it.

Thanks,
Mike

Re: Can Alfresco be installed using Oracle or MS SQL server?

gboudreau — Fri, 28 Aug 2009 16:28:02 GMT

To be clear: Community Edition v3.2 only supports MySQL and PostgreSQL.

Thanks,
Mike

I'm curious… Why was that support removed between 3.0 and 3.2? Will it come back once Enterprise reach 3.2?

For a typical developer it takes 15 minut to run alfresco 3.2 on the oracle database. But upgrading the instance in the future may be tough or impossible if the alfresco team will block it somehow

Would you mind sharing what was necessary? No need for details really (if you do have time, that's still be nice), but I'd just like to know in advance what's missing if I'd like to use Community 3.2 with Oracle.

Cheers.

Re: Can Alfresco be installed using Oracle or MS SQL server?

mikeh — Fri, 28 Aug 2009 16:48:07 GMT

I'm curious… Why was that support removed between 3.0 and 3.2? Will it come back once Enterprise reach 3.2?

It was a business decision to only support Open Source databases with the free Community Edition. It's part of our move to differentiate the Community and Enterprise editions - Enterprise gets extra, enterprise-only features.

Enterprise customers will get the full list: http://www.alfresco.com/services/support/stacks/3.x/

Thanks,
Mike

Re: Can Alfresco be installed using Oracle or MS SQL server?

ra74 — Sun, 30 Aug 2009 16:37:37 GMT

To learn how to install alfresco i.e. on the oracle database download and unpack extension for postgres support. You will find that that you have to port a few sql and ibatis scripts placed in create/3.2 dir. Simply analyse these and mysql scripts included in the war - they are quite simple. To get knowledge how to port data types i.e. BIGINT should be replaced by NUMBER(19,0) you can analyse alresco 2.1 or 3.0 installation or scripts included in the enterprise trial
Regarding ibatis files search in google for ibatis oracle sequence to find how it should be done for the oracle

This link http://wiki.alfresco.com/wiki/Schema_Upgrade_Scripts can be helpful a bit
In general in the alresco log you can find exactly what is wrong and what alresco expect i.e. during first startup AFAIR it says there is no class for mysql jdbc driver. So search for occurence of mysql driver name and replace it by oracle driver name and so on

The one issue I've with 3.2 is cpu workload 60-100%. 3.0 installed on the same tomcat instance was working fine