cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco 4.2c in Oracle 11g (Community)

farreri
Champ in-the-making
Champ in-the-making
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=jdbcSmiley Surprisedracle: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: jdbcSmiley Surprisedracle: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: jdbcSmiley Surprisedracle: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…
3 REPLIES 3

abarisone
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
Hello @farreri, did you find out how to configure oracle against alfresco community 4.2.c ?
Thanks