Forum OpenACS Q&A: OpenACS4 install on Oracle 8.1.6 and RH6.2

after nearly 2 years of ACS Classic (3.x) coding, I'm finally getting
my hands on OpenACS. I've been following the bulletin boards for a
few months now and am delighted to see such a vibrant and
knowledgeable community - I think at this stage it's safe to say it
has surpassed the original Web/DB as the place to go to to learn
about database-backed websites. Well done to everybody.

On to my problem. I downloaded the OpenACS alpha tar and Jonathan
Marsden's AOLserver RPM for RH6.2, messed around a bit with the ini
file and fired AOLserver up. I got a page telling me "Congratulations!
You have successfully installed the OpenACS Community System version
@acs_version@. "

My problem is I was expecting an auto-installer process of some sort.
How do I start this off? I couldn't find documentation that referred
to anything like the old load-data-model.sql that I'm used to from
ACS 3.x, is that completely gone now?

thanks for any help,


Posted by Connie Hentosh on
Sorry, I haven't installed OpenACS with Oracle yet. But for PostgreSQL there is the "load-geo-tables" script which is then followed by the load-data-model.sql. These are mentioned in the PostgreSQL install docs. Located here:

I am not sure of the state of the Oracle compatibility with ACS 3.x. I am not sure if it is as simple as removing the postgres.sql line from the load-data-model.sql file.

Posted by Ola Hansson on
It looks like you are installing OpenACS 4.2, right? I haven't done the installation on Oracle either but I assume it's quite similar to the Postgres install...

If my memory serves, you must use the .tcl version of the config file with OpenACS 4.x (but that may be totally wrong...). Here's a sample file:

Make sure you restart AOLserver (if this is it you've probably found out already😉) and check the permissions of the ACS code base - nsadmin (or whatever) must have read rights. The "semi" auto-install process should now be activated. You may have to resolve some other issues as well, but the bootstrap pages will tell you what to do.

Hope this helps.

Posted by Don Baccus on
It is possible that the bootstrap installer is failing when trying
to call SQL*Plus to source the .sql file for the kernel datamodel.

I haven't investigated this in detail but ran across exactly the
same symptom yesterday with a test PostgreSQL install.  The Tcl code
doing the exec of SQL*Plus/PSQL is looking for errors in the output
string but doesn't do a very good job.  We should look into
improving it.