O.K. after several attemps I could login and made the upgrade with Oracle 8i,
thanks to Matthew Counte and Andrew Grumet for the support and help.
Here are the steps that I took.
1. Untar the openacs-5.0.0 into a tmp directory
2. Create the directories etc and log in openacs-4.6.3/
3. Move the nsd.tcl file to etc/config.tcl
4. Copy the openacs-5.0.0 on top of your openacs-4.6.3 directory.
cp -r openacs-5.0.0/* openacs-4.6.3/
5. Rename the openacs-4.6.3 to openacs-5.0.0
mv openacs-4.6.3/ openacs-5.0.0
6. Modify the config.tcl to the new Installation parameters.
7. Copy this files in the directories
cp
acs-lang-create.sql /openacs5/packages/acs-lang/sql/oracle/
cp
zzz-postload.tcl /openacs5/tcl/
8. Run the following scripts in this order from sqlplus
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.3-4.6.4.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d6-5.0d7.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d7-5.0d9.sql (ignore errors)
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql (ignore errors)
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b1-5.0.0b2.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b2-5.0.0b3.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b3-5.0.0b4.sql
-- Upgrading Service Contracts
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5.1-4.6.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.7d2-4.7d3.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.7d3-5.0d1.sql
-- Load acs-authentication data model.
@@ openacs-5.0.0/packages/acs-authentication/sql/oracle/acs-authentication-create.sql
-- Load acs-lang data model.
@@ openacs-5.0.0/packages/acs-lang/sql/oracle/acs-lang-create.sql
9. run the acs package and body definition.
acs.sql
10.Remove the following files:
rm openacs-5.0.0/packages/acs-lang/tcl/lang-procs*
rm openacs-5.0.0/packages/acs-lang/tcl/lang-init*
rm openacs-5.0.0/packages/acs-templating/tcl/0-procs.tcl
rm -fr openacs-5.0.0/packages/acs-templating/resources/lists
rm openacs-5.0.0/packages/acs-templating/tcl/list-procs.tcl
rm openacs-5.0.0/packages/acs-automated-testing/tcl/example-test-procs.tcl
11. Modify openacs-5.0.0/www/index.apd page:
- where the form name="login" definition is add the ;noquote to @form_vars@ to look like this @form_vars;noquote@
12. At the end of openacs-5.0.0/www/blank_master.tcl modify the set lang_admin_p to look like this
set lang_admin_p 1
#[permission::permission_p \
-object_id [site_node::get_element -url $acs_lang_url -element object_id] \
-privilege admin \
-party_id [ad_conn untrusted_user_id]]
set toggle_translator_mode_url [export_vars -base "${acs_lang_url}admin/translator-mode-toggle" \
{ { return_url [ad_return_url] } }]
13. Restart the server
14. Login in.
15. Go to acs-admin/apm/package-install via URL
16. Check all the packages and services to upgrade, click next and then install all (ignore the errors messages)
17. Restart server
18. When its done go to site-map and add (at root level) the folder acs-lang
19. In that folder mount the service OpenACS Localization Utils
20. Kill the server
21. Change back the set lang_admin_p in blank_master.tcl to look like it was:
set lang_admin_p [permission::permission_p \
-object_id [site_node::get_element -url $acs_lang_url -element object_id] \
-privilege admin \
-party_id [ad_conn untrusted_user_id]]
set toggle_translator_mode_url [export_vars -base "${acs_lang_url}admin/translator-mode-toggle" \
{ { return_url [ad_return_url] } }]
22. Remove the zzz-postload.tcl file from openacs-5.0.0/tcl
23. Restart the server, and you are done.
Download the steps text file
here.
I hope this will be useful for someone else.
