Update 2.5 Oracle databases manually 

Manually update IBM Lotus Connections 2.5 databases to version 3.0.1 in an existing IBM WAS and Oracle database environment.


Before starting


Before applying updates, back up your databases. For more information, see the Backing up IBM Connections topic.

Ensure that you have installed and configured all supporting software for version 3.0.1.


About this task


This topic describes how to manually update Lotus Connections version 2.5 databases to version 3.0.1. Use this procedure if you want an alternative to using the database wizard to update your databases.

Notes:

To update databases manually...


Procedure

  1. Log in to the WAS admin console on your dmgr.

  2. Go to Applications -> Application types -> WebSphere enterprise Applications.

  3. Stop all Lotus Connections applications.

  4. Ensure that the Oracle driver on your system has the same version number as your Oracle database server. IBM Connections does not support the Oracle 10.2.0.1 JDBC driver.

  5. Change to the directory containing the scripts.

  6. For each application, enter the following command and then run the appropriate scripts:

      sqlplus /as sysdba

      Note: To capture the output of each command to a log file, run the following commands before starting this task:

      sql> spool on

      sql> spool <output_file>

      where <output_file> is the full path and name of the file where the output is captured.

      When you have completed this task, run the following command: sql> spool off

  7. Activities: Wizards/connections.sql/activities/oracle

    1. @upgrade-25-30.sql

    2. @appGrants.sql

    3. @upgrade-30-301.sql

    4. @appGrants.sql

  8. Blogs: Wizards/connections.sql/blogs/oracle

    1. @upgrade-25-30.sql

    2. From a command prompt, change to the Wizards directory and enter the following text as a single command:

      • AIX or Linux:

          jvm/<OS>/jre/bin/java -classpath

          <jdbc_library_location>/ojdbc5.jar:

          lib/lc.dbmigration.default.jar:

          lib/blogs.migrate.jar:

          lib/commons-lang-2.0.jar:

          lib/commons-logging-1.0.4.jar

          com.ibm.lconn.blogs.migration.MigrationFrom25To30

-dburl jdbc:oracle:thin:@//<dbHost>:<dbPort>/<ServiceName> | -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<SID>


          -dbuser <dbUser> -dbpassword <dbPassword>

          Note: Enter the appropriate dburl parameter depending on whether you are using SERVICE_NAME or SID.

      • Windows:

          jvm/win/jre/bin/java -classpath

          <jdbc_library_location>\ojdbc5.jar;

          lib\lc.dbmigration.default.jar;

          lib\blogs.migrate.jar;

          lib\commons-lang-2.0.jar;

          lib\commons-logging-1.0.4.jar

          com.ibm.lconn.blogs.migration.MigrationFrom25To30

-dburl jdbc:oracle:thin:@//<dbHost>:<dbPort>/<ServiceName> | -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<SID>


          -dbuser <dbUser> -dbpassword <dbPassword>

          Note:

