Ola pessoal, me deparei com um problema e resolvi criar este post. Estava criando uma base para testes e no término da criação do banco de dados via DBCA. A base de dados foi criada, mas o Database Control não foi criado. Ao analisar os logs no diretório cfgtoollogs , descobri o seguinte erro: “current ORACLE_HOME: not included in ORACLE_HOMEs’ from inventory.”.
A localização Inventário Central é determinada pelo arquivo oraInst.loc.
Em ambiente Linux, que e ambiente que estou utilizando o arquivo esta localizado em /etc/oraInst.loc.
Para verificar se o Oracle Home está registrado no Inventário, execute o seguinte comando abaixo:
[oracle@standby] cd $ORACLE_HOME/OPatch
[oracle@standby OPatch]$ ./opatch lsinventory -all
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/oraInventory from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/db_1/oui
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-06_11-04-53AM.log
Patch history file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
List of Homes on this system:
Inventory load failed… OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo
OPatch failed with error code 73
Se o Oracle Home está faltando no Inventário, execute o seguinte comando para corrigir o problema:
[oracle@standby OPatch]$ $ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=”/u01/app/oracle/product/11.2.0/db_1″ ORACLE_HOME_NAME=”standby”
Starting Oracle Universal Installer…
Checking swap space: must be greater than 500 MB. Actual 1023 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-11-06_11-07-15AM. Please wait …
[oracle@standby OPatch]$ The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/oraInventory ‘AttachHome’ was successful.
Conforme verificado o problema foi corrigido.Depois de corrigido o inventário, verifiquei o mesmo para checar a correção do problema:
[oracle@standby OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory -all
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/oraInventory from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/db_1/oui
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-06_13-25-35PM.log
Patch history file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-11-06_13-25-35PM.txt
——————————————————————————–
List of Oracle Homes:
Name Location
standby /u01/app/oracle/product/11.2.0/db_1
There are no Interim patches installed in this Oracle Home.
——————————————————————————–
OPatch succeeded.
Após a correção do problema, consegui configurar o EM Database Control na base de dados.
Um abraço a todos