Aplicando o Bundle Patch 11.1.1.7.140114 no OBIEE 11G

O primeiro passo é fazer o Download do patch 17886497 no Oracle Support.

A documentação de instalação está disponível no arquivo README.html que acompanha o patch.

Ambiente atual: Oracle Business Intelligence 11.1.1.7.1

Verificar se o patch 16569379 está instalado no ambiente utilizando o opatch lsinventory.

Neste ambiente, já estava aplicado.

[oracle@kiobane ~]$ /u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/opatch2014-02-06_11-03-25AM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Lsinventory Output file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/lsinv/lsinventory2014-02-06_11-03-25AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Business Intelligence Shiphome 11.1.1.7.0
There are 1 products installed in this Oracle Home.

Interim patches (14) :

Patch 16569379 : applied on Wed Oct 02 10:54:45 WAT 2013
Unique Patch ID: 16229678
Created on 11 Apr 2013, 15:06:42 hrs US/Pacific
Bugs fixed:
16367012, 16397667
.
.

É necessário parar o ambiente:

/u01/app/oracle/product/Middleware/instances/instance1/bin/opmnctl stopall
/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1
/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh

Limpar os logs do cache do Catalog Manager:

cd/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/web/catalogmanager/configuration

- verificar se existem os seguinte diretórios e remover:

· org.eclipse.osgi

· org.eclipse.equinox.app

Descompactar o patch:

[oracle@mukulu midias]$ unzip p17886497_111170_Linux-x86-64.zip
Archive: p17886497_111170_Linux-x86-64.zip
creating: 17886497/
extracting: 17886497/p17922577_111170_Generic.zip
inflating: 17886497/README.htm
extracting: 17886497/p16997936_111170_Generic.zip
extracting: 17886497/p17300417_111170_Linux-x86-64.zip
extracting: 17886497/p17922552_111170_Linux-x86-64.zip
extracting: 17886497/p17922352_111170_Generic.zip
extracting: 17886497/p16913445_111170_Generic.zip
extracting: 17886497/p17300045_111170_Generic.zip
extracting: 17886497/p17922596_111170_Linux-x86-64.zip

Setar as variáveis de ambiente:

export ORACLE_HOME=/u01/app/oracle/product/Middleware/Oracle_BI1
export PATH=$ORACLE_HOME/bin:$PATH
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH

O patch pode ser instalado de 2 maneiras.

Se você tiver todos os componentes do Oracle BI EE instalados e configurados, pode-se utilizar simplesmente:

opatch napply –skip_duplicate

Porém , para fins de demostração, irei instalar um a um.

16913445 - Oracle Business Intelligence Installer (BIINST):

oracle@mukulu 17886497]$ unzip p16913445_111170_Generic.zip
Archive: p16913445_111170_Generic.zip
creating: 16913445/
.
.
.
cd /u01/midias/17886497/16913445
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
[oracle@mukulu 16913445]$ /u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/16913445_Feb_05_2014_17_06_18/apply2014-02-05_17-06-18PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '16913445' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
Interim patch 16913445 is a superset of the patch(es) [ 16453010 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16453010' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.biinst, 11.1.1.7.0...
RollbackSession removing interim patch '16453010' from inventory

OPatch back to application of the patch '16913445' after auto-rollback.

Patching component oracle.bi.biinst, 11.1.1.7.0...

Verifying the update...
Patch 16913445 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/16913445_Feb_05_2014_17_06_18/apply2014-02-05_17-06-18PM_1.log

OPatch succeeded.

17922352 - Oracle Business Intelligence Publisher (BIP):

[oracle@mukulu 17886497]$ unzip p17922352_111170_Generic.zip
Archive: p17922352_111170_Generic.zip
creating: 17922352/
.
.
.

cd /u01/midias/17886497/17922352
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922352_Feb_05_2014_17_09_13/apply2014-02-05_17-09-13PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17922352' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.bi.xdo, 11.1.1.7.0...

Verifying the update...
Patch 17922352 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922352_Feb_05_2014_17_09_13/apply2014-02-05_17-09-13PM_1.log

OPatch succeeded.

17300417 - Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM):

