topic failed connecting to Oracle in Alfresco Archive

failed connecting to Oracle

dnguyen — Wed, 28 Apr 2010 19:51:37 GMT

Hello,I just installed Alfesco Community 2.1 and Oracle 11g and was working fine. I was able to connect Alfresco to the Oracle DB. But when I installed alf_data and the Oracle DB that I imported from one of one of my server I got this error. I know 100% that I backup the alf_data and Oracle DB co

Re: failed connecting to Oracle

sanket — Sat, 01 May 2010 09:21:24 GMT

Alfresco3.2 is not compatible with oracle. Please confirm this with the current alfresco edition.
But as you have written that you had installed n made it work, try to do the following.

1.Delete the alf_data folder
2.Drop existing alfresco schema
3. Create new alfresco schema (running queries from db_setup.sql file)
4. Install fresh copy of alfresco
5. Edit necessary properties file for db connectivity (based on the alfresco version)

Go thru this link.
http://forums.alfresco.com/en/viewtopic.php?f=9&t=25066

Re: failed connecting to Oracle

fracat71 — Sat, 01 May 2010 10:41:22 GMT

Hi dnguyen and Sanket,
Community on Oracle can be dangerous.
I have tried but with problems see http://forums.alfresco.com/en/viewtopic.php?f=14&t=26355 , can you test it?
I have not tested back-up/restore (or move from one server to other) because i'm working on startup project.

Bye