INSTALLATION DOCUMENTS BY RAVI

Monday, April 17, 2017

Steps for Oracle Business Intelligence Applications (OBIA) 11.1.1.10.2 installation on Oracle Linux and Windows

1. Download and stage the software
2. Run OBIEE rcu and BIAPPS rcu
3. Install Java
4. Install Weblogic server
5. Install OBIEE in software only mode
6. Configure OBIEE
7. Install ODI without repository configuration
8. Install BIAPPS software
9. Apply Fusion middleware patches
10. Apply additional patches
11. Upgrade ATG, FSM and BIACM schemas
12. Configure BIAPPS
13. Copy Security files
14. Launch consoles and ODI studio


Download and stage the software :
Download the below softwares and extract to a folder
Java : Oracle jdk1.7.0_80 or more
Weblogic server : Version 10.3.6
OBIEE : Version 11.1.1.9
ODI : Version 11.1.1.9
OBIA: Version 11.1.1.10.2 (with Technology patches)
Additional Patches :
On Linux :
21672441 - for gpa error
On Windows : 
21672441 - for gpa error
21811403 - distribution repository error


Run OBIEE rcu and BIAPPS rcu

OBIEE RCU:
1. Run rcu.bat / rcu from rcu/bin folder
2. In the welcome screen click next
3. In the create repository screen select create and click next
4. In the database connection details screen provide the database details and click next and then click ok
5. In select components screen give prefix name and select Oracle Business Intelligence under components tab and then click next
6. In the schema passwords screen provide password and click next
7. In map tablespaces screen click next
8. In the summary screen click create.
9. In the completion summary screen click close

BIAPPS RCU:
1. Run rcu.bat / rcu from rcu/bin folder
2. In the welcome screen click next
3. In the create repository screen select create and click next
4. In the database connection details screen provide the database details and click next and then click ok
5. In select components screen give prefix name and select Oracle Business Intelligence Applications under components tab and then click next
6. In the schema passwords screen provide password and click next
7. In the custom variables screen give the path for .dmp files in the biapps rcu (E:\office\rcuHome\rcu\integration\biapps\schema) and click next
Note: If the database is on different machine, these files must be present on database server machine.
8. In map tablespaces screen click manage tablespaces if you want to increase tablespace size for biapps schemas and click next otherwise click next
9. In the summary screen click create
10. In the completion summary screen click close


Install Java :
Double click the exe file on windows or extract the tar.gz file on linux to install java

Install Weblogic server:
1. Run the weblogic.jar file using java (java -jar weblogic1036.jar)
2. In the welcome screen click next
3. In the choose middleware home directory screen provide the path for middleware home and click next
4. In registry for security updates screen uncheck the option and click next and select I wish to remain uninformed and click continue
5. In choose install type screen select typical and click next
6. In jdk selection screen select jdk path and click next
7. In choose product installation directories screen click next
8. In installation summary screen click next
9. In installation complete screen uncheck run quick start and click done.

Install OBIEE in software only mode:
1. Run the executable file under Disk1
2. In the welcome screen click next
3. In install software updates screen select skip software updates and click next
4. In the select installation type screen select software only install and click next
5. In prerequisite checks screen if all the checks were passed click next
6. In the specify installation location screen specify the path for installation (middleware home path) and click next
7. In the application server screen select weblogic server and click next
8. In the summary screen click install
9. In the installation progress screen if it reaches 100% click next
10. In the complete screen click finish

Configure OBIEE:
1. Run config.bat / config.sh under ORACLE_HOME/bin directory.
2. In the welcome screen click next
3. In prerequisite checks screen if all the checks were passed click next
4. In the create , scale out or extend screen select create new bi system and provide password and click next
5. In specify installation location screen click next
6. In configure components screen click next
7. In biplatform schema screen provide the schema details and click next
8. In mds schema screen check the schema details and click next
9. In configure ports screen select auto port configuration and click next
10. In specify security updates screen uncheck the option and click next
11. In the summary screen click configure
12. In the configuration progress screen if it reaches 100% click next
13. In complete screen click finish

