Alfresco 4.2c in Oracle 11g (Community)

[farreri]

Hi everyone!

I installed Alfresco 4.2.c (Community) against MySql without any problem, but the final installation will be over Oracle 11g. Both were fresh installations. Also i installed the driver ojdbc14.jar inside ths servlet container.

To make the community version compatible with Oracle i followed this steps:

1-Download the Oracle plugin "oracle-alfresco-4.0_b.amp" from here http://forge.alfresco.com/gf/project/oracle/frs/

2-Added the configuration in the global properties file.
db.driver=oracle.jdbc.OracleDriver
db.username=XXXXXXXX
db.password=XXXXXXXX
db.name=XXXXXXXX
db.url=jdbcracle:thin:@<IP>:<PORT>:<SID>

3-Added the amp file to Alfresco's war (Fresh war, not deployed)

java -jar /opt/alfresco-4.2.c/bin/alfresco-mmt.jar install ~/oracle-alfresco-4.0_b.amp /opt/alfresco-4.2.c/tomcat/webapps/alfresco.war

4-At the startup i got the following errors  (Errors with database creation):

2012-12-19 16:05:44,001 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcracle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver
2012-12-19 16:05:44,002 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine activitiBootstrapEngine created
Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on engine with resource org/activiti/db/create/activiti.oracle.create.engine.sql
Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on history with resource org/activiti/db/create/activiti.oracle.create.history.sql
Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on identity with resource org/activiti/db/create/activiti.oracle.create.identity.sql
2012-12-19 16:06:19,298 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-alf_-3955841227321099819.xml.
2012-12-19 16:06:19,298 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-avm_-5589999180809715522.xml.
2012-12-19 16:06:19,298 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-jbpm_-7025709814602406474.xml.
2012-12-19 16:06:19,299 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-act_-8494083256309649132.xml.
2012-12-19 16:06:19,346 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6927223873748884445.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-RepoTables.sql).
2012-12-19 16:06:21,477 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-3860934218899391398.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-LockTables.sql).
2012-12-19 16:06:21,670 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6176405191228569587.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ContentTables.sql).
2012-12-19 16:06:22,684 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-7494030910155495858.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-PropertyValueTables.sql).
2012-12-19 16:06:23,121 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6171079455224028704.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AuditTables.sql).
2012-12-19 16:06:23,245 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-138387599383027756.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AvmTables.sql).
2012-12-19 16:06:24,062 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-5500106896623881050.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ActivityTables.sql).
2012-12-19 16:06:24,264 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-405415472476103949.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-UsageTables.sql).
2012-12-19 16:06:24,306 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-7162307512227852032.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-SubscriptionTables.sql).
2012-12-19 16:06:24,359 ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
java.lang.NullPointerException
at org.alfresco.repo.domain.schema.SchemaBootstrap.getScriptInputStream(SchemaBootstrap.java:1070)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:980)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:802)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1539)



The following startups throws another error:

2012-12-20 13:23:48,941 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcracle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver
2012-12-20 13:23:48,942 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
2012-12-20 13:25:09,354 ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Unable to dump schema to directory /opt/alfresco-4.2.d/tomcat/temp/Alfresco
java.lang.RuntimeException: Unable to execute export.
at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:178)
at org.alfresco.util.schemacomp.DbToXML.execute(DbToXML.java:70)


Some tables are created (I can provide a list), but the instructions from AlfrescoCreate-SubscriptionTables.sql (or next sql) are failing. I can cleanup all the user's database objects and everytime happens the same.

Do you know what is happening? i think the problems can be….

1-The plugin is outdated and there are new tables or new columns.
2-User database permissions despite the client ensures that the user has all the required permissions.

Do you have any script for Oracle?

Thank you in advance…

[abarisone]

Hi,
I think that the problem might be that Alfresco Community 4.2.c does not support Oracle.
The Oracle plugin should be enough for 4.0.d but not for newer versions.

Regards,
Andrea

[farreri]

Thank you for your response Andrea.

I thought the same, i opened the plugin file and examined the DDL scripts, the model is a bit different and shouldn't work. Does the community have in mind update the plugin? If not maybe i can take a look and contribute a newer version.

Thank you again, Miguel.

[wajdi_ghribi]

Hello @farreri, did you find out how to configure oracle against alfresco community 4.2.c ?
Thanks