Create Oracle databases for schedulers

Create Oracle databases for schedulers using data definition language (DDL) or SQL files.

To create Oracle databases for schedulers, using data definition language (DDL) or SQL files, use these steps.

1. Open a command-line window.

2. Make sure that we have administrator rights for the database system.

3. Verify that the database supports Unicode (UTF-8). Otherwise, the database does not store all characters that can be handled in the Java code, which results in code page conversion problems, when a client uses an incompatible code page.

4. Use the Database Configuration Assistant to create the database, scheddb, for example. Verify selected the JServer option for the database. Use a Unicode code page when creating the database. The text data you pass to the APIs must be compatible with the selected code page.

Results

The Oracle database for scheduler exists.

Data source minimum required settings, by vendor