Wednesday, March 16, 2016

[RDBMS] File /etc/oratab is not accessible

Situation:When running the Database Configuration Assistant (DBCA) a dialog window appears with the following error message:

File /etc/oratab is not accessible.

Problem:
After installing Oracle Database 11gR2, you missed to run the two scripts orainstRoot.sh and root.sh.

Solution:
As root user, execute 
$ORAINVENTORY/orainstRoot.sh and $ORACLE_HOME/root.sh

[Cloud Control 12c] OMS installation fails with ORA-14400

Situation:
During the installation of Oracle Enterprise Manager 12c Cloud Control, at the OMS Configuration phase you found it fails because of the following error:

INFO: oracle.sysman.top.oms:java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
INFO: oracle.sysman.top.oms:ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1537
INFO: oracle.sysman.top.oms:ORA-06512: at line 1
INFO: oracle.sysman.top.oms:

INFO: oracle.sysman.top.oms:OMSCA-ERR:Post deploy operations failed. Check the trace file:/u01/app/oracle/product/Middleware/oms/cfgtoollogs/omsca/omsca_20140402160051.log
INFO: oracle.sysman.top.oms:
Check the OMS Configuration Assistant logs at: /u01/app/oracle/product/Middleware/oms/cfgtoollogs/omsca

INFO: oracle.sysman.top.oms:The plug-in OMS Configuration has failed its perform method

Solution:
The partitions are not created on the database used for OMS Repository when using the DB Template, hence OMS Configuration fails.

To solve this issue, execute the following as SYSMAN:
SQL> exec gc_interval_partition_mgr.partition_maintenance; SQL> exec mgmt_audit_admin.add_audit_partition;

Then, retry the OMS Configuration on the OUI. If OUI is closed then execute the following operating system command (be sure to have $OMS_HOME set):
$OMS_HOME/oui/bin/runConfig.sh ORACLE_HOME=$OMS_HOME MODE=perform ACTION=configure COMPONENT_XML={encap_oms.1_0_0_0_0.xml}