RSS

OBI Apps 11.1.1.7.1 installation and Configuration

21 May

Hello all, I am writing this post to provide the BI Apps 11.1.1.7.1 installation steps along with OBIEE 11.1.1.7.0.

If you didn’t install OBIEE 11.1.1.7.0 then follow all the steps from starting. Otherwise, skip the first 4 steps and continue. but make sure you have the weblogic 10.3.6 or upgrade to it, which is mandatory for ODI and BI Apps 11.1.1.7.1 products. The current BI APPS version is certified with just Oracle as Target db. So the Oracle db version should be 11.2.0.3 +. Because ODI is using JDBC drivers to connect to Oracle and will open multiple JDBC connections during the load. The DB  versions prior to 11.2.0.3 are not supporting multiple JDBC connections at a time. So Oracle 11.2.0.3+ are mandatory for successful ETL loads.

  • Install JDK 1.6.X (JDK 1.7 is not certified by ODI 11.1.1.7)
  • Install weblogic 10.3.6 (ODI 11.1.1.7 must be installed on WL 10.3.6)
  • Run OBIEE 11.1.1.7.0 RCU utility to create BIPLATFORM and MDS schemas.
  • Install and configure OBIEE 11.1.1.7
  • Install ODI with All components and “Skip Repository Configuration” option.
  • Run OBI Apps RCU to create schemas for:
    • ODI Master and Work Repositories (DEV_BIA_ODIREPO)
    • Oracle Business Applications Components (DEV_BIACOMP)
    • Oracle Business Analytics Datwarehouse (DEV_DW)
    • Update to MDS schema.
  • Install BI Apps 11.1.1.7.1
  • Apply FMW Platform Patches: – This is an important step to avoid the BI Apps configuration failure irrespective of what type OBIEE installation (software only / Enterprise) you did. Download “Oracle Fusion Middleware Platform Patches for Oracle Business Analytics Applications Suite” from the Oracle Business Intelligence Applications 11.1.1.7.1 media pack on Oracle Software Delivery Cloud.
    • D:\Middleware\Oracle_BI1\perl\bin> perl D:\Middleware\Oracle_BI1\biapps\tools\bin\APPLY_PATCHES.pl D:\Middleware\Oracle_BI1\biapps\tools\bin\apply_patches_import.txt
  • Update BIACOMP Schema with ATGLite patch scripts:
    • sqlplus DEV_BIACOMP/<Password>
    • SQL> D:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql
  • Configure BI Apps 11.1.1.7.1. Basically, The biapps configuration is a process of extending existed weblogic domain(bifoundation_domain) with deploying new applications like biacm,odiconsole and etc…
  • Integrate ODI security with OPSS:
    • D:\Middleware\user_projects\domains\bifoundation_domain\bin>setDomainEnv.cmd
    • D:\Middleware\user_projects\domains\bifoundation_domain>java weblogic.WLST D:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME localhost –DOMAIN_PORT 7001 –DOMAIN_HOME_PATH D:\Middleware\user_projects\domains\bifoundation_domain
  • Setup ODI Studio to connect to BI Apps repository:
    • Open ODI Studio from windows Start à All Programs à Oracle à ODI Studio
    • In ODI Studio window, click on connect to Repository.
    • In Oracle Data Integrator Login window, Click on + icon to add a login credentials.
    • Provide all the details required as per the below screen.

    • Click Ok, and now you will see the Oracle Data Integrator Login window.
    • Login with the BI apps Admin username and password.
    • Upon Successful authentication, now we connected to BI Apps 11.1.1.7.1 Repository.
    • In ODI Studio, On Left hand window, you can see the ODI Designer, Operator, Topology and Security tab panes for easy navigation to perform the required tasks.
    • Click on Designer pane, and expand the Project list. Here you will see the BI Apps project folder and its mappings directories.

Have a happy time with BI Apps 11.1.1.7.1 with ODI J.

Thanks,
Shiva

Advertisements
 

Tags: , , , , , ,