[oracle@mukulu 17886497]$ unzip p17300417_111170_Linux-x86-64.zip
Archive: p17300417_111170_Linux-x86-64.zip
creating: 17300417
.
.
.
cd /u01/midias/17886497/17300417
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17300417_Feb_05_2014_17_11_43/apply2014-02-05_17-11-43PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17300417' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
Interim patch 17300417 is a superset of the patch(es) [ 16916026 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16916026' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.bifndnepm, 11.1.1.7.0...
RollbackSession removing interim patch '16916026' from inventory

OPatch back to application of the patch '17300417' after auto-rollback.

Patching component oracle.bi.bifndnepm, 11.1.1.7.0...

Verifying the update...
Patch 17300417 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17300417_Feb_05_2014_17_11_43/apply2014-02-05_17-11-43PM_1.log

OPatch succeeded.

17922552 - Oracle Business Intelligence Server (BISERVER):

[oracle@mukulu 17886497]$ unzip p17922552_111170_Linux-x86-64.zip
Archive: p17922552_111170_Linux-x86-64.zip
creating: 17922552
.
.
.

cd /u01/midias/17886497/17922552
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922552_Feb_05_2014_17_14_29/apply2014-02-05_17-14-29PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17922552' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
Interim patch 17922552 is a superset of the patch(es) [ 16850553 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16850553' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.biserver, 11.1.1.7.0...
RollbackSession removing interim patch '16850553' from inventory
OPatch back to application of the patch '17922552' after auto-rollback.
Patching component oracle.bi.biserver, 11.1.1.7.0...
Verifying the update...
Verifying the update...
Patch 17922552 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922552_Feb_05_2014_17_14_29/apply2014-02-05_17-14-29PM_1.log

OPatch succeeded.

17922596 - Oracle Business Intelligence Presentation Services (BIPS):

[oracle@mukulu 17886497]$ unzip p17922596_111170_Linux-x86-64.zip
Archive: p17922596_111170_Linux-x86-64.zip
creating: 17922596
.
.
.

cd /u01/midias/17886497/17922596
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922596_Feb_05_2014_17_17_25/apply2014-02-05_17-17-25PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17922596' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
Interim patch 17922596 is a superset of the patch(es) [ 16068402 16842070 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16068402' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.bifndn, 11.1.1.7.0...
RollbackSession removing interim patch '16068402' from inventory
Rolling back interim patch '16842070' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.bifndn, 11.1.1.7.0...
RollbackSession removing interim patch '16842070' from inventory

OPatch back to application of the patch '17922596' after auto-rollback.

Patching component oracle.bi.bifndn, 11.1.1.7.0...

Verifying the update...
Patch 17922596 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922596_Feb_05_2014_17_17_25/apply2014-02-05_17-17-25PM_1.log

OPatch succeeded.

17300045 - Oracle Real-Time Decisions (RTD):

[oracle@mukulu 17886497]$ unzip p17300045_111170_Generic.zip
Archive: p17300045_111170_Generic.zip
creating: 17300045
.
.
.

cd /u01/midias/17886497/17300045
[oracle@mukulu 17300045]$ /u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17300045_Feb_05_2014_17_41_33/apply2014-02-05_17-41-33PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17300045' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.bi.rtd, 11.1.1.7.0...

Verifying the update...
Patch 17300045 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17300045_Feb_05_2014_17_41_33/apply2014-02-05_17-41-33PM_1.log

OPatch succeeded.

16997936 - Oracle Business Intelligence ADF Components (BIADFCOMPS):

[oracle@mukulu 17886497]$ unzip p16997936_111170_Generic.zip
Archive: p16997936_111170_Generic.zip
creating: 16997936
.
.
.
cd /u01/midias/17886497/16997936
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/16997936_Feb_05_2014_17_43_03/apply2014-02-05_17-43-03PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '16997936' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.bi.biadfcomps, 11.1.1.7.0...

Verifying the update...
Patch 16997936 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/16997936_Feb_05_2014_17_43_03/apply2014-02-05_17-43-03PM_1.log

OPatch succeeded.

17922577 - Oracle Business Intelligence Platform Client Installers and MapViewer:

[oracle@mukulu 17886497]$ unzip p17922577_111170_Generic.zip
Archive: p17922577_111170_Generic.zip
creating: 17922577
.
.
.

cd /u01/midias/17886497/17922577
/u01/app/oracle/product/Middleware/Oracle_BI1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/Middleware/Oracle_BI1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/Middleware/Oracle_BI1/oraInst.loc
OPatch version : 11.1.0.9.9
OUI version : 11.1.0.9.0
Log file location : /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922577_Feb_05_2014_17_44_22/apply2014-02-05_17-44-22PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/product/Middleware"

Applying interim patch '17922577' to OH '/u01/app/oracle/product/Middleware/Oracle_BI1'
Verifying environment and performing prerequisite checks...
Interim patch 17922577 is a superset of the patch(es) [ 16869578 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16869578' from OH '/u01/app/oracle/product/Middleware/Oracle_BI1'

Patching component oracle.bi.bishiphome, 11.1.1.7.0...
RollbackSession removing interim patch '16869578' from inventory

OPatch back to application of the patch '17922577' after auto-rollback.

Patching component oracle.bi.bishiphome, 11.1.1.7.0...

Verifying the update...
Patch 17922577 successfully applied
Log file location: /u01/app/oracle/product/Middleware/Oracle_BI1/cfgtoollogs/opatch/17922577_Feb_05_2014_17_44_22/apply2014-02-05_17-44-22PM_1.log

OPatch succeeded.

Copiar os arquivos BIPublisherDesktop32.exe e BIPublisherDesktop64.exe de \clients\bipublisher\repository\Tools para prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools.

cd /u01/app/oracle/product/Middleware/Oracle_BI1/clients/bipublisher/repository/Tools
cp BIPublisherDesktop32.exe BIPublisherDesktop64.exe /u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools/

Copiar o arquivo msmdacc64.dll de \clients\bipublisher\repository\Admin\DataSource directory para prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\DataSource.

cd /u01/app/oracle/product/Middleware/Oracle_BI1/clients/bipublisher/repository/Admin/DataSource/
cp msmdacc64.dll /u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Admin/DataSource/

Remover o diretório jsp_servlet (se existir) do seguinte caminho:

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1

Inicializar o ambiente:

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh
/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1

/u01/app/oracle/product/Middleware/instances/instance1/bin/opmnctl startall

Por fim, basta verificar se é necessário aplicar os passos do Post-Installation Instructions no ambiente.