Oracle BI Scheduler Database Setup

This post will describe the steps required to set up a Oracle BI Scheduler Database.

A schedule database is required for Oracle BI Schedule service to work.

Use following steps to configure Oracle BI Scheduler:

Identify a database

Create scheduler tables

Configure Job Manager

Configure XML files

Start Oracle BI Schedule Service

Identify a database

The schedule database would hold scheduler tables. You could choose any supported database to be scheduler database. Supported databases are: Oracle, DB2, MSSQL, Teradata, and SQLServer. In this document we assume that Oracle database is used for Scheduler database. Create a new schema to host the scheduler tables. For example, Sched_1@OBIEE Create scheduler tables Scripts to create scheduler tables are located under C:OBIEEOracleBIserverSchema folder.

For Oracle database, use SAJOBS.Oracle.sql to create the scheduler tables. Launch Oracle SQL*Plus, login as Sched_1@OBIEE . Next enter the following string at the SQL > prompt to run the batch sql file: start C:OBIEEOracleBIserverschema SAJOBS.Oracle.sql;

In Linux files : /oracle/app/OracleBI/server/Schema

SAJOBS.xxx.sql SAACCNT.xxx.sql

In my case :

For this we have to set the path :ORACLE_HOME=/oracle/app/oracle/product/11.2.0/client export ORACLE_HOMEPATH=$PATH:$ORACLE_HOME/bin:.

then : sqlplus / username@DBname password : database password.

Username : SCHED_– USER

Password : Demo

Database name : SCHED Port : 1522

sqlplus SCHED_– USER@SCHED

@SAJOBS.oracle.sql @SAACCNT.oracle.sql

This will create scheduler tables.

Verify that the tables were created by entering the following string at the SQL > prompt:

select table_name from user_tables where table_name like ‘S_NQ%’;

Now we have run cryptotools to create credential in credentialstore.xml file . Cryptotools utility is located under OracleBIwebbin folder