Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

For BI Admin tool client upgrade:
- Go to the windows box and uninstall current version of BI Admin tool

- Follow steps as below to install the new version using the installer: 

1) Download biee_client_install_x64.exe either from BI Analytics page or from OTN.

BI Analytics

2) Run the installer by invoking biee_client_install_x64.exe

3) Select language from the drop down menu and click ok

4) InstallAnywhere Introduction -> Click Next

5) Choose Installer Folder

6) Choose Shortcut Folder. Select appropriate option & click Next

7) Pre-Installation Summary

8) Installation Complete

9) Set up ODBC Connection to Fusion Applications

To set up the ODBC connection from the Windows machine, you must locate the correct port on the Fusion Applications BI Server. Typically it is 10206, but if ports were changed as part of the FA install, perform the following steps:

- Log in to the BI Server's Enterprise Manager Console.
- Expand Business Intelligence within the Farm_BIDomain and select coreapplication. Select Overview and the sub tab Processes.
- Expand the BI Servers, and make a note of the port number.

You csn now create a new ODBC connection.

Select Oracle BI Server Driver on the Windows machine.

10) Enter the Server name for the host that contains the BI Domain. Click Next.

11) On the resulting screen, enter the BI Server port (either 10205 or derived above) and the user name/password with which you plan to connect. Click Next.

12) Click Finish

Also see other relevant post

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for Oracle Business Intelligence Enterprise Edition and Exalytics

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

OBIEE 11.1.1.7.150120 comes as patch 20124371.

For the details of the list of patches you may apply in addition to OBIEE 11.1.1.7.150120, please refer to this post. 

Before applying the patch, please ensure you have a good cold backup to restore from if needed.

• On the OBIEE MT server, backup the following: 

<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/server/<SID>/admin/instances/
<SID>/<BIHOST>/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository 
<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/conf/mapViewerConfig.xml

• Stop the services.
• cd /<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/web/catalogmanager/configuration/  and remove the following files if exist:

- org.eclipse.osgi

-org.eclipse.equinox.app

• Set the environment variables, go to staging area & apply the patches as below:

1) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

  Make sure the patch is applied by running:   opatch lsinventory| grep 16569379

2) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

   Make sure the patch is applied by running: opatch lsinventory| grep 16913445

3) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 19823874

4) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 19822893

5) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 16997936

6) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  20022695

7) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19825503

8) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19822826

9) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19822857

10) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  17019008

11) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  16984654

• Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files

Source: /<SID>/oraclebi/mwh/Oracle_BI1/clients/bipublisher/repository/Tools

Target: /<SID>/admin/user_projects/domains/bi_<SID>/config/bipublisher/repository/Tools

• Copy msmdacc64.dll :

Source: /<SID>/oraclebi/mwh/Oracle_BI1/clients/bipublisher/repository/Admin/DataSource 

Target:/<SID>/admin/user_projects/domains/bi_<SID</config/bipublisher/repository/Admin/DataSource

• Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists):

/<SID>/admin/user_projects/domains/bi_<SID>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1 and remove any jsp_servlet subdirectory that you find.

• Look in each directory below 

<Middleware home>/<Domain home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1, and remove any jsp_servlet subdirectory that you find.

• If you backed up the mapViewerConfig.xml because it had been modified, then copy the backed-up file to its original location at

/<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/conf/

• Admin tool client upgrade:

- Go to the windows box and uninstall current version of BI Admin tool

        - Install the new version of BI Admin Tool using the installer

• Backup & configure config.xml and xdo.cfg files

Go to /<SID>/admin/instances/SID_host/config/OracleBIJavaHostComponent/coreapplication_obijh1 and backup the files config.xml and xdo.cfg.

In the config.xml file, configure the XMLP tag for large data as follows:

<XMLP>< InputStreamLimitInKB>0</InputStreamLimitInKB>

<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

In the xdo.cfg file, add the following parameter inside the properties tag:

<property name="xlsx-keep-values-in-same-column">true</property>

• Backup & configure opmn.xml

Go to /SID/admin/instances/SID_host/config/OPMN/opmn and backup opmn.xml

Add OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL variable for BI Server as 

following.

•<ias-component id="coreapplication_obis1" inherit-environment="true"> 

<environment> 

<variable id="OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL" value="2"/> 

</environment>

• Start the services
• Refresh the catalogs

Related Posts:

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

OBIA 11g: PATCH OBIEE 11.1.1.7.150120 - Patchlist

OBIA 11g: PATCH OBIEE 11.1.1.7.150120 - Patchlist

OBIEE 11.1.1.7.150120 comes as patch 20124371. 

If you unzip it, it will contain eight other zip files containing the patches for each of the components (of which patch 19822893 is one) and a readme.htm file which contains the installation instructions.

Patch 16913445 - Patch 11.1.1.7.150120 (1 of 8) Oracle Business Intelligence Installer (BIINST)
Patch 19822893 - Patch 11.1.1.7.150120 (2 of 8) Oracle Business Intelligence Publisher (BIP)
Patch 19825503 - Patch 11.1.1.7.150120 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
Patch 19822857 - Patch 11.1.1.7.150120 (4 of 8) Oracle Business Intelligence Server (BIS)
Patch 19822826 - Patch 11.1.1.7.150120 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
Patch 19823874 - Patch 11.1.1.7.150120 (6 of 8) Oracle Real-Time Decisions (RTD)
Patch 16997936 - Patch 11.1.1.7.150120 (7 of 8) Oracle Business Intelligence ADF Components (BIADFCOMPS)
Patch 20022695 - Patch 11.1.1.7.150120 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer


Also you must download and install:

Patch 16569379 - Dynamic Monitoring Service patch

If you use Internet Explorer 11, download and install:

Patch 18277370 - JDeveloper patch

You may additionally apply below bug fix patches.

Patch 17019008: CRASH IN NQSSERVER (ABORTED)


Patch 16984654: STATUS MAX TIME DOES NOT CANCEL DATABASE QUERY WHEN CONNECTING TO ESSBASE

Detailed steps for applying the OBIA 11g: PATCH OBIEE 11.1.1.7.150120 patch are covered in this post below.

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics



Related Posts:

OBIEE Patch 18277370 conflicts with Patch 17611288 installed during OBIA 11.1.1.8.1 installation

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

OBIEE 11.1.1.7.140715 Bundle Patch Released

OBIEE 11.1.1.7.140715  Bundle Patch Released


Oracle Business Intelligence Enterprise Edition - OBIEE 11.1.1.7.140715 Suite Bundle Patch on July 15, 2014.

• OBIEE 11.1.1.7.140715 suite bundle patch 18818588 is a single patch that contains all eight component patches. 

o Oracle Business Intelligence Installer (BIINST)
o Oracle Real Time Decisions (RTD)
o Oracle Business Intelligence Publisher (BIP)
o Oracle Business Intelligence ADF Components (BIADFCOMPS)
o Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM)
o Oracle Business Intelligence: (BIFNDN)
o Oracle Business Intelligence: (BISERVER): 
o Oracle Business Intelligence Platform Client Installers and MapViewer



• The OBIEE 11.1.1.7.140715 suite bundle patch includes more than 52 BISERVER, BIFNDN and BIP bugs fixes since the last suite bundle patch released in May 2014.