topic Alfresco fails to start with oracle express in Alfresco Archive

Alfresco fails to start with oracle express

slioch — Sun, 26 Oct 2008 01:44:20 GMT

Hello,Great product. I'm trying to get Alfresco to work with oracle express 10g. I've followed the wiki directions and made the following changes to the standard installation:[custom-repository.properties]hibernate.dialect=org.hibernate.dialect.Oracle9Dialect[custom-repository.properties]db.username

Re: Alfresco fails to start with oracle express

dozyarmadillo — Sun, 26 Oct 2008 07:28:12 GMT

Have you ensured that the Tomcat instances that you use for Oracle Express (XE) and Alfresco are listening on different ports? Both will use port 8080 unless you reconfigure this in conf/server.xml. You may want to change the shutdown port number as well so that they can be shutdown individually.

Regards

Re: Alfresco fails to start with oracle express

mikewaters — Sun, 26 Oct 2008 13:25:13 GMT

18:20:29,093 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed or
was not completed. Revert to the original database before attempting the upgra
de again.

This usually means that the DB is in an inconsistent state due to previous errors.

What I would do next is to drop the alfresco database and recreate it then restart alfresco. Then check the logs to see what the "previous errors" are.

The most common cause for this is that alfresco runs out of memory.

Re: Alfresco fails to start with oracle express

slioch — Mon, 27 Oct 2008 05:17:36 GMT

Thanks for the suggestions. I ended up uninstalling and reinstalling oracle and that fixed the problem. There had been plenty of disk space on the system, but for some reason oracle got into a funky state.

Mike