Wednesday, July 23, 2014

OIM 11G R2 PS2 Lab 3: BI 11.1.1.7.1 Installation and configuration BI publisher with OIM



OIM 11GR2 PS2 BI Publisher Installation and configuration - High Level Steps

1)  WebLogic 10.3.6 Installation
2)  RCU 11.1.1.7.0 Installation
3) BI Publisher 11.1.1.7.0 Installation and configuration
4) BI Publisher 11.1.1.7.1 Patch
5) Configure OIM OOTB reports with BI Publisher

weblogic 10.3.6 installers can be downloaded from :
http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html 

RCU 11.1.1.7.0 installer can be downloaded from :

https://edelivery.oracle.com/EPD/Download/process_download/V37394-01.zip?file_id=59452529&aru=16091890&userid=6298346&egroup_aru_number=11571971&country_id=840&patch_file=V37394-01.zip

BI Publisher 11.1.1.7.0 installer can be downloaded from :
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html

 BI Publisher 11.1.1.7.1 Patch can be download from here:
 Support.oracle.com and patch number is 16556157.


1)  WebLogic 10.3.6 Installation :

  • Go to weblogic installer and run "java -jar wls1036_generic.jar"

  • Click on next
  • Click on next
  • Click on yes
  • Click on yes
  • Select the checkbox and hit continue
  • Click on next
  • Click on next
  • Click on next
  • Click on next
  • Click on Done

2)  RCU 11.1.1.7.0 Installation

  • Go to rcu/bin and run the ./rcu
  • Click on next
  • Select Create and click on next
  • Give the Database connect details and click on next
  • Click on OK
  • Give the Prefix name and select Oracle Business Intelligence and click on next
  • Click on OK
  • Select "Use same password for all schemas" enter a password and click on next
  • Click on next
  • Click on ok
  • Click on ok
  • Click on Create
  • Click on close

3) BI Publisher 11.1.1.7.0 Installation and configuration

  • Go to BI installer and run "./runInstaller -jreLoc /app/jdk1.6.0_29/"

  • Click on next
  • Select "Skip software updates" and click on next
  • Select Enterprise Install and click on next
  • Click on next
  • Select Create New BI System and give the username, password and Domain name
  • Create BI folder and browse to that location then hit next
  • Select first two checkbox and click on next
  • Give the database connection string, BI_BIPLATFORM Schema name and password hit next
  • Click on next
  • Click on next
  • Uncheck the checkbox and click on next
  • Click on yes
  • Click on Install

  • Click on next
  • Click on Finish

  • Stop Admin and BI server before you start patching
    • Go to Weblogic console > servers
    • Select Admin and BI server and force shoutdown
  • Click on yes
4) BI Publisher 11.1.1.7.1 Patch

  • Unzip the patches and keep in one folder

  • Export ORACLE_HOME, PATH and run opatch napply command.
  • Enter y
  • Variefy the patch with opatch lsinventory command

5) Configure OIM OOTB reports with BI

  • Go to ORACLE_IDM1/servers/reports and unzip the oim reports

  • Copy the unzip folder to BI_domain/config/bipublisher/repository/Reports folder
  • Now start the weblogic server

  • Start BI Server
  • Start BI Services
  • Login to weblogic console > myrelems >create user>
    • Create one admin user for BI
  • Assign BI administrator roles
  • Login to BI publisher URL(Localhost:9704/xmlpserver) with admin user

  • Click on Administrator > JDBC Connection
  • Click on Add JDBC Source
  • Give the OIM JDBC connection string , OIM schema and password
  • Click on Server configuration
  • In the BI Publisher repository assign the BI reports location
    • Location=BI_Doamin/config/bipublisher/repository/Reports



10 comments:

  1. In the course of recent years, organizations from all domains have come to acknowledge the advantages of powerful information investigation in understanding purchaser decisions appropriately and expanding income potential. Data Analytics Course in Bangalore

    ReplyDelete
    Replies
    1. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

      Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.

      Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

      The Nodejs Projects Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!

    data science course

    ReplyDelete
  3. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  4. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.

    data science interview questions

    ReplyDelete
  5. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  6. very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  7. You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog. data science training in mysore

    ReplyDelete
  8. Truly overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. Much obliged for sharing.data analytics courses in bhopal

    ReplyDelete