topic Alfresco 2.1 + Oracle10g fail on start (2.0 & oracle wor in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-oracle10g-fail-on-start-2-0-oracle-wor/m-p/122395#M86207 <HTML><HEAD></HEAD><BODY><SPAN>Am not new to alfresco, we have an alfresco 2.0 instance up and running on oracle with little to no difficulties.&nbsp; So we decided to upgrade to 2.1 (mostly because the clustering in 2.0 did not function properly).&nbsp; Unfortunately, after modifying the configs and attempting a start I ran into this error:</SPAN><BR /><SPAN>11:14:23,139 WARN&nbsp; [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one</SPAN><BR /><SPAN>11:14:24,912 WARN&nbsp; [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.</SPAN><BR /><SPAN>11:14:28,256 INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.Oracle9Dialect.</SPAN><BR /><SPAN>11:14:30,735 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed</SPAN><BR /><SPAN>java.sql.SQLException: ORA-00942: table or view does not exist</SPAN><BR /><BR /><SPAN>So, after a good deal of frustrution I eventually pulled down alfresco-community-tomcat-2.1.0.tar.gz and set it up with a clean db and a clean alf_data directory.&nbsp; Then I configured it following these instructions:</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Database_Configuration" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Database_Configuration</A><BR /><SPAN>I slid the same oracle jdbc driver jar that was functioning with 2.0 into \tomcat\common\lib I also made certain that the same connection information that was/is functioning with 2.0 was also placed in the appropriate properties file.</SPAN><BR /><SPAN>I also added the dbpool config file custom-connection-pool-context.xml and made certain the validationQuery was correct.</SPAN><BR /><BR /><SPAN>However I get the exact same error.&nbsp; After digging through the forums I see others have also had difficulty with running Allfresco 2.1 with Oracle, but have not seen anyone claiming to have successfully have run this combination much less post anything concerning how they did it.</SPAN><BR /><BR /><SPAN>I'm not new to alfresco, nor am I new to java or configuring java apps.&nbsp; There has to be something I am missing here<img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" />&nbsp; Has anyone actually gotten Alfresco 2.1 community to run with Oracle?&nbsp; If so, a little help would be appreciated.</SPAN><BR /><BR /><SPAN>——————–custom-connection-pool-context.xm————————————— </SPAN><BR /><SPAN>&lt;?xml version='1.0' encoding='UTF-8'?&gt;</SPAN><BR /><SPAN>&lt;!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' '</SPAN><A href="http://www.springframework.org/dtd/spring-beans.dtd" rel="nofollow noopener noreferrer">http://www.springframework.org/dtd/spring-beans.dtd</A><SPAN>'&gt;</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&lt;!–</SPAN><BR /><SPAN>&nbsp;&nbsp; An example of how to override the dataSource bean.</SPAN><BR /><SPAN>&nbsp;&nbsp; If an alternative pool is desired, such as C3P0, then it can be referenced by&nbsp;&nbsp; changing the 'class' attribute and adding or removing the required properties.</SPAN><BR /><SPAN>&nbsp;&nbsp; The required libraries can be dropped into the servers extension lib folders.–&gt;</SPAN><BR /><SPAN>&lt;beans&gt;</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– DBCP Configuration –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– </SPAN><A href="http://jakarta.apache.org/commons/dbcp/configuration.html" rel="nofollow noopener noreferrer">http://jakarta.apache.org/commons/dbcp/configuration.html</A><SPAN> –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– connection settings –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driverClassName"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.driver}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.url}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.username}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.password}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="defaultAutoCommit" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;false&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– pool settings –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="minIdle" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.pool.initial}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="maxActive" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;${db.pool.max}&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="maxWait" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;10000&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="validationQuery" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;select 1 from dual&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="timeBetweenEvictionRunsMillis" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;300000&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="minEvictableIdleTimeMillis" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;60000&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="testOnBorrow" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;false&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="testOnReturn" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;false&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="testWhileIdle" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;true&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="removeAbandoned" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;true&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="removeAbandonedTimeout" &gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;30&lt;/value&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /><SPAN>——————————-</SPAN></BODY></HTML> Tue, 27 Nov 2007 19:47:19 GMT lfuller 2007-11-27T19:47:19Z Alfresco 2.1 + Oracle10g fail on start (2.0 & oracle wor https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-oracle10g-fail-on-start-2-0-oracle-wor/m-p/122395#M86207 Am not new to alfresco, we have an alfresco 2.0 instance up and running on oracle with little to no difficulties.&nbsp; So we decided to upgrade to 2.1 (mostly because the clustering in 2.0 did not function properly).&nbsp; Unfortunately, after modifying the configs and attempting a start I ran into this erro Tue, 27 Nov 2007 19:47:19 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-oracle10g-fail-on-start-2-0-oracle-wor/m-p/122395#M86207 lfuller 2007-11-27T19:47:19Z Re: Alfresco 2.1 + Oracle10g fail on start (2.0 & oracle wor https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-oracle10g-fail-on-start-2-0-oracle-wor/m-p/122396#M86208 <HTML><HEAD></HEAD><BODY><SPAN>About a day after my last post the problem ended up being the same old Oracle permissions issue that has been posted here in the past (someone else had apparently started using alfresco as well).&nbsp; Once I blew away the schema, created a new one with the proper permissions and reimported the old snapshot, the upgrade worked fine.&nbsp; I'd apologize for wasting the community's time… but no one bothered to reply so I doubt much time was spent on this issue<img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" />&nbsp; BTW Alfresco's 2.1.1 community edition does handle the clustered configuration quite well and has held up under some solid perf and functional testing.&nbsp; Much better than Alfresco 2.0 which seemed to fail roughly 5% of the time when content was deleted from one node and searched for from the other.</SPAN></BODY></HTML> Wed, 12 Dec 2007 16:37:10 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-oracle10g-fail-on-start-2-0-oracle-wor/m-p/122396#M86208 lfuller 2007-12-12T16:37:10Z