Forum OpenACS Q&A: Installation: Windows 2000SP3, Oracle 8.1.6, AOLserver 4-UH Beta 2, OpenACS4.6.1 Final Tarball

19 - 3 - 2003

Encounter the folowing erros during installation of OpenACS core services:

1. Cmd Console
[19/Mar/2003:23:42:45][1720.1520][-conn:openacs4::0] Error: Error parsing queryf
ile /web/openacs4/packages/acs-tcl/tcl/navigation-procs-oracle.xql:
couldn't open "/web/openacs4/packages/acs-tcl/tcl/navigation-procs-oracle.xql":
no such file or directory

2. OpenACS Installation: Installing OpenACS Core Services - Web Browser
Installed Site-Wide Administration, version 4.5.
Acs-admin instantiated as acs-admin.
Package enabled.
Installed ACS API Browser, version 4.5.
Acs-api-browser instantiated as acs-api-browser.
Package enabled.
Installed OpenACS Bootstrap Installer, version 4.5.
Acs-bootstrap-installer instantiated as acs-bootstrap-installer.
Package enabled.

Installing data model for ACS Content 4.5...

· Loading data model /web/openacs4/packages/acs-content/sql/oracle/acs-content-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:40:56 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Table created.
Comment created.
Comment created.
Package created.
No errors.
Package body created.
No errors.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Content, version 4.5.
Acs-content instantiated as acs-content.
Package enabled.

Installing data model for ACS Service Contract 4.6...

·Loading data model /web/openacs4/packages/acs-service-contract/sql/oracle/acs-service-contract-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:41:08 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
string beginning "/web/opena..." is too long. maximum size is 79 characters.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Service Contract, version 4.6.
Acs-service-contract instantiated as acs-service-contract.
Package enabled.

Installing data model for ACS Templating 4.5...

·Loading data model /web/openacs4/packages/acs-templating/sql/oracle/acs-templating-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:41:15 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Sequence created.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Templating, version 4.5.
Acs-templating instantiated as acs-templating.
Package enabled.

Installing data model for ACS Utilities 4.5...

·Loading data model /web/openacs4/packages/acs-util/sql/oracle/acs-util-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:41:24 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Package created.
No errors.
Package body created.
No errors.
Package created.
No errors.
Package body created.
No errors.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Utilities, version 4.5.
Acs-util instantiated as acs-util.
Package enabled.

Installing data model for Page 4.5...

·Loading data model /web/openacs4/packages/page/sql/oracle/page-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:41:35 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Table created.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed Page, version 4.5.
Package enabled.

Installing data model for Search 4.6...

