topic Oracle Database instructions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/oracle-database-instructions/m-p/73421#M47908 <HTML><HEAD></HEAD><BODY><SPAN>I have seen the instructions in the wiki, but that doesn't seem to do the trick. Are there other tables that need to be created? Can I get some more detail on this please?</SPAN></BODY></HTML> Fri, 06 Oct 2006 19:01:45 GMT sbendigo 2006-10-06T19:01:45Z Oracle Database instructions https://connect.hyland.com/t5/alfresco-archive/oracle-database-instructions/m-p/73421#M47908 I have seen the instructions in the wiki, but that doesn't seem to do the trick. Are there other tables that need to be created? Can I get some more detail on this please? Fri, 06 Oct 2006 19:01:45 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-database-instructions/m-p/73421#M47908 sbendigo 2006-10-06T19:01:45Z Re: Oracle Database instructions https://connect.hyland.com/t5/alfresco-archive/oracle-database-instructions/m-p/73422#M47909 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco creates all the tables it needs during the bootstrap, provided the required schema already exists - you need to create that first. There is a script for that included in the distribution, though it may not be correct for Oracle.</SPAN><BR /><BR /><SPAN>Are you getting database related errors thrown during the bootstrap process? I set ours up to run against Postgres and the bootstrap failed repeatedly. The code actually creates the database initialization scripts in text files in a temporary directory and then tries to execute them. For some reason, on Postgres they were failing. The error trace included a line identifying the location of the script files and I was able to take a copy of them. I executed them manually through Postgres' equivalent of SQL*Plus and they worked fine. Then I started Alfresco again and the bootstrap ran to completion without error. </SPAN><BR /><BR /><SPAN>Martin Bradford</SPAN></BODY></HTML> Sat, 07 Oct 2006 08:17:11 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-database-instructions/m-p/73422#M47909 martinbradford 2006-10-07T08:17:11Z