Enter the appropriate dburl parameter depending on whether you are using SERVICE_NAME or SID.

        where

        • <jdbc_library_location> is the location of your JDBC driver

        • <dbHost> is the name of the system hosting your database

        • <dbPort> is the communications port for the database

        • <dbAlias> is the reserved name of the database, if applicable

        • <dbUser> is the database user ID

        • <dbPassword> is the administrator password

    1. @appGrants.sql

    2. @upgrade-30-301.sql

    3. From a command prompt, change to the Wizards directory and enter the following text as a single command:

      • AIX or Linux:

          jvm/<OS>/jre/bin/java -classpath

          <jdbc_library_location>/ojdbc14.jar:

          lib/lc.dbmigration.default.jar:

          lib/blogs.migrate.jar:

          lib/commons-lang-2.0.jar:

          lib/commons-logging-1.0.4.jar

          com.ibm.lconn.blogs.migration.MigrationFrom30To301

          -dburl jdbc:oracle:thin@//<dbHost>/<dbInstance>

          -dbuser <dbUser> -dbpassword <dbPassword>

          {-SID=<SID> | -SERVICENAME=<SERVICE_NAME> -INDEXTABSPACE=<INDEXTABSPACE>}

          where

          • <SID> is the Oracle SID when the database is configured to use SID

          • <SERVICE_NAME> is the Oracle SERVICE_NAME when the database is configured to use SERVICE_NAME

          • <INDEXTABSPACE> is the index table space of a database where you have customized the table space naming

          Note: The parameters in braces ({}) are optional.

      • Windows:

          jvm/win/jre/bin/java -classpath

          <jdbc_library_location>\ojdbc14.jar;

          lib\lc.dbmigration.default.jar;

          lib\blogs.migrate.jar;

          lib\commons-lang-2.0.jar;

          lib\commons-logging-1.0.4.jar

          com.ibm.lconn.blogs.migration.MigrationFrom30To301

          -dburl jdbc:oracle:thin@//<dbHost>/<dbInstance>

          -dbuser <dbUser> -dbpassword <dbPassword>

          {-SID=<SID> | -SERVICENAME=<SERVICE_NAME> -INDEXTABSPACE=<INDEXTABSPACE>}where

          • <SID> is the Oracle SID when the database is configured to use SID

          • <SERVICE_NAME> is the Oracle SERVICE_NAME when the database is configured to use SERVICE_NAME

          • <INDEXTABSPACE> is the index table space of a database where you have customized the table space naming

          Note: The parameters in braces ({}) are optional.

        and where

        • <jdbc_library_location> is the location of your JDBC driver

        • <dbHost> is the name of the system hosting your database

        • <dbPort> is the communications port for the database

        • <dbAlias> is the reserved name of the database, if applicable

        • <dbUser> is the database user ID

        • <dbPassword> is the administrator password

    4. @appGrants.sql

  1. Communities: Wizards/connections.sql/forum/oracle

      Note: These commands create a Forums database and then update the Communities database.

      1. @createDb.sql

      2. @appGrants.sql

      3. @uninteg.sql

      4. From a command prompt, change to the Wizards directory and enter the following text as a single command:

        • AIX or Linux:

            jvm/<OS>/jre/bin/java -classpath

            <jdbc_library_location>/ojdbc14.jar:

            lib/lc.dbmigration.default.jar:

            lib/forum.migrate.jar:

            lib/commons-lang-2.0.jar:

            lib/commons-logging-1.0.4.jar

            com.ibm.lconn.forum.migration.MigrationFrom25To30

            -dburl "jdbc:oracle:thin:@//<3.0.1_dbHost>:<3.0.1_dbPort>/<3.0.1_ServiceName|SID>"

            -dbuser DFUSER -dbpassword <3.0.1_DFUSER_Password>

            -srcdburl "jdbc:oracle:thin:@//<2.5_dbHost>:<2.5_dbPort>/<2.5_dbInstance|SID>"

            -srcdbuser SNCOMMUSER -srcdbpassword <2.5_SNCOMMUSER_Password>

            • <SID> is the Oracle SID when the database is configured to use SID

            • <ServiceName> is the Oracle SERVICE_NAME when the database is configured to use SERVICE_NAME

        • Windows:

            jvm/win/jre/bin/java -classpath

            <jdbc_library_location>\ojdbc14.jar:

            lib/lc.dbmigration.default.jar:

            lib/forum.migrate.jar:

            lib/commons-lang-2.0.jar:

            lib/commons-logging-1.0.4.jar

            com.ibm.lconn.forum.migration.MigrationFrom25To30

            -dburl "jdbc:oracle:thin:@//<3.0.1_dbHost>:<3.0.1_dbPort>/<3.0.1_ServiceName|SID>"

            -dbuser DFUSER -dbpassword <3.0.1_DFUSER_Password>

            -srcdburl "jdbc:oracle:thin:@//<2.5_dbHost>:<2.5_dbPort>/<2.5_dbInstance|SID>"

            -srcdbuser SNCOMMUSER -srcdbpassword <2.5_SNCOMMUSER_Password>

            where

            • <SID> is the Oracle SID when the database is configured to use SID

            • <ServiceName> is the Oracle SERVICE_NAME when the database is configured to use SERVICE_NAME

          where

          • <3.0.1_dbHost> is the name of the system hosting your IBM Connections 3.0.1 database

          • <3.0.1_dbPort> is the communications port for the database

          • <3.0.1_dbInstance> is the name of the instance

          • <3.0.1_SNCOMMUSER_Password> is the password for the 3.0.1 Communities database user ID

          • <2.5_dbHost> is the name of the system hosting your Lotus Connections 2.5 database

          • <2.5_dbPort> is the communications port for the database

          • <2.5_dbInstance> is the name of the instance

          • <2.5_SNCOMMUSER_Password> is the password for the 2.5 Communities database user ID

      5. @integ.sql

      6. Change to the Wizards/connections.sql/communities/oracle directory and run the scripts in the following steps.

      7. @drop_lc25_forum_tables.sql

      8. @upgrade-25-30a.sql

      9. @upgrade-25-30b.sql

      10. @appGrants.sql

      11. @upgrade-30-301.sql

      12. @appGrants.sql

  2. Dogear: Wizards/connections.sql/dogear/oracle

    1. @upgrade-25-30.sql

    2. @appGrants.sql

    3. @upgrade-30-301.sql

    4. @appGrants.sql

  3. Files: Wizards/connections.sql/files/oracle

    1. @upgrade-25-30.sql

    2. @appGrants.sql

    3. @upgrade-30-301.sql

    4. @appGrants.sql

  4. Home page: Wizards/connections.sql/homepage/oracle

    1. @upgrade-25-30a.sql

    2. @upgrade-25-30b.sql

    3. @appGrants.sql

    4. From a command prompt, change to the Wizards directory and enter the following text as a single command:

      • AIX or Linux:

          jvm/<OS>/jre/bin/java -classpath

          <jdbc_library_location>/ojdbc14.jar:

          lib/news.migrate.jar:

          lib/news.core.data.jar:

          lib/news.core.service.jar:

          lib/news.common.jar:

          lib/lc.admin.userlifecycle.spi.jar:

          lib/lc.events.newsEjbConsumer.jar:

          lib/lc.dbmigration.default.jar:

          lib/ibatis-2.3.0.677.jar:

          lib/spring.jar:

          lib/commons-logging-1.0.4.jar:

          lib/commons-dbcp-1.2.1.jar:

          lib/commons-collections-3.2.1.jar:

          lib/commons-pool-1.2.jar:

          lib/commons-lang-2.4.jar

          com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30
          Note: If you receive an Out Of Memory exception when running this command, you need to increase the memory allocation. Run the command again but with the -Xmx parameter. For example: -Xmx512 com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30

          -dburl jdbc:oracle:thin@<dbHost>:<dbPort>/<ServiceName> | -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<SID>

          -dbuser <dbUser> -dbpassword <dbPassword>

          where <OS> is the operating system on which the database is hosted.

      • Windows:

          jvm\win\jre\bin\java -classpath

          <jdbc_library_location>\ojdbc14.jar;

          lib\news.migrate.jar;

          lib\news.core.data.jar;

          lib\news.core.service.jar;

          lib\news.common.jar;

          lib\lc.admin.userlifecycle.spi.jar;

          lib\lc.events.newsEjbConsumer.jar;

          lib\lc.dbmigration.default.jar;

          lib\ibatis-2.3.0.677.jar;

          lib\spring.jar;

          lib\commons-logging-1.0.4.jar;

          lib\commons-dbcp-1.2.1.jar;

          lib\commons-collections-3.2.1.jar;

          lib\commons-pool-1.2.jar;

          lib\commons-lang-2.4.jar

          com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30
          Note: If you receive an Out Of Memory exception when running this command, you need to increase the memory allocation. Run the command again but with the -Xmx parameter. For example: -Xmx512 com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30

          -dburl jdbc:oracle:thin@<dbHost>:<dbPort>/<ServiceName> | -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<SID>

          -dbuser <dbUser> -dbpassword <dbPassword>

        where

        • <jdbc_library_location> is the location of your JDBC driver

        • <dbHost> is the name of the system hosting your database

        • <dbPort> is the communications port for the database

        • <dbAlias> is the reserved name of the database, if applicable

        • <dbUser> is the database user ID

        • <dbPassword> is the administrator password

    5. From a command prompt, change to the Wizards directory and enter the following text as a single command:

      • AIX or Linux:

          jvm/<OS>/jre/bin/java -classpath

          <jdbc_library_location>/ojdbc14.jar:

          lib/news.migrate.jar:

          lib/news.core.data.jar:

          lib/news.core.service.jar:

          lib/news.common.jar:

          lib/lc.admin.userlifecycle.spi.jar:

          lib/lc.events.newsEjbConsumer.jar:

          lib/lc.dbmigration.default.jar:

          lib/ibatis-2.3.0.677.jar:

          lib/spring.jar:

          lib/commons-logging-1.0.4.jar:

          lib/commons-dbcp-1.2.1.jar:

          lib/commons-collections-3.2.1.jar:

          lib/commons-pool-1.2.jar:

          lib/commons-lang-2.4.jar

          com.ibm.lconn.news.migration.NewsMigrationFrom25To30

          -dburl jdbc:oracle:thin@<dbHost>:<dbPort>/HOMEPAGE

          -dbuser <dbUser> -dbpassword <dbPassword>

          where <OS> is the operating system on which the database is hosted.

      • Windows:

          jvm\win\jre\bin\java -classpath

          <jdbc_library_location>\ojdbc14.jar;

          lib\news.migrate.jar;

          lib\news.core.data.jar;

          lib\news.core.service.jar;

          lib\news.common.jar;

          lib\lc.admin.userlifecycle.spi.jar;

          lib\lc.events.newsEjbConsumer.jar;

          lib\lc.dbmigration.default.jar;

          lib\ibatis-2.3.0.677.jar;

          lib\spring.jar;

          lib\commons-logging-1.0.4.jar;

          lib\commons-dbcp-1.2.1.jar;

          lib\commons-collections-3.2.1.jar;

          lib\commons-pool-1.2.jar;

          lib\commons-lang-2.4.jar

          com.ibm.lconn.news.migration.NewsMigrationFrom25To30

          -dburl jdbc:oracle:thin@<dbHost>:<dbPort>/HOMEPAGE

          -dbuser <dbUser> -dbpassword <dbPassword>

    6. @upgrade-30-301.sql

    7. @appGrants.sql

  5. Profiles: Wizards/connections.sql/profiles/oracle

    1. @upgrade-25-30.sql

    2. @appGrants.sql

    3. @upgrade-30-301.sql

    4. @appGrants.sql

  6. Wikis: Wizards/connections.sql/wikis/oracle

    1. @upgrade-25-30.sql

    2. @appGrants.sql

    3. @upgrade-30-301.sql

    4. @appGrants.sql

  7. Migrate your 2.5 themes: From a command prompt, change to the Wizards directory and enter the following text as a single command:

    • AIX or Linux:

        jvm/<OS>/jre/bin/java -classpath

        <jdbc_library_location>/ojdbc14.jar:

        lib/lc.dbmigration.default.jar:

        lib/sncomm.migrate.jar:

        lib/commons-lang-2.0.jar:

        lib/commons-logging-1.0.4.jar

        com.ibm.tango.migrate.MigrateCommunityTheme_2_5_To_3_0

        -source oracle SNCOMM <2.5_dbHost> <2.5_dbPort> <2.5_dbUser> <2.5_dbPassword> {-SID=<SID> | -SERVICE_NAME=<ServiceName>}

        -target oracle <3.0.1_database> <3.0.1_dbHost> <3.0.1_dbPort> <3.0.1_dbAdmin><3.0.1_dbPassword> {-SID=<SID> | -SERVICE_NAME=<ServiceName>}

    • Windows:

        jvm\win\jre\bin\java -classpath

        <jdbc_library_location>\ojdbc14.jar;

        lib\lc.dbmigration.default.jar;

        lib\sncomm.migrate.jar;

        lib\commons-lang-2.0.jar;

        lib\commons-logging-1.0.4.jar

        com.ibm.tango.migrate.MigrateCommunityTheme_2_5_To_3_0

        -source oracle SNCOMM <2.5_dbHost> <2.5_dbPort> <2.5_dbUser> <2.5_dbPassword> {-SID=<SID> | -SERVICE_NAME=<ServiceName>}

        -target oracle <3.0.1_database> <3.0.1_dbHost> <3.0.1_dbPort> <3.0.1_dbAdmin> <3.0.1_dbPassword> {-SID=<SID> | -SERVICE_NAME=<ServiceName>}

      where

      • <2.5_dbHost> is the name of the system hosting your Lotus Connections 2.5 database,

      • <2.5_dbPort> is the communications port for the database

      • <2.5_dbAdmin> is the 2.5 database administrator ID

      • <2.5_dbPassword> is the administrator password

      • <3.0.1_database> is the database for the Activities, Blogs, and Wikis applications

      • <3.0.1_dbHost> is the name of the system hosting your IBM Connections 3.0.1 database

      • <3.0.1_dbPort> is the communications port for the database

      • <3.0.1_dbAdmin> is the 3.0.1 database administrator ID

      • <3.0.1_dbPassword> is the administrator password


What to do next


Check that all the databases are working correctly.


Parent topic

Update 2.5 databases manually

+

Search Tips   |   Advanced Search