Forum OpenACS Development: Re: Upgrading openacs 4-6-3 to 5-0-0 with Oracle 8.1.6 problems?

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.