topic Re: Alfresco 3C and Oracle in Alfresco Archive

Alfresco 3C and Oracle

mastertoto — Mon, 08 Dec 2008 20:48:20 GMT

I'm trying to upgrade from 3b to 3c, is it possible that 3c dropped oracle support?My log has this warning printed,Alfresco should not be used with database dialect org.hibernate.dialect.Oracle9Dialectand later-on I get the error:The schema script could not be found at location classpath:alfresco/db

Re: Alfresco 3C and Oracle

hpalma — Wed, 14 Jan 2009 17:40:21 GMT

I'm also getting this, still no ideas ?

Re: Alfresco 3C and Oracle

mastertoto — Wed, 14 Jan 2009 19:24:23 GMT

Unfortunately no, still using 3b.

Re: Alfresco 3C and Oracle

ivo_costa — Tue, 20 Jan 2009 12:03:43 GMT

hi

have you tried a fresh install with a new database??? the error that you get reads upgrade-from-2.2SP1.sql, so I guess this might be related to your existing database

Re: Alfresco 3C and Oracle

mastertoto — Mon, 26 Jan 2009 20:54:49 GMT

I have.
This is for a fresh install of alfresco.

hi

have you tried a fresh install with a new database??? the error that you get reads upgrade-from-2.2SP1.sql, so I guess this might be related to your existing database

Re: Alfresco 3C and Oracle

netdata — Thu, 29 Jan 2009 15:33:50 GMT

I have found that alfresco does not include the ORACLE scripts anymore in the community version.
I subscribed to an enterprise trail which includes the migration scripts.

Running them gives a lot of errors so I run all scripts manually (The scripts include a lot of 'optional' query's which will fail so I needed to remove them )

I was then able to start alfresco and tomcat says there is no DB upgrade needed (since I did it manually) so that is good !

However the next step is upgrading the SpaceStores, and that's failling.

I'm really disappointed in alfresco !!!
They leave the community and use them as test, and there main focus is really selling an enterprise version.

We are stuck here and are not able to upgrade to version 3

As we are also willing to pay for the enterprise version we asked for a price and for us it will be 160 000€ / 3years !!!!

If someone however is able to upgrade his current alfresco 2.10 to version 3 with oracle I would be glad to here and are even willing to pay for this upgrade…

Re: Alfresco 3C and Oracle

ivo_costa — Fri, 30 Jan 2009 10:41:54 GMT

Oracle is not something that the community would use, so I have no problem with them dropping oracle from the community version…

as for that price, you're right it is really high, so I must ask, was this for a clustering license?

because that as far as I know Alfresco licenses are for CPUs, and a quad-core cpu can handle around 200 simultaneous users, or around 2000 casual users, maybe you asked for too much

Re: Alfresco 3C and Oracle

netdata — Fri, 30 Jan 2009 13:48:39 GMT

Oracle is not something that the community would use, so I have no problem with them dropping oracle from the community version…

as for that price, you're right it is really high, so I must ask, was this for a clustering license?

because that as far as I know Alfresco licenses are for CPUs, and a quad-core cpu can handle around 200 simultaneous users, or around 2000 casual users, maybe you asked for too much

Sorry to go oftopic …

So we don't have 1 alfresco system, we have 6 system each serving different documents for different sites across Europe, but still one company.
We also make a difference between internal alfresco's and an external on the DMZ.
We have 500 user defined in our LDAP but ofcourse not every user will use every alfresco.

But since alfresco is a mix based on CPU and users they are making it nearly impossible for us to use this kind of structure.

We started using alfresco in the early days and this was when alfresco its focus was Opensource and community, but as time goes by there focus is selling…

And concerning oracle it is not done…
I don't see any option here:
- We have issues on 2.10 they where fixed in almost one month in the enterprise version after the 2.10 community release
- finally I can say to our users the bugs are fixed in version3 but we are unable to upgrade

The funny part about this situation is that we are willing to pay for support to get things fixed, but that alfresco looks only interested if we:
- pay a lot
- Change our structure

I wish someone at alfresco could understand this….

Re: Alfresco 3C and Oracle

mikeh — Fri, 30 Jan 2009 16:23:10 GMT

That's quite a large installation: 7 servers and 500 users. I'm not from sales, so don't know our exact pricing model, but €100 per user per year doesn't sound unreasonable when compared to other CMS solutions and even desktop software these days. Also, I bet Oracle's costing you a fair amount…

You also, of course, have the option of employing a support technician / developer internally which would probably be about the same recurring cost.

Mike

Re: Alfresco 3C and Oracle

ajmillar — Tue, 10 Feb 2009 12:01:40 GMT

Oracle is not something that the community would use, so I have no problem with them dropping oracle from the community version…

I beg to differ. We use the community version against an Oracle backend. Not happy if it is the case that they've dumped oracle for the labs version.