Dbconsole - Orainventory Error Manual Fix 

 

$ emca -repos create

STARTED EMCA at Apr 6, 2016 6:10:46 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:

Database SID: TEST

Listener port number: 1523

Password for SYS user:

Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log.

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

WARNING: ORA-01031: insufficient privileges

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.EMConfig perform

SEVERE:

Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

Some of the possible reasons may be:

1) Listener port 1523 provided is incorrect. Provide the correct port.

2) Listener is not up. Start the Listener.

3) Database service TEST is not registered with listener. Register the database service.

4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.

5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.

6) /etc/hosts does not have correct entry for hostname.

Refer to the log file at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log for more details.

Could not complete the configuration. Refer to the log file at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log for more details

ERROR in logfile :

=============

Apr 6, 2016 6:10:46 PM oracle.sysman.emcp.util.OUIInventoryUtil getOUILoc

CONFIG: Error accessing inventory.

oracle.sysman.oii.oiii.OiiiInventoryDoesNotExistException: The inventory pointed at location /app04/oracle/DEVA/apps/tech_st/10.1.2/oraInventory is not valid

        at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(OiiiInstallAreaControl.java:1910)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:301)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:240)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:189)

        at oracle.sysman.emcp.util.OUIInventoryUtil.getOUILoc(OUIInventoryUtil.java:135)

        at oracle.sysman.emcp.util.ClusterUtil.isHASInstalled(ClusterUtil.java:279)

        at oracle.sysman.emcp.EMConfig.<clinit>(EMConfig.java:159)

        at java.lang.J9VMInternals.initializeImpl(Native Method)

        at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)

        at oracle.sysman.emcp.EMConfigAssistant.<clinit>(EMConfigAssistant.java:211)

        at java.lang.J9VMInternals.initializeImpl(Native Method)

        at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)

Apr 6, 2016 6:10:46 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled

CONFIG: Inventory not found

SOLUTION :

 ==========

Enter the inventory path in /etc/oraInst.loc as below

change the oraInst.loc permission to 644

# cat oraInst.loc

inventory_loc=/testdb/oracle/TEST/db/tech_st/11.2.0.3/oraInventory

inst_group=dba