How to Install ODI 11g Step by step part 1

This is a continuation of a series of posts about setting up an Oracle DW environment, if you follow the steps below you can successfully implement the solution:

  • Prereqs for the installation: JDK, RCU and ODI installer:

Download the latest version of ‘JDK’, link:

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

  • Install JDK. To do that navigate to the download directory and type “jdk-7u80-windows-x64”: 
  • Hit enter and click next:
  • Change the location to the Root “C:” instead of “Program Files”, for ODI you may not get any issue but for OBIEE you will certainly face problems with that space in the name:

  • Click “Ok” and “Next”

  • Again, you will need to change the location and click “Ne
  • Click “ok” and “next“
  • Wait for the installation :
  • Ok, now that the JDK is installed we can install ODI and OBIEE 11G :
  • Download the ODI installer: http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html
  • In this post I will download the version   11.1.1.9.0  which is a generic version , you also need to download the RCU, repository creation utility (Windows 32/64 bits) according to your Operating system:
  • Remember, you will need to have an Oracle account to download the installers:
  • After downloading the RCU, extract it and run it, the reason why we need to run the RCU is because we need to create the components (schemas and tablespaces) before installing the ODI master and work repository, make sure you take note of user names, passwords and repository names, id’s etc..this is just one of the methods of configuring/installing ODI,  there is another method that you can manually create the schemas(this was the only method in the previous ODI version “10 G”):
  • After downloading and extracting the RCU, Navigate to the “BIN” folder and type “rcu”, hit enter:

  • Skip the first page:
  • Click “create”:
  • Now We need to enter some information to connect to the DB as sysdba, note that this is a very high privilege, if you are implementing this toolset I assume you will have these permissions or at least ask your DBA to provide that privilege at least temporarily( if he is not happy ask him to run, he will grant the permission at least temporarily) :
  • Enter the following:Hostname: localhostDefault Port: 1521Default Service name (SID): ORCLUsername: sysPassword: the one you providedRole: SYSDBA
  • Click “Next”
  • If everything is ok you should get the following screen, just hit ok:
  • Select the “prefix” and “Component” as “Oracle data integrator” and hit next:
  • Click “Ok”, in the next screen you define the password, you can choose a single pass for all schemas or you can select “Specify different passwords for all schemas”, for this demo I chose a single pass on the option “Use same passwords for all schemas ”, click next :
  • Now we need to provide the master repository ID, work repository type(for development environment choose “D” so that you will have the “Designer” module or if it is an execution environment such as “QA” or Production, you should choose “E” for execution), work repository id, work repository name and password, make sure you save it:
  • Take a look, the RCU is about to create the schema/owner, default tablespace and temp tablespace, click next :
  • Click ok:
  • Click “Ok”
  • Click “Create”:
  • Creation in progressCreation completed:
  • Now that the metadata is created we can install ODI:
  • Create a new folder and extract both files into a single folder:
  • Navigate to the folder where the universal installer is located: C:\Users\Administrator\Downloads\ODI_11.1.1.9\Disk1\install\win64
  • in the cmd enter “setup.exe” to initialize the installer
  • You will see this screen,  enter the JDK path:
  • Enter the path like the following screenshot :
  • The wizard should show up like this screenshot below, it may take a little while, click “Next”:
  • Skip software updates and click next:
  • Choose the basic options, I will show how to install the ODI agent in another post, just to remind you about the JAVA ee Agent, if you require it I recommend to do it in this step since it will be an ODI domain based in WebLogic. To install the JEE agent after the initial ODI install is time consuming and require many other config steps, you will need to create a WebLogic domain
  • Click” Next”:
  • Location where ODI will be installed, click “Next”:
  • In this step, skip the “Repository configuration” since you have created the metadata schema.
  • If you choose ”configure Repositories” you can create the schemas after installing ODI , in this case we proceed hit “Next” and ignore the warning if that’s the case and choose install:
  • Progress of installation :
  • Installation completed:
  • Go to start menu and verify that studio is accessible and ready for use, we will need another step to configure the repositories connections:
  • That is it! now we will need to perform a few extra steps to create the master and work repositories, in the below link you will navigate to the next https://dwgrain.com/2016/10/13/installing-odi-11g-step-by-step-part-2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s