sábado, 22 de fevereiro de 2014

va_oid_register_err1 ERROR - OracleAS RepCA failed to register the OracleAS Metadata Repository with Oracle Internet Directory

Ao fazer load and register do SSO no OID 11g:

[InfrastructureRegistrationAction] Action failed due to: oracle.ias.repca.ifs.utils.action.ActionFailedException: OracleAS RepCA failed to register the OracleAS Metadata Repository with Oracle Internet Directory.
va_oid_register_err1After you have fixed the problem, rerun OracleAS RepCA and select the 'Register' option, which  registers the database with Oracle Internet Directory without loading the OracleAS Metadata Repository schemas.
ERROR - OracleAS RepCA failed to register the OracleAS Metadata Repository with Oracle Internet Directory.
va_oid_register_err1After you have fixed the problem, rerun OracleAS RepCA and select the 'Register' option, which  registers the database with Oracle Internet Directory without loading the OracleAS Metadata Repository schemas.
oracle.ias.repca.ifs.utils.action.ActionFailedException: OracleAS RepCA failed to register the OracleAS Metadata Repository with Oracle Internet Directory.
va_oid_register_err1After you have fixed the problem, rerun OracleAS RepCA and select the 'Register' option, which  registers the database with Oracle Internet Directory without loading the OracleAS Metadata Repository schemas.
        at oracle.ias.repca.actions.InfrastructureRegistrationAction.perform(InfrastructureRegistrationAction.java:367)


A solução é rodar o REGISTER novamente utilizando a portal ssl do OID.


sexta-feira, 21 de fevereiro de 2014

Oracle Expert Summit 2014 - Review

Participei do evento Expert Summit 2014 que aconteceu em Dubai de de 16 à 20 de Fevereiro.

Como era de se esperar em Dubai, fiquei impressionado com a grandeza, organização e qualidade do evento.


Foto oficial do evento:



Entrada do Hotel Grosvenor House Dubai, onde ocorreu o evento:



Credenciamento:


Vista da Marina de Dubai ao lado do hotel:






Local do Coffee Break, ao lado dos auditórios:



Finalmente conheci pessoalmente o Oracle Ace Director Kamran Agayev


O que assisti:

  • Seminar 1: Feb 16th | 9:00 - 17:00 - Writing Optimal SQL with Jonathan Lewis

  • Seminar 2: Feb 17th | 9:00 - 17:00 - Trouble Shooting and Tuning with Jonathan Lewis


  • Seminar 3: Feb 18th | 9:00 - 17:00 - Mastering ASM with Arup Nanda

  • Seminar 6: Feb 19th | 9:00 - 17:00 - Performance Tuning in RAC: Architecture and Internals with Arup Nanda

  • Seminar 8: Feb 20th | 9:00 - 17:00 - Performance Tuning in RAC: Designing and Implementing with Arup Nanda

Não poderia faltar a foto com os Mestres:



O almoço foi servido no restaurante do hotel:







sexta-feira, 14 de fevereiro de 2014

ORACLE EXPERT SUMMIT 2014

Na próxima semana irei participar do evento ORACLE EXPERT SUMMIT 2014.
Este evento acontece de 16 à 20 de Fevereiro em Dubai.


Eu pretendo participar dos seguintes:
  • Seminar 1: Feb 16th | 9:00 - 17:00 - Writing Optimal SQL with Jonathan Lewis
  • Seminar 2: Feb 17th | 9:00 - 17:00 - Trouble Shooting and Tuning with Jonathan Lewis
  • Seminar 3: Feb 18th | 9:00 - 17:00 - Mastering ASM with Arup Nanda
  • Seminar 6: Feb 19th | 9:00 - 17:00 - Performance Tuning in RAC: Architecture and Internals with Arup Nanda
  • Seminar 8: Feb 20th | 9:00 - 17:00 - Performance Tuning in RAC: Designing and Implementing with Arup Nanda

Mais informações:
EXPERT SUMMIT 2014

quarta-feira, 12 de fevereiro de 2014

Configurando o Oracle Web Cache em Cluster com a utilização de outro Webcache como Load Balancer


Para adicionar:

opmnctl createcomponent -componentName webcache2 -componentType WebCache



Após isso entrar nas configurações do Cluster:


Adicionar o novo componente ao Cluster, sincronizar e restartar.