Install ODI without repository configuration:
1. Run the executable file under Disk1
2. In the welcome screen click next
3. In install software updates screen select skip software updates and click next
4. In the select installation type screen select all the options and click next
5. In prerequisite checks screen if all the checks were passed click next
6. In the specify installation location screen specify the path for installation (middleware home path) and click next
7. In the application server screen select weblogic server and click next
8. In repository configuration screen select skip repository configuration and click next
9. In the specify agent details screen provide agent name and port and click next
10. In the installation summary screen click install
11.  In the configuration progress screen if it reaches 100% click next
12. In installation completed screen click finish


Install BIAPPS software:
1. Run the executable file under Disk1
2. In the welcome screen click next
3. In prerequisite checks screen if all the checks were passed click next
4. In the specify installation location screen specify the path for installation (middleware home path) and change the oracle home directory to Oracle_BI1 and click next
5. In the summary screen click install
6.  In the installation progress screen if it reaches 100% click next
7. In the complete screen click finish


Apply Fusion middleware patches:
Note: Before applying patches stop all the obiee servers and components
1. Modify apply_patches_import.txt file under ORACLE_HOME/biapps/tools/bin with respective paths in our environment and save the file
2. Apply the fusion middleware technology patches using below command
Perl APPLY_PATCHES.pl ORACLE_HOME/biapps/tools/bin/apply_patches_import.txt

 Apply additional patches:
1. Apply gpa patch 21672441 on linux machine to resolve gpa error while biapps configuration
2. Apply gpa patch 21672441and patch 21811403 on windows machine to resolve gpa and repository distribution error while biapps configuration

Upgrade ATG, FSM and BIACM schemas:
1. Upgrade atg, fsm and biacm schemas by running psa.bat / psa utility under ORACLE_HOME/bin directory

Configure BIAPPS:
Note: Before configuring biapps start all obiee servers and components
1. Run configApps.bat / configApps.sh under ORACLE_HOME/bin directory.
2. In the welcome screen click next
3. In prerequisite checks screen if all the checks were passed click next
4. In the extend bi domain screen select extend bi domain and provide password and click next
5. In the specify installation location screen specify the path for installation (middleware home path) and click next
6. In configure components screen select bi application components and click next
7. In the rpd encryption password screen provide rpd password and click next
8. In bi applications screen provide username as biappsadmin and provide password and click next
9. In mds schema screen provide mds schema details and click next
10. In bi applications component schema screen provide biacomp schema details and click next
11. In business analytics warehouse schema screen provide dw schema details and click next
12. In bi applications odi repository schema screen provide odirepo schema details and click next
13.  In configure ports screen select auto port configuration and click next
14. In the summary screen click configure
15. In the configuration progress screen if it reaches 100% click next
16. In complete screen click finish


Copy Security files:
1. Copy security files cwallet.sso and jps-config-jse.xml files  <MW_Home>/user_projects/domains/bifoundation_domain/odi-client-config/embedded
To:                   
<ODI_Home>/oracledi/client/odi/bin
and rename the file  jps-config-jse.xml to  jps-config.xml under <ODI_Home>/oracledi/client/odi/bin

 Launch consoles and ODI studio:
Test the installation by opening consoles and launching odi studio

Consoles :
Weblogic console : http:// hostname:7001/console
User name : weblogic
Password : welcome1
User name : weblogic
Password : welcome1
User name : weblogic
Password : welcome1

Odi Studio:
Run odi.bat / odi.sh to launch odi studio from the location <ODI_Home>/oracledi/client/

