Oracle BI Scheduler Database Setup for 10g

Setting up Oracle BI Scheduler Database 

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

Use following steps to configure Oracle BI Scheduler:

1.       Identify a database
2.       Create scheduler tables
3.       Configure Job Manager
4.       Configure XML files
5.       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:\OBIEE\OracleBI\server\Schema folder.

Oracle BI Scheduler Database Setup


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:\OBIEE\OracleBI\server\schema\ SAJOBS.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%';

Configure Job Manager

Launch Job Manager ( go to Start > Programs > Oracle Business Intelligence > Job Manager)
From the Job Manager’s File menu select Configure Options.

Schedule Configuration screen will be displayed. Select Database type as your schedule database type,
enter data source name, user name and password. Also select the general tab and set the administrator user name and password. When completed, the screen will look as below:

Note : Please note that the DSN in the below screen should be the TNS name since Call interface selected is OCI(refer the below screenshot)

 

 Click Ok

Configure XML Files


 You need to run the cryptotools utility that will update credentialstore.xml file. You also need to update
Instanceconfig.xml file. These xml files are located under OracleBIData\web\config folder.
Take a backup of these two xml files before making changed.

Run cryptotools


 Cryptotools utility is located under OracleBI\web\bin folder. Launch MS Command Prompt. Go to
OracleBI\web\bin folder.
Type following command and hit return
cryptotools credstore -add -infile C:\OBIEE\OracleBIData\web\config\credentialstore.xml

 


Enter Admin as Credential Alias
Enter Oracle BI’ Administrator as User Name
Enter Administrator’s password
Do not Encrypt the password

 

Update instanceconfig.xml file

Instanceconfig.xml file is located under OracleBIData\web\config folder.
Open it in an editor like notepad.
Add following line of code
<CredentialStore>
<CredentialStorage type="file" path="C:\OBIEE\OracleBIData\web\config\credentialstore.xml”/>
</CredentialStore>
Save file.

 

Start Oracle BI Schedule Service


Launch services (go to Start > Control Panel > Administrative Tools > Services )
Select Oracle BI Schedule Service and click on Start
Service will start.