topic Oracle Database Issue in Alfresco Archive

Oracle Database Issue

lmoulin — Tue, 13 Mar 2007 10:08:04 GMT

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 failedorg.alfresco.error.AlfrescoRuntimeException: Echec de la mise jour automatique du schma at org.a

Re: Oracle Database Issue

lmoulin — Tue, 13 Mar 2007 14:25:23 GMT

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

Re: Oracle Database Issue

lmoulin — Wed, 14 Mar 2007 09:07:27 GMT

Have you an idea?
Thanks a lot

Re: Oracle Database Issue

steve — Wed, 14 Mar 2007 10:39:44 GMT

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

Re: Oracle Database Issue

lmoulin — Wed, 14 Mar 2007 11:03:46 GMT

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

Re: Oracle Database Issue

lmoulin — Tue, 03 Apr 2007 13:23:56 GMT

Have you any idea?

Re: Oracle Database Issue

steve — Tue, 03 Apr 2007 13:31:07 GMT

Hi,

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

Steve

Re: Oracle Database Issue

lmoulin — Tue, 03 Apr 2007 14:03:43 GMT

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

Re: Oracle Database Issue

derek — Fri, 13 Apr 2007 18:02:03 GMT

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

Re: Oracle Database Issue

lmoulin — Mon, 16 Apr 2007 11:14:21 GMT

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