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/

2 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

Purge Oracle Analytics Cloud cache using curl command

Clearing cache for all databases: Syntax: curl -i -X DELETE -u joe@example.com:mypassword1 -H "X-ID-TENANT-NAME:myidentitydomain...