12 comments:

  1. Thanks for sharing this article great information. I enjoyed some posts going to your website. I am GST Suvidha Provider, GST is a solitary duty on the supply of merchandise and ventures. Numerous aberrant duties that the Central Government or State Governments force on providers and shoppers are subsumed by GST.

    ReplyDelete
  2. The parody here is that these amazing patterns served a double job in the midst of the market division.Data Analytics Courses

    ReplyDelete
  3. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  4. Hi Ravi,

    Article is quite easy to follow along and Thanks for sharing the issues as well.

    I am trying to install on my personal laptop (Windows 7 Pro) however I am unable to get these patches 21672441,21811403 (as I have general Oracle account but not Oracle support account). Is there any way we can get them or by any chance do you have them(to share via google drive)?
    Any direction or help is much appreciated.

    Thanks

    ReplyDelete
    Replies
    1. Download the Patches from below link.

      https://drive.google.com/file/d/1kuJX_yFIlHXN2d_15-zpBbFDNfel2LU9/view?usp=sharing

      Delete
    2. 1. Download and extract the patch
      2. cd to patch (for example 21672441) directory
      3.Set the paths below:
      export ORACLE_HOME=C:\Oracle\Middleware\Oracle_BI1
      export JAVA_HOME=$ORACLE_HOME/jdk
      export PATH=$ORACLE_HOME/bin:$PATH
      export PATH=$JAVA_HOME/bin:$PATH
      export PATH=$ORACLE_HOME/OPatch:$PATH
      4. Run the below command:
      opatch apply

      Delete
  5. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  6. Hi Ravi,

    Thankyou so much for sending the links promptly. For some reason I am not able to install any of the tech patches running into several errors as below.Can you please elaborate on how to install the tech patches in OBIA 11.1.1.10.2 ?

    Cd C:\Oracle\Middleware\Oracle_BI1\OPatch> opatch napply C:\Patches\biappsshiphome\win64 -silent -oh C:\Oracle\Middleware\Oracle_BI1 -jdk C:\Oracle\Middleware\Oracle_BI1\jdk > C:\WORKDIR\biappshiphome_win64_patches.log
    UtilSession failed:Patcj 21672441 requires component(s) that are not installed in OracleHome. These not-instaled components are oracle.jrf.owsm:11.1.1.9.0

    --
    Set Oracle_Home, Java_home etc and still had same error, so removed that patch from the folder and reran and then got error related to OCM

    UtilSession failed:
    To run in silent mode, OPatch requires a response file for Oracle Configuration Manager(OCM).
    Please run “C:\Oracle\Middleware\Oracle_BI1\OPatch\ocm\bin\emocmrsp.bat” to generate an OCM response file.The generated response file
    Can be reused on different platforms and in multiple OPatch silent installs.
    To regenerate an OCM response file, please rerun “C:\Oracle\Middleware\Oracle_BI1\OPatch\ocm\bin\emocmrsp.bat”

    [Jul 6, 2020 8:52:09 PM]
    Check if patch "21672441" is a no-op patch.
    [Jul 6, 2020 8:52:09 PM]
    OUI-67073:UtilSession failed: Patch 21811403 requires component(s) that are not installed in OracleHome.
    These not-installed components are oracle.opmn:11.1.1.9.0,
    [Jul 6, 2020 8:52:09 PM]
    Finishing UtilSession at Mon Jul 06 20:52:09 EDT 2020
    [Jul 6, 2020 8:52:09 PM]
    Log file location: C:\Oracle\Middleware\oracle_common\cfgtoollogs\opatch\opatch2020-07-06_20-51-51PM_1.log
    [Jul 6, 2020 8:52:09 PM]
    Stack Description: java.lang.RuntimeException: Patch 21811403 requires component(s)
    that are not installed in OracleHome. These not-installed components are oracle.opmn:11.1.1.9.0,
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1051)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1097)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: java.lang.reflect.Method.invoke(Method.java:606)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:305)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2304)
    [Jul 6, 2020 8:52:09 PM]
    StackTrace: oracle.opatch.OPatch.main(OPatch.java:666)

    ------------------
    Installed this bat file
    C:\Oracle\Middleware\Oracle_BI1\OPatch\ocm\bin\emocmrsp.bat

    ReplyDelete
  7. Thanks Ravi for prompt replies. I had found that 21672441 is not required for OBIA 11.1.1.10.2 as it's part of 22077978. So finally succeeded with config of OBIA. Thanks Again

    ML

    ReplyDelete
  8. You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject! data science training in guwahati

    ReplyDelete
  9. I see some amazingly important and kept up to length of your strength searching for in your on the site
    data science course in guwahati

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

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm

    Logistic Regression explained

    ReplyDelete

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...