Transfer Oracle using the configuration wizard

 

+
Search Tips   |   Advanced Search

 

This file provides information on how to transfer the data between databases using the configuration wizard.

Both the database you are transferring from and the database you are transferring to must be running in order to support the data transfer.

Perform this task on the computer hosting IBM WebSphere Portal. For additional help during transfer, use the Help button located in the configuration wizard window.

 

Before you begin

Before configuring databases, ensure that the following prerequisites are met:

  • Supported database software is installed.

  • Databases and users are correctly setup for use by IBM WebSphere Portal.

  • If you are using DB2 Fix Pack 10, DB2 Fix Pack 11, or DB2 Fix Pack 12, complete the following steps prior to database transfer. This fix should be applied to both the client side and server side of the DB2 installation. Failure to follow these steps will cause the database transfer to hang at the task action-process-constraints.

    If you are running a remote z/OS database, the fix should be applied to the client side only.

    1. Locate the following file:

      • UNIX:

        /home/db2inst1/sqllib/cfg/db2cli.ini

      • Windows:

        db2home/sqllib/db2cli.ini

    2. Edit the file by adding the following to the end of the file:

      • For Fix Pack 10 or Fix Pack 11:

        [COMMON]
        DYNAMIC=1
        
        

        An empty line is required after the dynamic=1 at the end of the file.

      • For Fix Pack 12:

        [COMMON]
        ReturnAliases=0
        
        

        An empty line is required after the ReturnAliases=0 at the end of the file.

  1. Start server1 and stop WebSphere Portal.

  2. See Configuring WebSphere Portal with the configuration wizard for information on how to start the configuration wizard.

  3. In the Select the configuration task that you want to perform dialog box, select Transfer Data to Another Database, and then click Next.

  4. If the WebSphere Application Server global security is enabled... dialog box appears, type the IBM WAS administrative user name and password in the appropriate fields, and then click Next.

    Passwords should not contain spaces.

  5. In the Source domain dialog box, select the database type that you want to transfer from, and then click Next. You may choose to transfer all domains, or select any combination of the following domains:

  6. In the Target domain dialog box, select the database type that you want to transfer to, and click Next.

  7. In the properties dialog box, review the properties and values for the database(s) that you are transferring to. Modify the values for the environment, and click Next. Repeat this step for each database you are transferring.

  8. In the properties dialog box, review the properties and values for the domains that you are transferring to. Modify the values for the environment, and click Next. Repeat this step for each domain you are transferring.

  9. In the summary dialog box, review the settings for the database transfer. If changes are necessary, click Back, otherwise, click Next to begin transferring data.

  10. In the Running task dialog box, the status bar will show the progress of the transfer. To view the log file for the transfer, click Open. Once the transfer has completed, click Next.

  11. If the task runs successfully, the message The wizard ran the task successfully will be displayed. Click Finish to exit the wizard.

  12. If the task runs with errors, the message The wizard ran the task with errors will be displayed. For more information, click Open Message File. To perform additional configuration, click Run Wizard Again. Click Finish to exit the wizard.

 

Parent Topic

Transfer individual domains