Para adicionar um webcache como Load Balancer:

./opmnctl createcomponent -componentName webcache_loadb -componentType WebCache

Adicionar ROUTINGONLY="YES" no webcache.xml




segunda-feira, 10 de fevereiro de 2014

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.

sábado, 8 de fevereiro de 2014

SSO: Initializing the encryption objects failed

Caso ocorra esse erro ao mudar o ip do servidor a solução está no documento abaixo:

OC4J_SECURITY CONTAINER FAILS TO START AFTER AN IP ADDRESS CHANGE (Doc ID 961371.1)

Basta ajustar a entrada na árvore do OID.

"cn=YOURSID,cn=OracleContext" 

sexta-feira, 7 de fevereiro de 2014

renamedg - 11.2.0.4

Alterando o nome do DiskGroup DATA para DG01:

/u01/app/11.2.0.4/grid/bin/renamedg phase=both dgname=DATA newdgname=DG01 verbose=true 

Caso ocorra o erro KFNDG-00407, deve-se adicionar o parâmetro asm_diskstring.

Se o DiskGroup estiver montado, irá ocorrer o erro KFNDG-00405.

Caso o DiskGroup seja o principal, é necessário parar o HAS:

 /u01/app/11.2.0.4/grid/bin/crsctl stop has

[oracle@kilamba ~]$ /u01/app/11.2.0.4/grid/bin/renamedg phase=both dgname=DATA newdgname=DG01 verbose=true asm_diskstring='/dev/oracleasm/disks/*'
NOTE: No asm libraries found in the system

Parsing parameters..

