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