db errors during acs installation

Philip Greenspun's Homepage : Philip Greenspun's Homepage Discussion Forums : 6916 : One Thread
Notify me of new responses
During the ACS installation, I get errors trying to access tables that
are not in my oracle db.

Things done so far:

1. untar the acs files into the directory by following
gunzip -cd /home/ta/acs-19990923.tar.gz | tar xvf -

2. used load-dumps to import oracle tables.
I received this message :"Import terminated successfully with
warnings." which I assume meant it "completed" successfully?

3. copied ad.ini to student60.ini and changed the names from
yourdomainname to student60 then restarted aolserver

4. Then when I try to login, I don't see the info that I set in
SystemName and get the following error..

Database operation "select" failed (exception ORA,
"ora8.c:903:ora_exec: error in `OCIStmtExecute ()': ORA-00942: table
or view does not exist

SQL: select section_url_stub, section_pretty_name
from content_sections
where enabled_p = 't'
and requires_registration_p <> 't'
order by sort_key, upper(section_pretty_name)")
while executing
"ns_db select $db "select section_url_stub,
section_pretty_name
from content_sections
where enabled_p = 't' $requires_registration_p_clause
order by so ..."
invoked from within
"set selection [ns_db select $db "select section_url_stub,
section_pretty_name
from content_sections
where enabled_p = 't' $requires_registration_p_cla ..."
(file "/web/student60/www/index.tcl" line 49)
invoked from within
"source $script"
invoked from within
"if ![file exists $script] {
ns_returnnotfound $conn
} else {
source $script
}"
(procedure "ns_sourceproc" line 3)
invoked from within
"ns_sourceproc cns7 {}"

I can't seem to locate the table content_sections?

5. Then when I tried to register from lcsweb60.lcs.mit.edu/register/
and enter my email address I get another SQL error trying to find
table users which I don't have. Were we supposed to create the users
table from the specs in chapter 3 or was it supposed to already be
there?

HELP!!!

-- Jeff Hsing, September 26, 1999

Answers

You have neglected to load the data model, which is not the same thing as loading the dumps. Go to www/doc/sql and run sqlplus studentXX/dbpasswd < load-data-model.sql

-- Jin Choi, September 27, 1999