Oracle BI Scheduler Database Setup

Oracle Business Intelligence ( a component of oracle fusion middleware)

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

 

Issues related to the OBIEE.

Troubleshooting

Problem

Unable to create user id and groups in OBIEE 10.1.3.4.1

Solutions

On the Obiee server , I have edited the configuration file : xmlp-server-config.xml from path OracleBIxmlpXMLPAdminConfiguration .

OBIEE & BIP Installation Procedure

* Use X Manager / other X window utility to access the remote server

• export DISPLAY=<IP of client machine>:0.0


• Check the remote access using utilities like xclock, xhost

* Connect to the OBIEE server and run the setup.sh file from the extracted OBIEE location.

• $./setup.sh

 

* OBIEE Installation wizard will be activated and it continues as below and Press “Next >”

* Provide the OBIEE BI and OBIEE BI Data folder location (which been created in Pre-Installation procedure) and Select the “Basic” mode of installation type.

* Select the “Complete” as installation setup type.

* Select the JDK location and provider OC4J administrator password.

• Ensure JDK is greater than 1.5 (64 bit)


• No need to work on OC4J level configuration, as we are moving the EAR/ WAR from Oc4J to Weblogic. Only this password (OC4J) is need for the alternative approach to Weblogic.

* Click on “Next >” on the continuing screens:

* On Installation success screen, click on “Next >” on for continuing:

* By default in Basic mode, OC4J (Oracle Container for J2EE) will be started.

Encrypted Data Transfer between Oracle Database Server and Oracle Client

This post  describes one of the most important feature of Oracle Database , i.e. how to configure oracle Database and Oracle Client to communicate in an encrypted manner.