topic Re: Error while starting Alfresco server (configured with Oracle in Alfresco Archive

Error while starting Alfresco server (configured with Oracle

lmanoh — Wed, 05 Nov 2008 13:46:24 GMT

I am trying to install Alfresco Lab version with Oracle 10g database. When I try to start Alfresco Server I am getting the following exceptions in the console.14:19:46,527 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.

Re: Error while starting Alfresco server (configured with Oracle

asifsehzaad — Wed, 05 Nov 2008 21:41:09 GMT

from the exception it looks like you were either trying to upgrade your installation…or trying to install over an existing schema..

i am guessing from the error stack here…if you are trying to upgrade… then best of luck… I am also new to alfresco…soemone here might help you out. but if you are trying to install on an existing one… try dropping the schema and create a new one , also check the permissions for the user that you are trying to connect as to this schema.

cheers
Asif

Re: Error while starting Alfresco server (configured with Oracle

lmanoh — Thu, 06 Nov 2008 05:44:04 GMT

Thanks for your reply.

I droped the existing schema in Oracle DB and create new one called alfresco. Starting the server again i got the same exception like

"11:05:11,895  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 upgrade again."‍‍

while configuring the oracle i followed the information from http://wiki.alfresco.com/wiki/Database_Configuration
apart from this , shall i want to do any other thing?

Re: Error while starting Alfresco server (configured with Oracle

benswitzer — Thu, 06 Nov 2008 12:53:13 GMT

Hi lmanoh.

I don't use Oracle, I believe your issue may be related to the fact that one of the know issues in 3B is that it doesn't work with any other database than MySQL. I'd been using SQL Server for previous versions until 3B.

Check this: http://wiki.alfresco.com/wiki/Alfresco_Labs_3b_Release_Notes

Ben

Re: Error while starting Alfresco server (configured with Oracle

asifsehzaad — Sat, 08 Nov 2008 02:39:00 GMT

what about the permissions of the user that you are trying to connect as…are they ok… i hope they should..but as suggested above it might not support oracle…but that is highly unlikely… ( CMS's need to be database agnostic)

Re: Error while starting Alfresco server (configured with Oracle

lmanoh — Wed, 12 Nov 2008 06:42:15 GMT

Thanks Friends, wonderful response i got from u guys,

Now i got solution,

if we have a multiple schema in the database, we need to specify default schema in "custom-hibernate-dialect.properties"
for example,

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.default_schema=alfrescolab

here alfrescolab is a schema name in oracle.

Re: Error while starting Alfresco server (configured with Oracle

asifsehzaad — Thu, 13 Nov 2008 06:30:51 GMT

Thanks Friends, wonderful response i got from u guys,

Now i got solution,

if we have a multiple schema in the database, we need to specify default schema in "custom-hibernate-dialect.properties"
for example,

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.default_schema=alfrescolab

here alfrescolab is a schema name in oracle.

It would be interesting to know how you reached this solution, as this would help me and others like me

Re: Error while starting Alfresco server (configured with Oracle

lmanoh — Thu, 13 Nov 2008 12:05:11 GMT

No. It support oracle. for me its working fine. i installed alfresco lab 3 only.

http://wiki.alfresco.com/wiki/Database_Configuration

check above link.
1.delete all the content alf_data folder in alfresco.
2.create new schema in db called alfresco
3. get the in information from above link. Now restart the server.

its working fine.

-lenin