Wednesday, December 26, 2012

Oracle DAC Installation 10.1.3.4.1



This article shows how to install Oracle Business Intelligence Data Warehouse Administration Console (Oracle DAC) - version 10.1.3.4 on WindowsDuring this installation both Oracle DAC Server and Oracle DAC Client are installed.

First of all you have to download the software from Oracle site and unzip it. You will have a directory named "dac". Go to the "Disk1\install\win32" folder (if you use a 64-bit version go to the "Disk1\install\win64" folder). He re you will see a file named setup.exe. Double click on it.

A warning message might appear :
Oracle DAC Installation: Security Warning
Oracle DAC Installation: Security Warning

Click on "Run" as the Publisher is known. The following screen will appear:

Install Oracle DAC : Welcome
Install Oracle DAC : Welcome

Click on Next.

Oracle DAC Installation: Specify Installation Location
Oracle DAC Installation: Specify Installation Location

Choose the Oracle Home Location and click on Next. This is the default location but you can choose another one.

Oracle DAC Installation: Install Components
Oracle DAC Installation: Install Components

Click on "Next". As you can see the DAC Server and the DAC client will be installed in the same time.

Oracle DAC Installation: Select Informatica Version
Oracle DAC Installation: Select Informatica Version

Choose the Informatica version you have already installed and after that click on "Next". Here is an article showing how Informatica 8.x can be installed. In my case I have installed Informatica 8.x.

Oracle DAC Installation: Prerequisite Checks
Oracle DAC Installation: Prerequisite Checks

If all the prerequisites are ok, click on "Next". The following screen will appear:

Oracle DAC Installation: Installation Summary
Oracle DAC Installation: Installation Summary

Here you will see the summary of what is preparing to install. Before installing the Oracle DAC server, click on "Save" button to save the configuration to keep it.

Here is what such a file contains:

[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#
ORACLE_HOME=C:\orahome\10gR3_1

#
SELECT INFORMATICA 8.1.1=true

#
SELECT BI INFORMATICA 7.1.4=false

#
INFORMATICA_SERVER_HOME_811=D:\Informatica86x

#
INFORMATICA_DOMAIN_FILE_811=D:\Informatica86x\domains.infa


[SYSTEM]


[APPLICATIONS]

#
DAC_CLIENT_SELECTED=true

#
DAC_SERVER_SELECTED=true


[RELATIONSHIPS]


When the "Install" button is clicked the following screens will appear :
 
Oracle DAC Installation: Installation Progress
Oracle DAC Installation: Installation Progress

Oracle DAC Installation: Installation Completed
Oracle DAC Installation: Installation Completed

At this point, the Oracle DAC server is installed. You have just to click on "Finish" and use the Oracle DAC.