nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Can Alfresco be installed using Oracle or MS SQL server?

mcai7gh2

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

Find more posts tagged with

Comments

jayjayecl

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

Hope this helps

mikeh

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

Thanks,
Mike

mcai7gh2

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

Do you know how much the enterprise licence is?

jayjayecl

Feel free to contact sales@alfresco.com

burnsbrs

Hi,

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

Thanks,

Burns

mrogers

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

burnsbrs

Ok, thanks.

Burns

gboudreau

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

mikeh

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

Thanks,
Mike

ra74

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

mikeh

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

gboudreau

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.

mikeh

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

ra74

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