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
- Make a backup copy of the existing event database.
- Go to the profile_root/bin directory.
- 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.