2 Configuration Tasks for Oracle BI Scheduler

This chapter explains that depending on your specific deployment, you must perform the following Oracle BI Scheduler configuration tasks:

Keep the following points in mind:

2.1 Configuring a Database for the Oracle BI Scheduler

You can use Fusion Middleware Control to configure common settings that are used by agents with Oracle BI Scheduler.


You can automatically populate or repopulate credential information from the Weblogic data source. If connectivity details change (for example, password expiry or database failure), then you update the Weblogic BI platform data source and run DH/bitools/bin/sync_midtier_db.sh.

The file DH/config/fmwconfig/biconfig/OBISCH/schedulerconfig.xml contains the DSN name, and the credentials are stored in oracle.bi.system map datasource.biplatform key (visible in EM).

The following procedure describes how to configure the back-end database and tables:

2.1.1 Configuring a System DSN entry for SQL Server Databases

For SQL Server databases, the Data Source Name (DSN) that is used in the Fusion Middleware Control Scheduler configuration must match an existing ODBC DSN for the SQL Server S_NQ_SCHED database.

If you do not have a System DSN entry, then create a new one as described in the following procedure.

To configure the SQL Server database DSN entry:

  1. From the Windows Start menu, select Settings, then Control Panel, then Administrative Tools, then Data Sources (ODBC).

  2. Start the ODBC Data Source Administrator.

  3. Select the System DSN tab, and click Add.

  4. Select the driver SQL Server, and click Finish.

  5. In the Create a New Data Source to SQL Server wizard, do the following:

    1. Enter a name and description for the data source.

    2. Select the SQL Server from the Server list, and click Next.

    3. For server verification of the login ID authenticity, select the appropriate authentication for the S_NQ_SCHED SQL Server database schema. Click Next.

  6. Select the Change the default database to field and select the S_NQ_SCHED database from the list. Click Next.

  7. Update any language or log file settings if appropriate, and click Finish.

  8. To verify the connection settings, click the Test Data Source button, and click OK.

  9. Click OK to exit ODBC Data Source Administrator.

2.2 Configuring Oracle BI Scheduler Instances in a Clustered Environment

In a clustered environment you can have zero, one, or two scheduler instances. Configure zero if you do not require support for scheduled jobs or agents. Configure one if you do not require high availability.

A two-node cluster environment always consists of two instances of the scheduler which are automatically configured as primary and secondary nodes.