topic Alfresco 2.1 on Oracle 10g Express in Alfresco Archive

Alfresco 2.1 on Oracle 10g Express

liao1108 — Thu, 05 Jul 2007 07:28:31 GMT

:cry: I am going to install Alfresco 2.1 with Tomcat bundled to connect to Oracle 10g Express, there is error message :14:30:25,656 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco

Re: Alfresco 2.1 on Oracle 10g Express

davidc — Thu, 05 Jul 2007 08:19:01 GMT

I'm able to install 2.1 against Oracle 10g Express edition.

Are you installing from fresh or upgrading?

Which OS is your Oracle on?

Which table does not exist?

There's a known issue upgrading from 1.4/2.0 to 2.1RC on Oracle which has been fixed on HEAD.

Re: Alfresco 2.1 on Oracle 10g Express

liao1108 — Thu, 05 Jul 2007 08:39:54 GMT

Hi David,

Thanks for so prompt reply.

I am doing 2.1 fresh installation with two type, one with tomcat bundled and change database to Oracle and modify repository.property and hibernate dialect, and two is deloy via war file in the tomcat 5.5.23 that Alfresco 2.0 works fine. These two installations are getting the same error.

I add and modify extension files to re-direct database connection to Oracle, Alfresco 2.1 knows i am goin to use Oracle jdbc driver, just can not update schema.

I am working on Windows XP, when i looks on alfresco schema on Oracle , anything has been created.

What's wrong with it. Or can you provide a fresh installation against Oracle XE with pay based, thanks.

Re: Alfresco 2.1 on Oracle 10g Express

davidc — Thu, 05 Jul 2007 09:10:34 GMT

Are you installing against an Oracle schema that has already had Alfresco installed against it? If so, you're performing an upgrade and that will fail due to a bug (that's now been fixed in HEAD).

Please try and install against a fresh Oracle database schema and alf_data directory.

Re: Alfresco 2.1 on Oracle 10g Express

liao1108 — Thu, 05 Jul 2007 09:21:36 GMT

Hi David,

I have rename schema name that stores Alfresco 2.0 stuffs, and create a fresh new schema name alfresco to wait for 2.1 RC, is it not ok ? There is also another schemas for another application, i am sure it works ok to company with Alfresco 2.0.

Do you mean i have to keep a pure empty database only one schema 'alfresco' alowed to exist ?

Thanks.

Leo

Re: Alfresco 2.1 on Oracle 10g Express

liao1108 — Thu, 05 Jul 2007 09:42:15 GMT

Hi David,

I drop schema that alfresco 2.0 left, and create a new one, it works.

Thanks.

Leo