Installation of ODI 11.1.1.6 on Windows 64-bit

Hardware and System Configuration Requirements for Oracle Data Integrator:

  • Disk Space: 5GB or more
  • Available Memory: 2GB or more

 

Database Requirements for Oracle Data Integrator:

  • Master Repository: 60 MB of Storage Space
  • Work Repository: 80 MB of Storage Space

System Requirements and Supported Platforms for Oracle Data Integrator:

Step 1: Need to install jdk1.7.0+

Download the jdk1.7.0 from

http://www.oracle.com/technetwork/java/javase/downloads/java-se-jdk-7-download-432154.html

and install the Java in C:\Program Files\Java

Step2: Download the ODI 11.1.1.6 software from

http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Step3: Unzip the entire software and go to

Disk1\install\win64 and click on setup, it will ask for a JDK location.

Step4: Give the path up to jdk1.7.0 and press enter.

This will open up the Welcome Screen of Oracle Data Integrator.

Skip Repository Configuration and we can create Master and Work Repositories later.

Now we can see the Installation was successful.

Go to Start–>All Programs–>Oracle–>Oracle Data Integrator–>ODI Studio.

It will opens the Starting Page Oracle Data Integrator.

By bidevatapraveenkumar Posted in ODI

Moving View Selector to Left Side in OBIEE 11g

Issue : Need to change View Selector to Left Side from Center.

Resolution :

Need to add

VSelSelector{padding-bottom:2px;text-align:left;}. line in views.css file from the below mentioned paths.

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\views.css

Save the files and restart OPMNCTL then we can see View Selector changes to the Left from center.

By bidevatapraveenkumar Posted in OBIEE 11g

Stream Closed Error when Click on coreapplication in Enterprise Manager in OBIEE 11g

Stream Closed Error when Click on coreapplication in Enterprise Manager in OBIEE 11g:

Recently when I tried to click on coreapplication in Enterprise Manager in OBIEE 11g, I am getting an error like Stream Closed.

Resolution:

Go to the below mentioned path

Middleware\user_projects\domains\bifoundation_domain\sysman\mds\partition1\ai\bi\mdssys\cust\user\weblogic

Here you can find instance.jspx file.

Delete this file and restart all the services then you can resolve this issue.

By bidevatapraveenkumar Posted in OBIEE 11g

Exceeded configured maximum number of allowed output prompts in OBIEE 11g

Error : Exceeded configured maximum number of allowed output prompts, sections, rows in OBIEE 11g.

When we are drilling from main report to detail report we are getting an error like Exceeded configured maximum number of allowed output prompts, sections, rows this is because of huge data in the report.

So in order to resolve this issue we need to add the below mentioned  tags in instanceconfig.xml file which is located under

\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

The tags which needs to be added are

By bidevatapraveenkumar Posted in OBIEE 11g