INSTALLATION DOCUMENTS BY RAVI

Showing posts with label OBIA. Show all posts
Showing posts with label OBIA. Show all posts

Sunday, July 30, 2017

ORA-01950 no privileges on tablespace issue while running OBIA rcu

Error:

 CREATE TABLE "DEV_BIACOMP"."C_RPD_MSGS" ("MSG_ID" VARCHAR2(250 CHAR) NOT NULL ENABLE, "SEEDED_FLAG" NUMBER(1,0), "MSG_TEXT_TYPE" VARCHAR2(50 CHAR), "CREATED_BY" VARCHAR2(64 BYTE), "CREATION_DATE" TIMESTAMP (6), "LAST_UPDATED_BY" VARCHAR2(64 BYTE), "LAST_UPDATE_DATE" TIMESTAMP (6), "LAST_UPDATE_LOGIN" VARCHAR2(32 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10
ORA-39083: Object type TABLE:"DEV_BIACOMP"."C_BIEE_CURR_CODE_LKP" failed to create with error:

ORA-01950: no privileges on tablespace 'DEV_BIACOMP'

Solution : From oracle support

On researching the knowledge base, Found one of our other customer also faced rcu failure while installing 11.1.1.9.1 on Oracle 12c (12.1.0.2.0) and following workaround resolved the issue.

********************************************************
Backup the following file:

<rcu_home>/rcu/integration/biapps/sql/biapps_create_user.sql

Open the script biapps_create_user.sql, modify the line
FROM:
CREATE USER &&1 identified by &&2 default tablespace &&3 temporary tablespace &&4;

TO:
CREATE USER &&1 identified by &&2 default tablespace &&3 temporary tablespace &&4 quota unlimited on &&3;

************************************************************

After the change, run rcu again.

Monday, May 1, 2017

OBIA Upgrade from 7.9.6.x to 7.9.6.4

1. Install OBIEE 11g and OBIA 7.9.6.4 on new server.
2. Take the backup of rpd and catalog from lower versioned server and copy them the new server.
3. In the new server navigate to ORACLE_HOME\bin directory and run the upgrade assistant ua.bat
4. In the welcome screen click next
5. In specify operation screen , select upgrade Oracle BI RPD and Presentation Catalog and click next
6. In the specify source details screen
a) select Upgrade Repository (RPD)
b) Browse the copied lower version rpd
c) Provide rpd login credentials
d) Provide new password for the upgraded rpd
e) Select Upgrade Catalog
f) Browse the lower version catalog directory 
g) Click next
7. In the specify weblogic server screen, provide weblogic user name, password and port of new server and click next
8. In the Examining components screen, if the status got succeeded click next
9. In the Upgrade summary screen , click Upgrade to start the upgrade process
10. In the Upgrading components screen , if the status got succeeded click next
11. In the Upgrade Success screen , review the summary and click close to finish the upgrade process.
12. Verify the upgraded rpd and calalog

Steps for installing Oracle Business Intelligence Applications 7.9.6.4.0

Pre-requisites:

1. OBIEE 11g must be installed, up and running
2. We need to have weblogic server details ( user name , password and port )
3. Informatica and Dac are not mandatory for this installation

Downloading the software:

1. Download the software from https://edelivery.oracle.com
2. Login to edelivery.
3. In search type Oracle Business Intelligence Applications 7.9.6.4.0 , select the platform we want and click continue.
4. Click continue.
5. Accept the license agreement and click continue.
6. Click on the ( V35873-01.zip Oracle Business Intelligence Applications 7.9.6.4 ) to download the software.
7. Extract the downloaded software.

Installing OBIA 7.9.6.4 :

1. Go to software folder , right click on the setup file and select run as administrator.
2. In the welcome screen click next.
3. In the specify installation location screen , specify obiee ORACLE_HOME, INSTANCE_HOME and DOMAIN_HOME locations and click next.
4. In the weblogic administration server details screen , provide weblogic port, user name  and password and click next.
5. In the Oracle Business Intelligence Applications 7.9.6.4 you would like to install screen, select the components to install and click next.
6. In the please read the summary information below screen, verify the summary and click next.
7. Now we will get the below screens:
a) Installing Oracle Business Intelligence Applications 7.9.6.4. Please wait..
b) Stopping the BIEE domain. It may take several minutes. Please wait..
c) Starting OPMN managed components. It may take several minutes. Please wait..
8. In the please read the summary information below screen, click finish to complete the installation.

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/

Saturday, April 15, 2017

Steps for Creating a User who can access Configuration Manager(BIACM), FSM, and Oracle Data Integrator in OBIA

Below are the steps for creating a "biappsadmin" like user in OBIA

1)create user in weblogic
2)create application role in enterprise manager

3)create user in odi grant them the supervisor profile

Login to the weblogic 







In the left pane of the Web Logic Server Administration Console, click on Security Realms














Click on myrealm







To configure new user click on ‘users and groups’ then click on new









Specify the user name and password details then click ‘ok’
























After creation of user then click on ‘user’ in user and groups
























Click on groups tab and added the following members to the user then click on save
























After creation of user in web logic we need to create application role in enterprise manager
Login to the enterprise manager
Expand the web logic domain
Right click on bifoundation domain
Go to Security
Click on Application roles























In application roles select application stripe as ‘obi’ and to create new application role click on “create”






















Specify the application stripe, role name, display name











After that we need to add members to the role, click on add select type as application role then click on search icon
























Select and add the following duty roles to the application then click ok







After adding roles to the application we need to add the user to the application.click on add and select type as user then click on search icon. Select the defined user
Click ok
























After the creation of application role we need  to  create user in ODI and grant them the Supervisor profile

In security navigator
Under Users
Right click on supervisor
Click on New
























Specify the user name and click on retrieve GUID to retrieve the user from web logic then save it.

















In security navigator drag and drop the following profiles from  profiles tab to the created user in users tab .


























Now specify the new user and password  then click ok to login.
















  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...