·Loading data model /web/openacs4/packages/search/sql/oracle/search-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:41:42 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Table created.
Package created.
No errors.
Package body created.
No errors.
foo := acs_sc_contract.new(
*
ERROR at line 9:
ORA-06550: line 9, column 12:
PLS-00201: identifier 'ACS_SC_CONTRACT.NEW' must be declared
ORA-06550: line 9, column 5:
PL/SQL: Statement ignored
ORA-06550: line 14, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 14, column 5:
PL/SQL: Statement ignored
ORA-06550: line 19, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 19, column 5:
PL/SQL: Statement ignored
ORA-06550: line 24, column 12:
PLS-00201: identifier 'ACS_SC_OPERATION.NEW' must be declared
ORA-06550: line 24, column 5:
PL/SQL: Statement ignored
ORA-06550: line 34, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 34, column 5:
PL/SQL: Statement ignored
ORA-06550: line 39, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 39, column 5:
PL/SQL: Statement ignored
ORA-06550: line 44, column 12:
PLS-00201: identifier 'ACS_SC_OPERATION.NEW' must be declared
ORA-06550: line 44, column 5:
PL/SQL: State
No errors.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed Search, version 4.6.
Package enabled.

Installing data model for ACS Content Repository 4.6.3...

·Loading SQLJ code /web/openacs4/packages/acs-content-repository/java/Regexp-oracle.sqlj...
initialization complete
loading : com/arsdigita/content/Regexp
creating : com/arsdigita/content/Regexp
·Loading SQLJ code /web/openacs4/packages/acs-content-repository/java/Util-oracle.sqlj...
initialization complete
loading : com/arsdigita/content/Util
creating : com/arsdigita/content/Util
·Loading SQLJ code /web/openacs4/packages/acs-content-repository/java/XMLExchange-oracle.sqlj...
initialization complete
loading : com/arsdigita/content/XMLExchange
creating : com/arsdigita/content/XMLExchange
·Loading data model /web/openacs4/packages/acs-content-repository/sql/oracle/acs-content-repository-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:42:33 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
string beginning "/web/opena..." is too long. maximum size is 79 characters.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Content Repository, version 4.6.3.
Acs-content-repository instantiated as acs-content-repository.
Package enabled.
Installed ACS Tcl, version 4.5.
Acs-tcl instantiated as acs-tcl.
Package enabled.
Installed ACS Core Documents, version 4.5.
Acs-core-docs instantiated as acs-core-docs.
Package enabled.

Installing data model for ACS Mail 4.6.2...

·Loading data model /web/openacs4/packages/acs-mail/sql/oracle/acs-mail-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:42:46 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
No errors.
No errors.
No errors.
No errors.
    constraint acs_mail_mp_parts_c_obj_id_fk references cr_items,
*
ERROR at line 10:
ORA-00942: table or view does not exist
create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id)
*
ERROR at line 1:
ORA-00942: table or view does not exist
No errors.
No errors.
Warning: Package created with compilation errors.
Errors for PACKAGE ACS_MAIL_MULTIPART:
LINE/COL ERROR
-------- -----------------------------------------------------------------
28/2     PL/SQL: Declaration ignored
29/24     PLS-00201: identifier 'ACS_MAIL_MULTIPART_PARTS.MULTIPART_ID'
     must be declared
No errors.
No errors.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MAIL_MULTIPART:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0     PL/SQL: Compilation unit analysis terminated
1/14     PLS-00905: object SYSTEM.ACS_MAIL_MULTIPART is invalid
1/14     PLS-00304: cannot compile body of 'ACS_MAIL_MULTIPART' without
     its specification
No errors.
No errors.
No errors.
No errors.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MAIL_NT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
21/13     PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
21/13     PL/SQL: Item ignored
22/16     PLS-00201: identifier 'CR_REVISIONS.REVISION_ID' must be declared
22/16     PL/SQL: Item ignored
68/2     PLS-00320: the declaration of the type of this expression is
     incomplete or malformed
68/2     PL/SQL: Statement ignored
77/2     PLS-00320: the declaration of the type of this expression is
     incomplete or malformed
LINE/COL ERROR
-------- -----------------------------------------------------------------
77/2     PL/SQL: Statement ignored
78/2     PL/SQL: Statement ignored
78/35     PLS-00320: the declaration of the type of this expression is
     incomplete or malformed
81/2     PL/SQL: Statement ignored
81/47     PLS-00320: the declaration of the type of this expression is
     incomplete or malformed
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Mail, version 4.6.2.
Acs-mail instantiated as acs-mail.
Package enabled.

Installing data model for ACS Messaging 4.5...

·Loading data model /web/openacs4/packages/acs-messaging/sql/oracle/acs-messaging-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:42:56 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (SYSTEM.ACS_OBJECT_TYPES_SUPERTYPE_FK) violated
- parent key not found
ORA-06512: at "SYSTEM.ACS_OBJECT_TYPE", line 28
ORA-06512: at line 3
No errors.
      references cr_items (item_id) on delete cascade
*
ERROR at line 4:
ORA-00942: table or view does not exist
create index acs_messages_reply_to_idx on acs_messages (reply_to)
*
ERROR at line 1:
ORA-00942: table or view does not exist
create index acs_messages_sender_idx on acs_messages (sender)
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on table acs_messages is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.reply_to is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.sent_date is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.sender is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.rfc822_id is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
      references acs_messages (message_id) on delete cascade,
