Oracle Database Issue

[lmoulin]

I use a Oracle database in a MacX.
When the application is started, the following error is displayed:

11:04:55,266 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Echec de la mise  jour automatique du schma
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:613)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
        at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:893)
        at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:983)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1123)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:218)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:301)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:598)
        … 36 more

Have you any idea?
Thanks a lot
Luc

[lmoulin]

I found the issue !!!!
I have already an alfresco user and schema on the same SID.
But I have created a new user and new schema on this SID.

The first connection is:
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbcracle:thin:@localhost:1521RA1
db.username=ERD
db.password=ERD

The second connection is:
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbcracle:thin:@localhost:1521RA1
db.username=GDF
db.password=GDF

I use the same SID: ORA1.

How can I use 2 Alfresco applications on the same SID ORACLE?

Thanks a lot

[lmoulin]

Have you an idea?
Thanks a lot

[steve]

Hi,

Could it be that both your connections use the same db.name

db.name=alfresco

I would have thought that since you are trying to use two seperate instances that this should be different.

Hope this helps,

Steve

[lmoulin]

Thanks,
I try with the following connection parameters:

db.driver=oracle.jdbc.OracleDriver
db.name=alfrescogdf
db.url=jdbcracle:thin:@localhost:1521RA1
db.username=GDF
db.password=GDF

The same error is displayed. Why?
Thanks
Luc

[lmoulin]

Have you any idea?

[steve]

Hi,

It could be a symptom of this bug:
http://issues.alfresco.com/browse/AR-1307

Steve

[lmoulin]

If I replace my oracle database by a MySQL database, can I use several Alfresco webclients on the same server?

[derek]

Hi,

I've not tried several Alfresco servers sharing the same Oracle database server.  We'll look into the bug - it'll be fixable, no doubt.

I have run several Alfresco instances using the same MySQL server instance (different DB names, ofcourse).  Is this what you wanted to know?

Regards

[lmoulin]

Hello,
You say this oracle bug will be fixed:

We'll look into the bug - it'll be fixable, no doubt.

Have you the date of correction of this bug?

Thanks a lot,
Luc