To Configure BI Scheduler on Windows

To get OBIEE "Oracle BI Scheduler" to work follow the below steps "D:\OracleBI\server\Bin\NQScheduler.exe" /service
On the "Job Manager" Application Console:-

1. Choose File --> Configuration Options --> Scheduler Tab --> Database subtab, enter the following:
   • Connection Pool
     • Database Type: Oracle 10g R1
     • Call Interface: ODBC 3.5
     • Data Source Name: ORCL
     • Username: SUPPLIER2
     • Passowrd: SUPPLIER2
   • Database Tables:
     • Jobs : S_NQ_JOB
     • Instances : S_NQ_INSTANCE
     • Parameters : S_NQ_JOB_PARAM
     • Messages : S_NQ_ERR_MSG
2. Choose File --> Configuration Options --> Scheduler Tab --> General subtab, enter the following:
   • Administrator Name : Administrator
   • Administrator Password : Administrator
3. Choose File --> Configuration Options --> Mail Tab --> General subtab, enter the following:
   • From Display Name : Oracle Delivers
   • Sender Address : user@localhost.com
   • SMTP Server : localhost.com
   • SMTP Port : 25
   • Username : user@localhost.com
   • Email Password : oracle
4. Run CryptoTools as below: D:\OracleBI\web\bin>cryptotools.exe credstore -add -infile D:\OracleBIData\web\config\\credentialstore.xml >Credential Alias: Admin
   >Username: Administrator
   >Password: *********
   >Do you want to encrypt the password? y/n (y): y
   >Passphrase for encryption: *********
   >Do you want to write the passphrase to the xml? y/n (n): y
   File "D:\OracleBIData\web\config\credentialstore.xml" exists. Do you want to overwrite it? y/n (y): y
   Note :- For PassPhrase "Administrator" was given
5. Start "Oracle BI Scheduler" service
6. Installing and Configuring the hMailServer is as follows:
   • update the C:\WINDOWS\system32\drivers\etc\hosts with the below:
     • 127.0.0.1 localhost localhost.com
   • Open the hMailServer Administrator application console :
     • Under Domains , click Add and enter
       • Domain : localhost.com
       • check the "Enabled" box
     • Under Domains --> localhost.com --> Accounts , click Add and enter
       • Address : user
       • Password : oracle
       • Maximum size (MB) : 50
       • Administration level : User
       • check the "Enabled" box
     • Under Settings --> Advanced enter
       • Default domain : localhost.com
     • Under Settings --> Advanced --> Autoban, uncheck the Enabled box
     • Under Settings --> Advanced --> TCP/IP ports click Add and enter
       • Protocol : IMAP
       • TCP/IP address : 127.0.0.1
       • TCP/IP port : 143
7. Configuring OUTLOOK Express to receive the iBot reports:
   • Goto Tools --> Accounts
   • Under Mail Tab, select Add -> Mail..
     • Display name : user
     • E-mail address : user@localhost.com
     • My incoming mail server is a : POP3 server
     • Incoming mail server : localhost.com
     • Outgoing mail server : locahost.com
     • Account name : user@localhost.com
     • Password : oracle then click next and finish.