nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco fails to start with oracle express

slioch

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=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100
db.driver=oracle.jdbc.OracleDriver
db.name=xe
db.url=jdbc

racle:thin:@localhost:1521:xe

Copied the jdbc drivers (ojdbc14_g.jar) to c:\alfresco\tomcat\common\lib\.

And when I restart alfresco–I get a load of errors (starting with the following stack trace):

INFO: XML validation disabled
Oct 25, 2008 6:16:35 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
18:17:40,656 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading pro
perties file from class path resource [alfresco/file-servers.properties]
18:18:02,765 INFO [domain.schema.SchemaBootstrap] Schema managed by database d
ialect org.hibernate.dialect.Oracle9Dialect.
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.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo
tstrap.java:1019)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

Any help would be greatly appreciated to let me know what I can try to get this to work. Thanks all!

mike

Find more posts tagged with

Comments

dozyarmadillo

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

mikewaters

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.

slioch

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