Posted by: michaelverzijl | 27/07/2018

Oracle-BI upgrade to 12.2.1.4

Recently we upgraded our Oracle BI environment from 12.2.1.2 to 12.2.1.4. Major reason for this upgrade is that support of 12.2.1.2.x version will be out of error correction support on August 31st.  After this there will be no more one-off patches provided.

Steps involved:

  1. Install JAVA
  2. Install Weblogic
  3. Install 12.2.1.4
  4. Readiness check repository upgrade
  5. Execute repository upgrade
  6. Reconfig Domain
  7. Upgrade Domain Component Configurations

All details can be found via: https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D.htm#OBIUP-GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D

The upgrade itself went smoothly, although a few issues occurred. My notes of these issues:

nodemanager.properties

In this file we have our SSL configuration stored. The upgrade removes these lines, so make a backup before you continue. File location: $DOMAIN_HOME/nodemanager/nodemanager.properties

TNSNames location changed

Before this release the location was: [DOMAIN_HOME]/config/fmwconfig/bienv/core
This has now been changed to: [DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb [this directory doesn’t exists by default, so you have to create it]

Lightweight SSO

As we are using the eBS integration we need to disable the lightweight SSO. Following steps are executed:


cd /u01/app/obi/12.2.1.4/oracle_common/common/bin
./wlst.sh
disableBISingleSignOn('/u01/app/obi/Middleware/Oracle_Home/user_projects/domains/bi')
exit()

Patching Oracle-BI

During our installation the following patches have been installed:

  • 27401639 (Oracle Recommended)
  • 27479453 (Oracle Recommended)
  • 27823500 (Oracle Recommended)
  • 28043947 (header not available after upgrade to 12.2.1.4)
  • 27443959 (Line in graph in IE not shown correctly)

Enable eBS Cookie again

As the cookie setup is in the Oracle home setup, we need to apply this part again.
Change the following file: /u01/app/obi/12.2.1.4/bi/bifoundation/web/display/authenticationschemas.xml

Enable HTML

By default HTML columns are disabled in 12.2.1.3+. This needs to be enabled by editing the instanceconfig.xml file.
Include the following code in the <Security> tag:
<EnableSavingContentWithHTML>true</EnableSavingContentWithHTML>

 

PDF Print -> € sign is not visible

This was also an issue in 12.2.1.2. Fixed by creating the following directory:


mkdir /u01/app/obi/12.2.1.4/bi/common/fonts
cp /u01/app/obi/12.2.1.4/oracle_common/internal/fonts/* /u01/app/obi/12.2.1.4/bi/common/fonts

Action Link – Export link not visible

When navigating from Action Link to detail report, the corresponding export link is not shown.
If the export setting is changed from dashboard to page setting the export link is visible. For this a SR has been raised and Oracle confirmed this is a bug.

Work-around is to change the dashboard setting to page setting on all dashboards containing action links.

Admintool – Online ODBC

In Windows 7 it’s not possible to add an ODBC connection towards the repository. During setup the following error is shown:
The setup routines for the oracle BI Server could not be loaded due to system error code 998: Invalid access to memory location (<install loc\bi\bifoundation\server\bin\nqsetup.dll)

Currently still under investigation by Oracle.

Dynamic Repository Variable Refresh

Patch 27766951 is created for this issue, but not yet available for 12.2.1.4. Should be available within 2-3 weeks.

Advertisements

Responses

  1. Thanks Michael, very useful!


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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

Categories

%d bloggers like this: