Pular para o conteúdo

Como fazer o download e instalação do Bundle Patch 11.1.1.7.140114 no Oracle Business Intelligence

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.

Bash
[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:

Bash
/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:

Bash
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:

Bash
[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:

Bash
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:

Bash
opatch napply –skip_duplicate

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

16913445 – Oracle Business Intelligence Installer (BIINST):

Bash
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):

Bash
[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):

Bash
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):

Bash
[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):

Bash
[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):

Bash
[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):

Bash
[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:

Bash
[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 <Oracle BI Home>\clients\bipublisher\repository\Tools  para prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools.

Bash
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 <Oracle BI Home>\clients\bipublisher\repository\Admin\DataSource directory  para prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\DataSource.

Bash
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:

Bash
/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.

Abraço

Alex Zaballa

Alex Zaballa

Alex Zaballa, formado em Análise de Sistemas, é especialista em Banco de Dados Oracle com sólidos conhecimentos em Servidores de Aplicação e Sistemas Operacionais; trabalha com Oracle há 15 anos, é ORACLE ACE Director, certificado OCM Database 11G / Cloud e conta com mais de 140 outras certificações em produtos da Oracle. Alex também é um dos fundadores do Grupo de Usuários Oracle de Angola (GUOA), participa do Grupo de Usuários de Tecnologia Oracle Brasil (GUOB) e é membro do time OraWorld.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Marcações:
plugins premium WordPress