*
ERROR at line 4:
ORA-00942: table or view does not exist
comment on table acs_messages_outgoing is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.to_address is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.grouping_id is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.wait_until is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
    from cr_items i, cr_revisions r, acs_messages m
*
ERROR at line 4:
ORA-00942: table or view does not exist
    from cr_items i, cr_revisions r, acs_messages m
*
ERROR at line 4:
ORA-00942: table or view does not exist
Warning: Package created with compilation errors.
Errors for PACKAGE ACS_MESSAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/5     PL/SQL: Declaration ignored
5/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
24/5     PL/SQL: Declaration ignored
25/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
37/5     PL/SQL: Declaration ignored
38/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
41/5     PL/SQL: Declaration ignored
42/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
45/5     PL/SQL: Declaration ignored
46/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
52/5     PL/SQL: Declaration ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
53/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
59/5     PL/SQL: Declaration ignored
60/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
70/5     PL/SQL: Declaration ignored
71/26     PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
85/5     PL/SQL: Declaration ignored
86/26     PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
97/5     PL/SQL: Declaration ignored
98/26     PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MESSAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0     PL/SQL: Compilation unit analysis terminated
1/14     PLS-00905: object SYSTEM.ACS_MESSAGE is invalid
1/14     PLS-00304: cannot compile body of 'ACS_MESSAGE' without its
     specification
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Messaging, version 4.5.
Acs-messaging instantiated as acs-messaging.
Package enabled.

Installing data model for ACS Subsite 4.6b...

·Loading data model /web/openacs4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql...
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:43:48 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
PL/SQL procedure successfully completed.
No errors.
Table created.
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (SYSTEM.ACS_REL_TYPES_OBJ_TYPE_2_FK) violated -
parent key not found
ORA-06512: at "SYSTEM.ACS_REL_TYPE", line 90
ORA-06512: at line 5
No errors.
PL/SQL procedure successfully completed.
No errors.
Table created.
Package created.
No errors.
Package body created.
No errors.
1 row created.
1 row created.
View created.
View created.
View created.
View created.
Table created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Package created.
No errors.
Package body created.
No errors.
Table created.
foo := acs_sc_contract.new(
*
ERROR at line 4:
ORA-06550: line 4, column 13:
PLS-00201: identifier 'ACS_SC_CONTRACT.NEW' must be declared
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
ORA-06550: line 11, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 11, column 5:
PL/SQL: Statement ignored
ORA-06550: line 16, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 16, column 5:
PL/SQL: Statement ignored
ORA-06550: line 21, column 12:
PLS-00201: identifier 'ACS_SC_OPERATION.NEW' must be declared
ORA-06550: line 21, column 5:
PL/SQL: Statement ignored
ORA-06550: line 34, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 34, column 5:
PL/SQL: Statement ignored
ORA-06550: line 39, column 12:
PLS-00201: identifier 'ACS_SC_MSG_TYPE.NEW' must be declared
ORA-06550: line 39, column 5:
PL/SQL: Statement ignored
ORA-06550: line 44, column 12:
PLS-00201: identifier 'ACS_SC_OPERATION.NEW' must be declared
ORA-06550: line 44, column 5:
PL/SQL: State
No errors.
View created.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Installed ACS Subsite, version 4.6b.
Package enabled.
Installed Skin, version 4.5.
Skin instantiated as skin.
Package enabled.
Completing Install sequence.
SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 23:44:10 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
PL/SQL procedure successfully completed.
No errors.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
All Packages Installed.
Generating secret tokens...

Done.

Questions:

1. Why is the file, "navigation-procs-oracle.xql" no longer included with the 4.6.1 final release (Tarball and CVS)? Can I use the same file provided from the 4.6 older release?

2. Any idea on a workaround for the 79 characters limitation, beside manually executing the commands using sqlplus from a command console?
Oracle Stuff:
For more information on Oracle configuration look at <http://photo.net/wtr/oracle-tips.html> or search the Web/db Q&A Forum <http://photo.net/bboard/q-and-a.tcl?topic=web/db>. One other note: the "nuke a user" admin page and Intermedia won't run unless you set open_cursors = 500 for your database.