BI Enterprise Edition

Oracle Business Intelligence Enterprise Edition is a full range of BI Components that every one was looking for. It includes Dashboard , Answer , Delivers , Publisher and Disconnected Analytics.

If you are familiar with other Oracle Products then Dashboard is similar to Portal , Answer is similar to Discoverer , Delivers is similar to Alerts , Publisher is previously known as XML Publisher.

In the further topics I will cover my experience in getting the BI EE working.

Oracle Application Server : Renaming Hostname

On one of the implementation we had the Infrastructure and the Customer Database Installed on the same host. The Infrastructure Database was created with MRCA and the Customer Database is a Warehouse System.

The existing architecture looks as below;



The proposed architecture was to migrate into DMZ architecture and it looks like below;



The proposed plan was to move the Infrastructure Database into a new node and place it in the DMZ.

After reading the Changing Network Configurations of application server , we came to know that the IP address can be change but not the hostname. Oracle support does not have a script to update the hostnames as there are plenty of records where the hostname was recorded.

Finally we ended up moving the Warehouse System into a different node. Warehouse implementation has an option to change the hostname. But the work involved in migrating the Warehouse Database was huge as we did not have other options.