topic Alfresco 4.2c in Oracle 11g (Community) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261097#M214227 <HTML><HEAD></HEAD><BODY><SPAN>Hi everyone!</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>To make the community version compatible with Oracle i followed this steps:</SPAN><BR /><BR /><SPAN>1-Download the Oracle plugin "oracle-alfresco-4.0_b.amp" from here </SPAN><A href="http://forge.alfresco.com/gf/project/oracle/frs/" rel="nofollow noopener noreferrer">http://forge.alfresco.com/gf/project/oracle/frs/</A><BR /><BR /><SPAN>2-Added the configuration in the global properties file.</SPAN><BR /><SPAN>db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>db.username=XXXXXXXX</SPAN><BR /><SPAN>db.password=XXXXXXXX</SPAN><BR /><SPAN>db.name=XXXXXXXX</SPAN><BR /><SPAN>db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@&lt;IP&gt;:&lt;PORT&gt;:&lt;SID&gt;</SPAN><BR /><BR /><SPAN>3-Added the amp file to Alfresco's war (Fresh war, not deployed)</SPAN><BR /><BR /><SPAN>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</SPAN><BR /><BR /><SPAN>4-At the startup i got the following errors&nbsp; (Errors with database creation):</SPAN><BR /><BR /><SPAN>2012-12-19 16:05:44,001 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.ProcessEngineImpl &lt;init&gt;</SPAN><BR /><SPAN>INFO: ProcessEngine activitiBootstrapEngine created</SPAN><BR /><SPAN>Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on engine with resource org/activiti/db/create/activiti.oracle.create.engine.sql</SPAN><BR /><SPAN>Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on history with resource org/activiti/db/create/activiti.oracle.create.history.sql</SPAN><BR /><SPAN>Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on identity with resource org/activiti/db/create/activiti.oracle.create.identity.sql</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>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).</SPAN><BR /><SPAN>2012-12-19 16:06:24,359 ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed</SPAN><BR /><SPAN>java.lang.NullPointerException</SPAN><BR /><SPAN>at org.alfresco.repo.domain.schema.SchemaBootstrap.getScriptInputStream(SchemaBootstrap.java:1070)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:980)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:802)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1539)</SPAN><BR /><BR /><BR /><BR /><SPAN>The following startups throws another error:</SPAN><BR /><BR /><SPAN>2012-12-20 13:23:48,941 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>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</SPAN><BR /><SPAN>java.lang.RuntimeException: Unable to execute export.</SPAN><BR /><SPAN>at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:178)</SPAN><BR /><SPAN>at org.alfresco.util.schemacomp.DbToXML.execute(DbToXML.java:70)</SPAN><BR /><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Do you know what is happening? i think the problems can be….</SPAN><BR /><BR /><SPAN>1-The plugin is outdated and there are new tables or new columns.</SPAN><BR /><SPAN>2-User database permissions despite the client ensures that the user has all the required permissions.</SPAN><BR /><BR /><SPAN>Do you have any script for Oracle?</SPAN><BR /><BR /><SPAN>Thank you in advance…</SPAN></BODY></HTML> Thu, 20 Dec 2012 15:48:06 GMT farreri 2012-12-20T15:48:06Z Alfresco 4.2c in Oracle 11g (Community) https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261097#M214227 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 followe Thu, 20 Dec 2012 15:48:06 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261097#M214227 farreri 2012-12-20T15:48:06Z Re: Alfresco 4.2c in Oracle 11g (Community) https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261098#M214228 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I think that the problem might be that Alfresco Community 4.2.c does not support Oracle.</SPAN><BR /><SPAN>The Oracle plugin should be enough for 4.0.d but not for newer versions.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Andrea</SPAN></BODY></HTML> Fri, 21 Dec 2012 08:36:32 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261098#M214228 abarisone 2012-12-21T08:36:32Z Re: Alfresco 4.2c in Oracle 11g (Community) https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261099#M214229 <HTML><HEAD></HEAD><BODY><SPAN>Thank you for your response Andrea.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Thank you again, Miguel.</SPAN></BODY></HTML> Thu, 27 Dec 2012 08:50:08 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261099#M214229 farreri 2012-12-27T08:50:08Z Re: Alfresco 4.2c in Oracle 11g (Community) https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261100#M214230 <HTML><HEAD></HEAD><BODY><SPAN>Hello @farreri, did you find out how to configure oracle against alfresco community 4.2.c ?</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Fri, 15 Apr 2016 16:26:15 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-in-oracle-11g-community/m-p/261100#M214230 wajdi_ghribi 2016-04-15T16:26:15Z