+

Search Tips   |   Advanced Search

Update 4.0 and 4.5 Oracle databases manually


Overview

Manually update IBM Connections 4.0 or 4.5 databases to v5.0 in an existing IBM WebSphere Application Server and Oracle database environment.

Use the JRE under the Wizards directory. Update the PATH variable to point to this JRE. For example...

IBM Connections does not support GNU Java.

Use a database administrator ID to run the Java migration utilities.

After running each command, review output closely for error messages. Resolve errors before proceeding.

Before applying updates, back up Connections.

Install supporting software for v5.0.

Set the Statement cache size for the data sources on WAS to be no larger than 50. A higher value could lead to Out Of Memory errors on the application server instance.

Connections databases use SMALLFILE tablespaces with a size limitation of 222 blocks. When using 8 KB blocks, this limit is approximately 32 GB. If we anticipate needing more space than this, add additional tablespace files to individual databases.

Use this procedure if you want an alternative to using the database wizard to update the databases.


Update Oracle databases manually

  1. Log on to the WAS console on the dmgr and go to...

      Applications | Application types | WebSphere Enterprise Applications

  2. Stop all Connections applications.

  3. Ensure the Oracle driver on the system has the same version number as the Oracle database server.

  4. cd WP_PROFILEhe directory containing the scripts.

  5. For each application, manually create the application database table...

  6. Log on to Oracle

      sqlplus /as sysdba
      sql> spool on
      sql> spool /path/to/output.log

  7. cd Wizards/connections.sql/homepage/oracle

  8. Check the database schema version...

      select DBSCHEMAVER from HOMEPAGE.HOMEPAGE_SCHEMA

    For version 110, run:

      @upgrade-40-40CR2.sql
      @upgrade-40CR2-45.sql

    Also, run a java migration from 4.0 to 4.5.

    Then, resume executing the upgrade commands.

      @upgrade-45-45CR3.sql
      @upgrade-45CR3-45CR4.sql
      @upgrade-45CR4-50.sql

    Run a java migration from 4.5 to 5.0.

    Resume executing the upgrade commands

      @appGrants.sql

    For version 132, then enter the following command:

      @upgrade-40CR2-45.sql

    Also, run a java migration from 4.0 to 4.5.

    Then, resume executing the upgrade commands.

      @upgrade-45-45CR3.sql
      @upgrade-45CR3-45CR4.sql
      @upgrade-45CR4-50.sql

    run a java migration from 4.5 to 5.0.

    Resume executing the upgrade commands.

      @appGrants.sql

    For version 210, run:

      @upgrade-45-45CR3.sql
      @upgrade-45CR3-45CR4.sql
      @upgrade-45CR4-50.sql

    Run a java migration from 4.5 to 5.0.

    Resume executing the upgrade commands.

      @appGrants.sql

    For version 211, run:

      @upgrade-45CR3-45CR4.sql
      @upgrade-45CR4-50.sql

    Run a java migration from 4.5 to 5.0.

    Resume executing the upgrade commands:

      @appGrants.sql

    For version 213, run:

      @upgrade-45CR-50.sql

    Next, run a java migration from 4.5 to 5.0.

    Then, resume executing the upgrade commands:

      @appGrants.sql

    For version 475, run:

      @appGrants.sql

  9. cd Wizards/connections.sql/activities/oracle

  10. Check DB schema version...

      select DBSCHEMAVER from ACTIVITIES.OA_SCHEMA

    For version 53, run:

      @upgrade-40-45.sql
      @upgrade-45-50.sql
      @appGrants.sql

    For version 56, run:

      @upgrade-45-50.sql
      @appGrants.sql
      @runstats.sql

    For version 69, run:

      @appGrants.sql

  11. cd Wizards/connections.sql/blogs/oracle

  12. Check DB schema version...

      select value from BLOGS.roller_properties where name='database.schema.version'

    For version 43, run:

      @upgrade-40-45.sql
      @upgrade-45-45CR4.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 51, run:

      @upgrade-45-45CR4.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 52, run:

      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 69, run:

      @appGrants.sql

  13. cd Wizards/connections.sql/dogear/oracle

  14. Check DB schema version...

      select DBSCHEMAVER from DOGEAR.DOGEAR_SCHEMA

    For version 14, run:

      @upgrade-40-45.sql
      @upgrade-45-50.sql
      @appGrants.sql

    For version 15, then enter the following command:

      @upgrade-45-50.sql
      @appGrants.sql
      @runstats.sql

    For version 22, run...

      @appGrants.sql

  15. cd Wizards/connections.sql/communities/oracle

  16. Check the database schema version...

      select DBSCHEMAVER from SNCOMM.SNCOMM_SCHEMA

    For version 76, run:

      @pgrade-40-45.sql
      @upgrade-45-50.sql
      @appGrants.sql

    For version 77, run:

      @upgrade-45-50.sql
      @appGrants.sql

    For version 92, run:

      @appGrants.sql

  17. cd Wizards/connections.sql/calendar/oracle

  18. Check the database schema version...

      select DBSCHEMAVER from CALENDAR.CA_SCHEMA

    For version 10, run:

      @calendar-upgrade-40-45.sql
      @calendar-upgrade-45-50.sql
      @calendar-appGrants.sql
      @calendar-runstats.sql

    For version 15, run:

      @calendar-upgrade-45-50.sql
      @calendar-appGrants.sql
      @calendar-runstats.sql

    For version 29, run:

      @calendar-appGrants.sql
      @calendar-runstats.sql

  19. cd Wizards/connections.sql/files/oracle

  20. Check the database schema version

      select SCHEMA_VERSION from "FILES"."PRODUCT"

    For version 79, run:

      @upgrade-40-45.sql
      @upgrade-45-45CR3.sql
      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 82, run:

      @upgrade-45-45CR3.sql
      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 89, run:

      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 106, run:

      @appGrants.sql

  21. cd Wizards/connections.sql/forum/oracle

    Check the database schema version:

      select DBSCHEMAVER from FORUM.DF_SCHEMA

    For version 21, run:

      @upgrade-40-45.sql
      @upgrade-45-50.sql
      @appGrants.sql

    For version 27, run:

      @upgrade-45-50.sql
      @appGrants.sql

    For version 35, run:

      @appGrants.sql

  22. cd Wizards/connections.sql/metrics/oracle

  23. Check the database schema

      select SCHEMA_VERSION from "METRICS"."PRODUCT"

    For version 29, run:

      @upgrade-40-40CR3.sql
      @upgrade-40CR3-45.sql
      @upgrade-45-45CR2.sql
      @fixup-LO77552.sql
      @upgrade-45CR2-45CR3.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 30, run:

      @upgrade-40CR3-45.sql
      @upgrade-45-45CR2.sql
      @fixup-LO77552.sql
      @upgrade-45CR2-45CR3.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 34, run:

      @upgrade-45-45CR2.sql
      @fixup-LO77552.sql
      @upgrade-45CR2-45CR3.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 37, run:

      @fixup-LO77552.sql
      @upgrade-45CR2-45CR3.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 38, run:

      @appGrants.sql

  24. cd Wizards/connections.sql/mobile/oracle

  25. Check the database schema version...

      select VALUE from MOBILE.ROLLER_PROPERTIES where NAME='database.schema.version'

    For version 4.0.0.0.0, run:

      @upgrade-40-45.sql
      @upgrade-45-45CR4.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 4.5.0.0.0, run:

      @upgrade-45-45CR4.sql
      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 2, run:

      @upgrade-45CR4-50.sql
      @appGrants.sql

    For version 7, run:

      @appGrants.sql

  26. cd Wizards/connections.sql/profiles/oracle

  27. Check the database schema version...

      select DBSCHEMAVER from EMPINST.SNPROF_SCHEMA

    For version 33, run:

      @upgrade-40-45.sql
      @upgrade-45-50.sql
      @appGrants.sql
      @clearScheduler.sql

    For version 36, run:

      @upgrade-45-50.sql
      @appGrants.sql
      @clearScheduler.sql

    For version 45, run:

      @appGrants.sql
      @clearScheduler.sql

  28. cd Wizards/connections.sql/wikis/oracle

  29. Check the database schema version...

      select SCHEMA_VERSION from "WIKIS"."PRODUCT"

    For version 79, run:

      @upgrade-40-45.sql
      @upgrade-45-45CR3.sql
      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 82, run:

      @upgrade-45-45CR3.sql
      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 89, run:

      @upgrade-45CR3-50.sql
      @appGrants.sql

    For version 102, run:

      @appGrants.sql


Parent topic:
Update 4.0 and 4.5 databases manually


Related:

Access the News configuration file

Back up IBM Connections DBS and file systems