29 responses to “OBI Apps 11.1.1.7.1 installation and Configuration

  1. Naeem Akhtar

    May 22, 2013 at 1:10 am

    Thanks for steps.

    I think you there is problem in order of the steps.

    (Basically, The ODI installation is a process of extending existed weblogic domain(bifoundation_domain)) I could not understand that.

    As per official guide we install OBIEE, then we install ODI and then we create domain with config (bifoundation_domain.)

    Please advice.

    Naeem

     
    • Shiva Molabanti

      May 22, 2013 at 2:06 am

      Yes Naeem, The configuration is the step, which will extend the exited bfoundation_domain that comes after OBIEE configuration. The ODI will not create a new domain, it is just extending the OBIEE domain.

      Thanks,
      Shiva

       
  2. Enric

    May 23, 2013 at 10:48 am

    Very nice post Shiva. I got confused with the line “Install ODI with All components”. What do I have to select from the following screen?

    Thanks in advance.

     
  3. Dinesh

    May 23, 2013 at 11:13 am

    Hi Shiva,
    Nice post. Just a quick question. can you extend OBIEE weblogic domain to incorporate ODI JEE agent ? If yes then what are the licence implications ? I checked at various sources and got the notion that OBIEE & ODI have restrictive licence of weblogic individually. If we were to use same weblogic for both OBIEE/ODI then we may need to licence weblogic EE separately. What’s your take on this ?

     
  4. Alice

    May 29, 2013 at 9:01 pm

    Hi Shiva,

    The FMW Platform patches are V38106-01 and V38107-01, right? I got Patch Failed on all of them and I see errors like “OUI-67073:UtilSession failed: NApply was not able to get the list of patches to apply.” Did you have similar issues?

     
  5. Aidan

    June 5, 2013 at 9:41 am

    Hi,
    Great!
    I am stucked in the OBIA configuration step 8/18, I set the MDS schema but I’ve got the error the current schema DEV_MDS does not exist, indeed I can login into. In your process you write to update MDS schema, maybe I missed this point ?
    Thanks for answering…

     
    • Pion

      July 31, 2013 at 7:16 pm

      Hi Aidan,

      I am running into the same problem. I see an error “the schema type MDS with the name DEV_MDS does not exist”. I can connect using DEV_MDS user and see the MDS tables in it. I guess, I am also missing the “update to MDS schema” step. I re-ran the OBI Apps RCU to see if I missed the update to MDS step, but, I don’t see it.

      Can you please let me know if you are able to solve this and move forward ?

      Thanks,

      – Pion

       
  6. krishna

    June 12, 2013 at 3:44 pm

    Hi Shiva,

    If possible can you please send me detailed steps to my mail id vks.krishna@gmail.com.

    Thanks
    Krishna

     
  7. ravi

    September 26, 2013 at 6:13 pm

    hi,

    Has anyone encountered the issue below:
    Unable to reach endpoint URL for application BiAcmApp. Make sure application is registered properly and running. contact your system administrator.

    I am getting this when i click on the “goto task” link in FSM. Note that this error is happening in Linux only and not encountering it in windows. We are able to load data in separate windows env.

    Also on linux we are able to run successfully domain load plan, but when any analytics sde/silo load plan is generated, i am getting the above mentioned error during task completion.

    Checked the weblogic biacm module and it is not throwing any error and running successfully.

    appreciate help in advance…

     
    • Nick

      October 17, 2013 at 3:23 am

      Hi Ravi,
      Were you able to solve your problem (Unable to reach endpoint URL for application BiAcmApp)?
      We are having the same issue in FSM.
      Thanks,
      Nick

       
  8. Srini

    October 7, 2013 at 1:26 am

    Hi Siva,
    Could you please let me know what was the operating system you used for your installation.I tried install and configure BI Apps 11.1.1.7.1 and ODI on windows 7 64 bit. ‘Configuring ODI’ task got failed in both Software only and Enterprises installation mode. by ignoring this error I completed my installation and able log in BI Analytic and even my ODI services are running fine in the weblogic server.
    The only problem is i am not able to connect to the Master repository created during the BIApps configuration as ‘Configuring ODI’ got failed. do you have any idea how over come this issue on Windows 7?.

     
    • Shiva Molabanti

      October 8, 2013 at 11:25 pm

      Windows 7 – 64 bit and Linux -64 bit..

      Check your DB connectivity from OBIEE server and try to ping and connect to teh ODI Master repository once. That helps you to find a root cause.

      Thanks,
      Shiva

       
  9. Holly

    October 31, 2013 at 5:31 pm

    Hi Shiva,

    Our requirement is we have SQL Server 2012 as the Target DWH and we have to use Informatica. What would be the ideal BIApps package for us?

    Planning on OBIEE 11.1.1.7.0 and BIApps 7.9.6.4.

    Also is DAC 11g licensed to run on SQLServer ‘2012’? Couldn’t find any specific documentation on the same.

    Thanks in advance & keep posting !

    Holly

     
  10. sell my car for free

    November 4, 2013 at 7:19 pm

    Have you ever thought I’d like to see how much is my car
    worth?
    There are loads of possibilities, so it may be daunting unless you know who you can trust.

     
  11. prasad

    December 20, 2013 at 9:27 pm

    We are currently in Bi-Apps 7.9.6.3 and planning to upgrade OBIEE from 11.1.1.6.6 to 11.1.1.7.1. My question is do we have to upgrade BI-Apps to 7.9.6.4 from 7.9.6.3 while upgrading OBIEE to 11.1.1.7.1 and what are the pros and cons with this.

    Regards
    Prasad

     
  12. Praveen Alamuru

    December 30, 2013 at 6:56 am

    Hi Shiva,

    When I run this

    java weblogic.WLST C:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded -–ADMIN_USER_NAME weblogic -–DOMAIN_HOSTNAME obia111171w64 -–DOMAIN_PORT 7001 -–DOMAIN_HOME_PATH C:\Middleware\user_projects\domains\bifoundation_domain

    from Command Prompt, I am getting this error

    C:\Middleware\user_projects\domains\bifoundation_domain>java weblogic.WLST C:\Mi
    ddleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded –ADM
    IN_USER_NAME weblogic –DOMAIN_HOSTNAME obia111171w64 –DOMAIN_PORT 7001 –DOMAI
    N_HOME_PATH C:\Middleware\user_projects\domains\bifoundation_domain

    Initializing WebLogic Scripting Tool (WLST) …

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    Problem invoking WLST – Traceback (innermost last):
    File “C:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py”,
    line 93, in ?
    File “C:\Middleware\Oracle_BI1\bifoundation\install\apps_commonUtils.py”, line
    107, in parseCommandlineArgs
    File “C:\MIDDLE~1\WLSERV~1.3\common\wlst\modules\jython-modules.jar\Lib/getopt
    $py.class”, line 74, in getopt
    File “C:\MIDDLE~1\WLSERV~1.3\common\wlst\modules\jython-modules.jar\Lib/getopt
    $py.class”, line 124, in do_shorts
    File “C:\MIDDLE~1\WLSERV~1.3\common\wlst\modules\jython-modules.jar\Lib/getopt
    $py.class”, line 139, in short_has_arg
    UnicodeError: ascii encoding error: ordinal not in range(128)

    Please help me where I am doing mistake.

    Weblogic is 10.3.6

    Thank You in advance for your help.

     
  13. Praveen Alamuru

    December 30, 2013 at 7:00 am

    Hi Shiva,

    When I run from wls, getting syntax error.

    Initializing WebLogic Scripting Tool (WLST) …

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    wls:/offline> C:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsOD
    I.py embedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME obia111171w64 –DOMAI
    N_PORT 7001 –DOMAIN_HOME_PATH C:\Middleware\user_projects\domains\bifoundation_
    domain
    Traceback (innermost last):
    (no code object) at line 0
    File “”, line 1
    C:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py e
    mbedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME obia111171w64 –DOMAIN_PORT
    7001 –DOMAIN_HOME_PATH C:\Middleware\user_projects\domains\bifoundation_domain

    ^
    SyntaxError: invalid syntax
    wls:/offline>

    I tried with ‘\\’ in place of ‘\’ no luck.

     
  14. Praveen Alamuru

    January 2, 2014 at 11:35 pm

    got the issue resolved

    Change the contents of C:\Middleware\utils\config\10.3\setHomeDirs.cmd
    from:

    set MW_HOME = @ MW_HOME
    FOR%% i in (“% MW_HOME%”) DO SET MW_HOME =%% ~ FSI
    set WL_HOME = @ WL_HOME
    FOR%% i in (“% WL_HOME%”) DO SET WL_HOME =%% ~ FSI

    to

    set MW_HOME =% MW_HOME%
    FOR%% i in (“% MW_HOME%”) DO SET MW_HOME =%% ~ FSI
    set WL_HOME =% WL_HOME%
    FOR%% i in (“% WL_HOME%”) DO SET WL_HOME =%% ~ FSI

    Rerun the patch script to set the variables properly

    cd c:\Middleware\Oracle_BI1\biapps\tools\bin
    perl APPLY_PATCHES.pl apply_patches_import.txt

    Then Go to

    c:\Middleware\Oracle_BI1\common\bin\

    Run the following command

    wlst.cmd c:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME ibmdemo –DOMAIN_PORT 7001 –DOMAIN_HOME_PATH c:\Middleware\user_projects\domains\bifoundation_domain

    Hope this helps
    -Praveen

     
  15. Sagar Tippe

    January 16, 2014 at 6:03 am

    INST-07525: specified domain cannot be used to configure a BIAPPS system.

    I am trying to configure BI APPS 11.1.1.7.1 and that configuration hangs up at 28% of installation, for which i had to cancel the installation.

    when i am trying to run the installer once again it throws me a error “INST-07525: specified domain cannot be used to configure a BIAPPS system”

    specify a domain which doesn’t already have a BIAPPS configured on it.

    Please help me in this. How can we remove or uninstall the already installed files and start a new configuration step on the same domain only.

     
  16. iphones at radio shack

    January 31, 2014 at 11:36 pm

    For $45 a month, you obtain 1200 anytime minues as well ass unlimited text and data.
    This is new Case which is made with hard material and it has soft interior inside so, that hardness will never affect the phone.
    Of course, should it be Tupperware, which doesn’t count, because I loge my Tupperware
    andd may never part with it and I know a great deal of other Tuppperware lovers that feesl the same
    way.

     
  17. skin disease in cats

    March 5, 2014 at 11:00 am

    You ought to be a part of a contest for one of the finest sites on the internet.
    I will highly recommend this website!

     
  18. JP Gabay

    March 18, 2014 at 9:00 pm

    Any issues installing BI APPS and ODI and WebLogic on a tier separate Linux Server from the OBIEE installation? We have OBIEE installed on Exalytics.

     
  19. Dinesh Chauhan

    March 26, 2014 at 10:25 am

    Hello There,

    I am configuring BIAPPS 11.1.1.7.1 and very first load plan ‘Domain-only Extract and Load (SDE and SIL)’ (kicked-off from Confugration Manager) is failing with following error.

    ODI-1519: Serial step “Start Load Plan (InternalID:683500)” failed because child step “Global Variable Refresh (InternalID:684500)” is in error. ODI-1529: Refresh of variable “BIAPPS.13P_CALENDAR_ID” failed : select CASE WHEN ‘Global Variable Refresh’ in (select distinct group_code from C_PARAMETER_VALUE_FORMATTER_V where PARAM_CODE= ’13P_CALENDAR_ID’) THEN (select param_value from C_PARAMETER_VALUE_FORMATTER_V where PARAM_CODE= ’13P_CALENDAR_ID’ and group_code=’Global Variable Refresh’ and datasource_num_id = ‘#BIAPPS.WH_DATASOURCE_NUM_ID’) ELSE (select param_value from C_GL_PARAM_VALUE_FORMATTER_V where PARAM_CODE= ’13P_CALENDAR_ID’ and datasource_num_id = ‘#BIAPPS.WH_DATASOURCE_NUM_ID’) END from Dual ODI-1533: Error refreshing variable “BIAPPS.13P_CALENDAR_ID”: could not get a connection to the logical schema “CM_BIAPPS11G” using context GLOBAL.

    On investigation when I looked at connection info for Logical Schema CM_BIAPPS11G(Physical schema BIAPPS_BIACOMP) in Topology Manager , JDBC connection string is empty and user name/password is parameterized . So my questions are

    1) Is it normal behavior that CM_BIAPPS11G receive JDBC connection string & username/password dynamically at run time ?

    2) If yes then how this string get passed and where does it get stored ?

    3) I am tempted to hardcode username/password/JDBC string in ODI Topology manager and kick off load plan from there. Do you see any risk in doing so ?

    Any pointer/suggestion will be highly appreciated.

    Thanks & Regards

     
  20. Srinivas

    May 5, 2014 at 10:36 am

    Hi Gurus,

    Am trying to run the SQL script to update the Oracle ATG repository data.

    sqlplus dev_biacomp/welcome1 @C:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql

    The problem is the ATGPF directory is missing.
    In other words there is no path in ATGPF\sql\fndtbs_11170_upg.sql

    Probably the directory is not created as part of DW creation.

    Please suggest.

    Regards
    Srinivas Chindam

     
  21. Eduardo Montes

    August 20, 2014 at 6:14 pm

    Hi gurus

    I am having the following issue when trying to connect to ODI reposwith ODI studio (I am working with BI apps 11.1.1.8.1 – Linux red hat 6)

    Hi, I am trying to connect to Bi Apps Odi Repo with ODI Studio, but when testing i am having the following issues.

    If a define a thin client connection with the following syntax:
    jdbc:oracle:thin:@server_ip_address:port_name:instance_name
    The error message is:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    If I define a Thin client connection with the following syntax:
    jdbc:oracle:thin:@server_ip_address:port_name/instance_name
    the error message is:
    oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI user name or password
    oracle.security.jps.JpsRuntimeException: JPS-01520: No se puede inicializar el almacén de identidades. Causa: oracle.security.jps.service.idstore.IdentityStoreException: JPS-01520: No se puede inicializar el almacén de identidades. Causa: oracle.security.idm.ConfigurationException: Failed to connect to directory. Check configuration information…

    Finally If i define a connection with OCI8
    jdbc:oracle:oci8:@ckdwhdbd
    the error message is:
    java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I

    I have already copied the files (cwallet.sso and jps-config-jse.xml) to the proper location and change ODI.CONF file

     
    • Abhijeet Barge

      March 18, 2015 at 2:14 pm

      I have OBIA 11.1.1.8.1(OBIA + OBIEE + ODI Server) and ODI Client Installed on Machine1 and My Machine2 contains ODI Client Installed. I was able to access the BIAPPS ODI repository from both the machines. But suddenly after about 4-5 month, I’m unable to access the BIAPPS repository from Machince2 while i’m able access it from Machine1. I’m getting following error

      oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI username or password. oracle.security.jps.JpsRuntimeException: JPS-01520: Cannot initialize identity store, cause: oracle.security.jps.service.idstore.IdentityStoreException: JPS-01520: Cannot initialize identity store, cause: oracle.security.idm.ConfigurationException: Failed to connect to directory. Check configuration information… at oracle.security.jps.internal.jaas.module.idstore.IdStoreLoginModule.initializeLM(IdStoreLoginModule.java:658) at oracle.security.jps.internal.jaas.module.idstore.IdStoreLoginModule.initialize(IdStoreLoginModule.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597)

      I’ve already tried regenerating security files (cwallet.sso & jps-config-jse.xml). Also I’ve installed ODI Client on Machine3(with security file Configuration), but still i’m getting the above error while accessing.

      PLEASE HELP !!

       
  22. Kiran

    November 5, 2015 at 1:38 am

    I am unable to use the ODI Studio to login into 2 different endowments. When I configured the ODI Studio and copied the files cwallet.sso and jps-config-jse.xml from the dev into the client, with that configuration I am able to login fine. I am facing issue, when I login into QA environment, while setting up the ODI Studio profile after entering all the QA Environment’ specific credentials , I am getting this error while Work repository, ODI-10199: Incorrect ODI username or password.

    Please help.!!

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: