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.
Cheers !!!