WebSphere

Upgrading an Oracle event database from Version 5

If you have an existing Oracle event database from Version 5.1 of Common Event Infrastructure, you must upgrade it to the current version.

About this task

To upgrade an Oracle event database:
Procedure
  1. Make a backup copy of the existing event database.
  2. Go to the profile_root/bin directory.
  3. Run the Oracle upgrade script for your operating system:
    • Windows® systems:
      eventUpgradeOracle runUpgrade=[true|false] schemaUser=schemauser
        [oracleHome=dir] [dbName=name]
        [dbUser=sysuser] [dbPassword=pw]
        [scriptDir=dir]
    • Linux® and UNIX® systems:
      eventUpgradeOracle.sh runUpgrade=[true|false] schemaUser=schemauser
        [oracleHome=dir] [dbName=name]
        [dbUser=sysuser] [dbPassword=pw]
        [scriptDir=dir]
    The typical required parameters are as follows:
    runUpgrade
    Indicates whether you want the upgrade script to automatically run the generated DDL scripts to complete the database upgrade. This parameter is required. Specify false if you want to manually upgrade the database at a later time or on a different system.
    schemaUser
    Specifies the Oracle user ID that owns the database tables. This parameter is required.
    oracleHome
    Specifies the Oracle home directory. This parameter is required if you specified runUpgrade=true.
    dbName
    Specifies the Oracle database name. The default name for the event database is event. This parameter is required if you specified runUpgrade=true.
    dbUser
    Specifies the Oracle sys user ID. This parameter is required if you specified runUpgrade=true.
    dbPassword
    Specifies the password for the sys user ID. Do not specify this parameter if the sys user ID has no password.
    scriptDir
    Specifies the directory you want to contain the generated DDL scripts. This parameter is optional; if you do not specify a directory, the scripts are stored in the .\eventDBUpgrade\oracle directory.

    To see a complete list of parameters and usage information, run the eventUpgradeOracle script with no parameters.

Results

The upgrade script generates the required DDL scripts for upgrading the event database. If you specified runUpgrade=true, the DDL scripts are automatically run, completing the upgrade.

Example

The following example upgrades an existing Oracle database on a Windows system:
eventUpgradeOracle runUpgrade=true schemaUser=cei
  dbName=event dbUser=sys

What to do next

If you specified runUpgrade=false, you must manually run the DDL scripts on the database system to complete the database upgrade.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_upgrade_db_oracle.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).