Creating an Oracle database for scheduler

Why and when to perform this task

Steps for this task

  1. Open a command-line window.
  2. Make sure that you have administrator rights for the database system.
  3. If you want to use an existing database, skip to step 5.

    Note: Make sure that the database supports Unicode (UTF-8). Otherwise, it cannot store all characters that can be handled in the Java code, and you could run into codepage conversion problems when a client uses an incompatible codepage.

  4. Use the Database Configuration Assistant to create a database named scheddb.
    Make sure that you select the JServer option for the database. It is recommended to use a Unicode codepage when creating the database. The text data you pass to the APIs must be compatible with the selected codepage.
  5. Create the table space and schema.
    1. Using a text editor, edit the scripts %WAS_HOME%\Scheduler\createTablespaceOracle.ddl and %WAS_HOME%\Scheduler\createSchemaOracle.ddl according to the instruction at the top of the files.
    2. If you do not want the schema to be created in the default instance, set the environment variable ORACLE_SID
    3. To create the table space, run the script createTablespaceOracle.ddl.
      For test purposes you can use the same location for all table spaces and pass the path as a command line argument to the script, for example, on Windows, user ID scheduser, password schedpwd, database name scheddb, and table space path d:\mydb\ts, enter the command:
      sqlplus scheduser/schedpwd@scheddb @createTablespaceOracle.ddl d:\mydb\ts
      If you get any errors creating the table space, you can use dropTablespaceOracle.ddl to drop the table space.
    4. To create the schema, run the script createSchemaOracle.ddl.
      For example, on Windows systems, enter:
      sqlplus scheduser/schedpwd@scheddb @createSchemaOracle.ddl
      If you get any errors creating the schema (tables and views), you can use dropSchemaOracle.ddl to drop the schema.

Results

The Oracle database for scheduler exists.



Searchable topic ID:   tsch_codbor
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/scheduler/tasks/tsch_codbor.html

Library | Support | Terms of Use | Feedback