WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Creating the Oracle database

In order to create a Common database manually, you need to edit and run the scripts that come with the WebSphere® ESB. This topic tells you how to edit and run scripts associated with the Oracle database.

About this task

Before you can run scripts to create an Oracle database manually, you need to customize them for WebSphere ESB. WebSphere ESB comes with following scripts:
Table 1. Oracle scripts for WebSphere ESB
configCommonDB.bat
configCommonDB.sh
createDatabase_commonDB.sql
 
createTable_commonDB.sql
 
createTable_EsbLoggerMediation.sql
createTable_governancerepository.sql
 
 
createTable_Recovery.sql
createTable_RelationshipMetadataTable.sql
createTable_RelationshipViewMetaaTable.sql
insertTable_CommonDB.sql
Procedure
  1. Make sure that you are using a user ID with sufficient authority to update the database schema.
  2. Locate the directory where the database scripts are located:
    • For Linux operating systemFor UNIX operating system media_root/dbscripts/CommonDB/oracle or <extract_directory>/dbscripts/CommonDB/oracle
    • For Windows operating system media_root\dbscripts\CommonDB\oracle or <extract_directory>\dbscripts\CommonDB\oracle
  3. Locate the createSchema_CommonDB.sql file which is a template used to create required schemas. To create a database schema:
    1. Replace the DB_USER variable with the database schema name. For example, orauser.
    2. Replace the dbCommonPassword variable with the database schema password. For example, youNameIt. If not changed, you will be requested to enter a password for the DB_USER.
    3. Repeat the above steps for each additional schema.
    The following components require a schema. These schemas will be generated automatically if not passed during profile creation. The default schemas are:
    Table 2. Default schemas
    Component Default value
    CommonDB first3CharOfSIDCOMM
    Business Space IBMBUSSP
    SCA.SYSTEM ME first3CharOfSIDSS00
    SCA.APP ME first3CharOfSIDSA00
    CEI ME first3CharOfSIDCM00
    BPC ME first3CharOfSIDBM00
    CEI first3CharOfSIDCEID

    For the above parameters, the value of the password depends on how you configure the profile. The Value can be a dbPassword or the value that is used while running the manageprofiles command. To run these scripts you must have SYSDBA privileges.

  4. Locate the configCommonDB.bat or configCommonDB.sh file and perform following subtasks:
    1. Replace the DB_NAME variable with the Oracle Database name [SID], for example ORCL.
    2. Replace the DB_USER variable with Oracle user, for example orauser.
  5. Locate the insertTable_CommonDB.sql file and replace the following variables with the WebSphere ESB version you are installing. For example, if the WebSphere ESB version is 6.2.0.0 then:
    1. Replace the MajorVersion variable with the first digit of the product version number, for example 6.
    2. Replace the MinorVersion variable with the second digit of the product version number, for example 2.
    3. Replace the RefreshPackLevel variable with the third digit of the product version number, for example 0.
    4. Replace the FixPackLevel variable with the fourth digit of the product version number, for example 0.
  6. Copy all of the scripts from the extract_directory\dbscripts\CommonDB directory to the Oracle workstation and run the configCommonDB.bat or configCommonDB.sh script. Specify the database schema name as orcCOMM. Ensure that the common database schema or user is created (in Step 3) before running this script because it uses common database user to connect the database for creating tables.

Results

The Oracle database is created.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


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