Parameters in effect:

         Old DG name       : DATA
         New DG name          : DG01
         Phases               :
                 Phase 1
                 Phase 2
         Discovery str        : /dev/oracleasm/disks/*
         Clean              : TRUE
         Raw only           : TRUE
renamedg operation: phase=both dgname=DATA newdgname=DG01 verbose=true asm_diskstring=/dev/oracleasm/disks/*
Executing phase 1
Discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK01 with disk number:0 and timestamp (32999664 545457152)
Checking for hearbeat...
Re-discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK01 with disk number:0 and timestamp (32999664 545457152)
Checking if the diskgroup is mounted or used by CSS
Checking disk number:0
Generating configuration file..
Completed phase 1
Executing phase 2
Looking for /dev/oracleasm/disks/DISK01
Modifying the header
Completed phase 2
Terminating kgfd context 0x7f542abab0a0

[root@kilamba ~]# /u01/app/11.2.0.4/grid/bin/crsctl start has



UTL_DBWS - Webservices

Download do arquivo dbws-callout-utility-10131.zip

cd $ORACLE_HOME/sqlj/lib

loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsclientws.jar dbwsclientdb11.jar


execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxySet','write'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxyHost', 'write'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','http.proxyPort', 'write'); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission', 'accessClassInPackage.sun.util.calendar',''); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission','getClassLoader',''); 
execute dbms_java.grant_permission('','SYS:java.net.SocketPermission','*','connect,resolve'); 
execute dbms_java.grant_permission('','SYS:java.util.PropertyPermission','*','read,write'); 
execute dbms_java.grant_permission('','SYS:java.lang.RuntimePermission','setFactory','');

Exemplos de utilização podem ser vistos em:

How to Verify the Installation of UTL_DBWS Package in Oracle Database 11g (Doc ID 1166206.1)

Using UTL_DBWS to Make a Database 11g Callout to a Document Style Web Service (Doc ID 841183.1)

UTL_DBWS - Consuming Web Services in Oracle 10g




quarta-feira, 5 de fevereiro de 2014

SCHEMA VALIDATION UTILITY

SCHEMA VALIDATION UTILITY (SVU) (Doc ID 286619.1)

O primeiro passo é atualizar o OPATCH (Patch 6880880).

Após isso verificar a versão do seu portal e aplicar o patch correto.

No meu caso é o Patch 9718908.

Aplicando o Patch:
/u01/app/oracle/product/as10g/MidTier/OPatch/opatch apply /tmp/zab/svu/14806295 -pre -s portal -p ***** -c 192.168.244.130:1521:sigfedb -opatch_pre_end -post -s portal -p ****** -c sigfedb

Baixar o arquivo svu_rept.sql


sqlplus portal/*****

SQL> @svu_rept.sql

Enter SVU Mode: REPORT
Enter SVU Type: ALL
Enter log file (and path): /tmp/log.log

250 rows selected.

Flush information that has been reported

PL/SQL procedure successfully completed.









sábado, 1 de fevereiro de 2014

Upgrade do Oracle Beehive versão 2.0.1.4.0 para 2.0.1.8.0

Ambiente Atual:
 - Beehive 2.0.1.4
 - Oracle Database 11.1.0.7 64bits

Documentação para aplicação do Patch:



Patchs necessários para o Beehive 2.0.1.8 rodar no banco 11.1.0.7:


·         9548753: MERGE REQUEST ON TOP OF 11.1.0.7.0 FOR BUGS 9128529 8499043
·         8537211: MERGE LABEL REQUEST ON TOP OF 11.1.0.7 FOR BUGS 6625210 7694979 7378322
·         8531282: MERGE LABEL REQUEST ON TOP OF 11.1.0.7 FOR BUGS 8352309 7586451
·         8499600: ORA-01555 ERRORS ON SECUREFILES READS EVEN UNDER LOW LOADS/NO UPDATE ACTIVITY
·         8487273: MERGE LABEL REQUEST ON TOP OF 11.1.0.7 FOR BUGS 8214576 7258928
·         8221425: STBH:HP:11G - ORA-04031: UNABLE TO ALLOCATE 912 BYTES OF SHARED MEMORY
·         7707103: RECOMPILATION OF LIBRARY UNIT GIVES END-OF-FILE COMMUNICATION CHANNEL
·         7690421: INVALID TZ VALUE IN TIMEZONE COLUMN PRODUCES ORA-01875
·         7685452: 10.2.0.5.0 : HP-PA : ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [4449], [],
·         7643188: SQL VERSION COUNT REPORTED IN AWR DOES NOT MATCH SQLSTATS FOR 1 SQL ID
·         7500792: HIGH GETS ON "KOKC DESCRIPTOR ALLOCATION LATCH" WITH MORE THAN 400 USERS
·         7313961: MISSING LSFEND IN DRUERE() CALLS ADDED FOR BUG 6499258
·         7311226: PARTITIONED TABLE AND FILTER BY OPTIMIZE_INDEX NOT PICKING UP WHERE IT LEFT OFF
·         7273988: TST&PERF:QUERY PLAN IS VERY BAD IN RDBMS_MAIN_LINUX_080623
·         7156912: ORACLE TEXT INDEXING HANGS ON A HTML DOCUMENT WITH LONG COMMENTS
·         7047984: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KJBCLOSE:MAS], [3], [1]...
·         6977167: ORA-04092: CANNOT ROLLBACK IN A TRIGGER RECEIVED REQUIRING INSTANCE BOUNCE
·         6782437: QUERY WITH MULTIPLE SUBQUERIES PERFORMING POORLY AFTER 10G UPGRADE
·         6750049: LIBNNZ10.SO DLOPEN FAILED WHEN TRYING TO START ONS (NODEAPPS)
·         6698219: DBMS_LINK ALLOWS PATH > 1024 CAUSING CORRUPT REPOSITORY
·         6355412: JOB CONSUMES 100% CPU FOR EXTENDED PERIODS
·         6263237: TCH11G: ORA-7445 WHILE RUNNING ADPATCH
·         6083201: MERGE STATEMENT WITH XML TYPE FAILS WITH ORA-7445 [FCLOSE()+29]

Backup level 0 do banco de dados:

[oracle@portal /]$ rman target / nocatalog
Recovery Manager: Release 11.1.0.7.0 - Production on Sat Feb 1 09:35:14 2014
Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: BEEHIVED (DBID=3636825317)
using target database control file instead of recovery catalog

RMAN> backup as compressed backupset incremental level 0 database plus archivelog;

Starting backup at 01-FEB-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
.
.
.


Disable Fast Validation in the Database

ALTER SYSTEM SET "_disable_fast_validate"=TRUE SCOPE=BOTH SID= '*';

Install Patch 7311226 on 11.1.0.7.x

No meu caso, estava faltando apenas este patch.


[oracle@portal 7311226]$ pwd
/backup/zaballa/patch_banco/7311226
[oracle@portal 7311226]$ /u01/app/oracle/product/11.1.0/db/OPatch/opatch apply
Invoking OPatch 11.1.0.6.2

Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.1.0/db
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.2
OUI version       : 11.1.0.7.0
OUI location      : /u01/app/oracle/product/11.1.0/db/oui
Log file location : /u01/app/oracle/product/11.1.0/db/cfgtoollogs/opatch/opatch2014-02-01_10-09-30AM.log

ApplySession applying interim patch '7311226' to OH '/u01/app/oracle/product/11.1.0/db'
.
.
.
OPatch succeeded.

[oracle@portal /]$ sqlplus CTXSYS/******
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Feb 1 10:25:33 2014
Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Ligado a:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @?/ctx/admin/drvddl.plb

Corpo de pacote criado.

SQL > connect / as sysdba
Ligado.
SQL > @?/rdbms/admin/utlrp

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2014-02-01 10:25:50
.
.
.
Procedimento de PL/SQL concluido com exito.


Aplicando o Patch no Beehive:

[oracle@portal ~]$ export ORACLE_HOME=/u01/app/oracle/product/beehive
[oracle@portal ~]$ $ORACLE_HOME/OPatch/opatch napply -post -sys_passwd ****** -dbconnstr "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=portal)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=beehivedb)))" -first_midtier -opatch_post_end

Invoking OPatch 10.2.0.4.8

Oracle Interim Patch Installer version 10.2.0.4.8
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

UTIL session

Oracle Home       : /u01/app/oracle/product/beehive
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.8
OUI version       : 10.2.0.5.0
OUI location      : /u01/app/oracle/product/beehive/oui
Log file location : /u01/app/oracle/product/beehive/cfgtoollogs/opatch/opatch2014-02-01_10-30-48AM.log

Patch history file: /u01/app/oracle/product/beehive/cfgtoollogs/opatch/opatch_history.txt
.
.
.
Beehive Upgrade Assistant completed successfully

Beehive Upgrade completed

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.


Aplicando o Patch no Beekeeper:

[oracle@portal Beehive_20180]$ export ORACLE_HOME=/u01/app/oracle/product/beekeeper
[oracle@portal Beehive_20180]$ $ORACLE_HOME/OPatch/opatch napply
Invoking OPatch 10.2.0.4.8

Oracle Interim Patch Installer version 10.2.0.4.8
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

UTIL session

Oracle Home       : /u01/app/oracle/product/beekeeper
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.8
OUI version       : 10.2.0.5.0
OUI location      : /u01/app/oracle/product/beekeeper/oui
Log file location : /u01/app/oracle/product/beekeeper/cfgtoollogs/opatch/opatch2014-02-01_11-41-09AM.log

Patch history file: /u01/app/oracle/product/beekeeper/cfgtoollogs/opatch/opatch_history.txt
.
.
.
Beehive Upgrade completed

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.

Update hasbind File Ownership

[root@portal bin]# chown root hasbind
[root@portal bin]# chmod a+x hasbind
[root@portal bin]# chmod a+s hasbind

Reset Fast Validation in the Database

ALTER SYSTEM RESET "_disable_fast_validate" SCOPE=SPFILE SID='*';

Run Perl Script post_upgrade_db_actions.pl

[oracle@portal db]$ beectl list_schemas --schema_type 2

schema_name: BEE_DATA schema_id: 85 version_id: 2.0.1.8.0 schema_type: 2 status: 4 creation_time: 2009-06-12 09:20:41.0 activation_time: 2009-06-12 09:20:41.0 description: BEE_DATA schema


Verificando o schema que estava ativo:

[oracle@portal db]$ beectl list_schemas --schema_type 1

schema_name: BEE_CODE schema_id: 86 version_id: 1.5.1.1.0 schema_type: 1 status: 6 creation_time: 2009-06-12 09:20:41.0 activation_time: 2009-06-12 09:20:41.0 legacy_time: 2009-10-17 19:40:46.0 deactivation_time: 2010-05-22 11:13:44.0 description: BEE_CODE schema
schema_name: BEE_CODE_02012014 schema_id: 99 version_id: 2.0.1.8.0 schema_type: 1 status: 4 creation_time: 2014-02-01 09:54:39.0 activationready_time: 2014-02-01 10:16:50.0 upgradeready_time: 2014-02-01 10:12:50.0 activation_time: 2014-02-01 10:17:28.0 description: BEE_CODE_02012014 code schema
schema_name: BEE_CODE_10172009 schema_id: 94 version_id: 2.0.1.4.0 schema_type: 1 status: 5 creation_time: 2009-10-17 19:15:59.0 activationready_time: 2009-10-17 19:40:29.0 upgradeready_time: 2009-10-17 19:36:08.0 activation_time: 2009-10-17 19:40:46.0 legacy_time: 2014-02-01 10:17:28.0 description: insert description here


Verificando o schema ativo após o upgrade:

[oracle@portal db]$ beectl list_schemas --schema_type 1 --status 4

schema_name: BEE_CODE_02012014 schema_id: 99 version_id: 2.0.1.8.0 schema_type: 1 status: 4 creation_time: 2014-02-01 09:54:39.0 activationready_time: 2014-02-01 10:16:50.0 upgradeready_time: 2014-02-01 10:12:50.0 activation_time: 2014-02-01 10:17:28.0 description: BEE_CODE_02012014 code schema


Rodando o script de post upgrade:

[oracle@portal ~]$ export ORACLE_HOME=/u01/app/oracle/product/beehive
[oracle@portal ~]$ cd /u01/app/oracle/product/beehive/beehive/db/

[oracle@portal db]$ /u01/app/oracle/product/beehive/perl/bin/perl post_upgrade_db_actions.pl BEE_DATA BEE_CODE_10172009 BEE_CODE_02012014 ******** "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = portal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = beehivedb)))"
Perl has been invoked from the Beehive Oracle home
Starting to flush old schema event and action queues
connect BEE_DATA/*******@'(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = portal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = beehivedb)))'

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Feb 1 12:05:57 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> SQL> Connected.
SQL> SQL> Rem
SQL> Rem $Header: ocscore/projects/event/src/sql/migrate_old_queue_events_to_new_queue.sql /main/1 2009/03/23 17:54:32 djambula Exp $
SQL> Rem
SQL> Rem migrate_old_queue_events_to_new_queue.sql
.
.
.
Finished attempting to run all post upgrade actions
Event queue migration: Succeeded
Subscription reenabling: Succeeded
Capture changes reenabling: Succeeded
Method monitoring reenabling: Succeeded
Method monitoring cleanup reenabling: Succeeded
Client Applications upload: Succeeded
Client Applications provisioning: Succeeded
Device Profiles upload: Succeeded
Notification Templates upload: Succeeded
Actionable Notification Templates upload: Succeeded
DBMS Jobs stopped: Succeeded
Deactivating old code schema: Succeeded
Final cleanup schema: Succeeded

All postupgrade actions succeeded.

Gathering Statistics About Oracle Beehive Data and Code Schemas After Upgrading


[oracle@portal ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Feb 1 12:12:14 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Ligado a:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > exec DBMS_STATS.GATHER_SCHEMA_STATS('BEE_CODE_02012014');
Procedimento de PL/SQL concluido com exito.

SQL > exec DBMS_STATS.GATHER_SCHEMA_STATS('BEE_DATA');
Procedimento de PL/SQL concluido com exito.
SQL>

 Upgrade Inventory Version


cd /backup/zaballa/patch_beehive/14372656/Beehive_20180/custom/script
unzip BeekeeperVersionUpgradeTo20180.zip
unzip BeehiveVersionUpgradeTo20180.zip
cd BeehiveVersionUpgradeTo20180
chmod +x BeehiveUpVerTo20180JdkTo1502402.sh

./BeehiveUpVerTo20180JdkTo1502402.sh /u01/app/oracle/product/beehive
Silent Beehive Inventory Upgrade to Version 2.0.1.8.0 Started...
.
.
.
The installation of Oracle Beehive Release 2 was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-02-01_12-17-55PM.log' for more details. 

cd BeekeeperVersionUpgradeTo20180
chmod +x BeekeeperUpVerTo20180JdkTo1502402.sh
./BeekeeperUpVerTo20180JdkTo1502402.sh /u01/app/oracle/product/beekeeper/
Silent Beekeeper Inventory Upgrade to Version 2.0.1.8.0 Started...
.
.
.
The installation of Oracle Beekeeper was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-02-01_12-19-42PM.log' for more details.