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
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.
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.
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.
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
