Configure Scheduler service on OBIEE 10.1.3.4.1

1.Setup Database schema for the scheduler.

cd /u01/app/obiee/OracleBI/server/Schema

SQL>create user S_NQ_SCHED identified by S_NQ_SCHED;

SQL>grant connect,resource to S_NQ_SCHED;

SQL>alter user S_NQ_SCHED default tablespace OLAP;

SQL>alter user S_NQ_SCHED temporary tablespace TEMP;

SQL>alter user S_NQ_SCHED quota unlimited on OLAP;

SQL>connect S_NQ_SCHED/S_NQ_SCHED@;

SQL>@SAJOBS.Oracle.sql

2. Add the tns entries of the database in the tnsnames.ora

for ex:

TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=asteroid.com)(PORT=1521))
(CONNECT_DATA=
(SID=TEST)
)
)


3. Configure datasource in odbc.ini

cd /u01/app/obiee/OracleBI/setup

[obiee@asteroid setup]$ . ./user.sh
[obiee@asteroid setup]$ . ./sa-init.sh
[obiee@asteroid setup]$ schconfig
Copyright (c) 1997-2009 Oracle Corporation, All rights reserved

***** Delivers Configuration Menu *****
1 - Configure Scheduler
2 - Configure Mail
3 - Configure iBots
4 - Configure Workflow
5 - Configure Java Extension
0 - Quit
>>> Enter Choice:
***** Scheduler Configuration *****
1 - Database
2 - General
3 - Advanced
0 - Quit

>>> Enter Choice: 1

***** Scheduler Database Configuration *****
1 - Database Type : Oracle 10g R2
2 - Call Interface : OCI 10g
3 - Data Source Name : TEST <-- Instance Name from the TNSNAMES.ORA
4 - User Name : S_NQ_SCHED
5 - Password : *****
6 - Timeout (Minutes) : 60
7 - Maximum Connections : 5
8 - Bulk Fetch Buffer Size (bytes) : 33792
9 - Database Table for Jobs : S_NQ_JOB
10 - Database Table for Instances : S_NQ_INSTANCE
11 - Database Table for Parameters : S_NQ_JOB_PARAM
12 - Database Table for Messages : S_NQ_ERR_MSG
13 - DEFAULT VALUES
0 - Quit

>>> Enter Choice: 2

***** Scheduler General Configuration *****
1 - Scheduler Script Path : /u01/app/obiee/OracleBI/server/Scripts/Scheduler
2 - Default Script Path : /u01/apps/obiee/OracleBI/server/Scripts/Common
3 - Temporary File Path : /u01/app/obiee/OracleBIData/tmp
4 - Port Number : 9705 <--- Port Number of scheduler service
5 - Purge Old instances after X days : 7
6 - Purge DB every X minutes : 5
7 - Minimum Execution Threads : 1
8 - Maximum Execution Threads : 100
9 - Pause When Service Starts : False
10 - Administrator Name : Administrator
11 - Administrator Password : *****
12 - DEFAULT VALUES
0 - Quit

Enter 0 and then save YES and exit

select option 3 to receive email from BI scheduler, You can choose Configure Workflow if you need workflow to be enabled.

***** Mail General Configuration *****
1 - From Display Name : Oracle Delivers
2 - Sender Address : mail@asteroid.com
3 - SMTP Server : asteroid.com
4 - SMTP Port : 25
5 - Number of Retries Upon Failure : 1
6 - Maximum Recipients : 0
7 - Use Bcc : True
8 - Authenticate against SMTP server: False
9 - User Name :
10 - Password : *****
11 - DEFAULT VALUES
0 - Quit


4. Configure presentation service to talk to the scheduler.

Add the scheduler port number in the instanceconfig.xml

cd /u01/app/obiee/OracleBIData/web/config

vi instanceconfig.xml

Add the port number:

Alerts
ScheduleServer Asteroid.com:9705/ScheduleServer
/Alerts


Add the credentialstore information:

CredentialStore
CredentialStorage type="file" path="/u01/app/obiee/OracleBIData/web/config /credentialstore.xml" passphrase="obiee"/
/CredentialStore




5. Run Cryptotools to add the latest update in credential store.xml

[obiee@asteroid config]$ cd /u01/app/obiee/OracleBI/setup/
[obiee@asteroid setup]$ . ./sysenvinit.sh
[obiee@asteroid setup]$ cd ../web/bin
[obiee@asteroid bin]$ pwd
/u01/app/obiee/OracleBI/web/bin


cryptotools credstore -add –infile /u01/app/obiee/OracleBIData/web/config/credentialstore.xml


Credential Alias: admin
Username: Administrator
Password: xxxxxxx
Do you want to encrypt the password? y/n (y): y
Passphrase for encryption: xxxxxx
Do you want to write the passphrase to the xml? y/n (n): y

Please make sure that credentialstore.xml file is updated with the following section at the end of the file.


6. Start the scheduler service

cd /u01/app/obiee/OracleBI/setup

[obiee@asteroid setup]$ ./run-sch.sh start
Oracle BI Scheduler startup initiated.
Execute the following command to check the Oracle BI Scheduler logfile and see if it started.
tail -f /u01/app/obiee/OracleBI/server/Log/NQScheduler.log

You can confirm if the scheduler is running by tailing the log file.

[obiee@asteroid setup]$ tail -f /u01/app/obiee/OracleBI/server/Log/NQScheduler.log
2011-01-18 08:55:11
[16020] Metadata Database Type: Oracle 10g R2
Data Source Name: TEST
Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64b
2011-01-18 08:55:11
[68013] Service started.
2011-01-18 08:55:11
Service started.

You can as well confirm by checking if the port number is listening to the incoming requests.
netstat -anp | grep 9705
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:9705 0.0.0.0:* LISTEN 20527/nqscheduler