EM12c

Watch Those Inodes!

Recently we had an issue where we ran out of inodes on the /tmp mount point of one of our database servers. After investigating what was causing the issue we discovered a sub-directory called orbit-oracle with lots of 0 byte files with a prefix of linc-*. I deleted the files which freed up some of the free space for our inodes but more files were continuing to get generated. A quick search on MOS turned up a direct hit on the issue (Doc ID 2106496.1). The doc mentions making sure that the messagebus service is started. When I checked our problem…
Read more

Chicago Oracle Users Group Meeting November 10th 2015 – Recap

We had another great user group meeting recently. We had two excellent presentations by well known speaker, Kellyn Pot’Vin-Gorman! The first presentation was titled AWR Warehouse and Beyond. Kellyn described what it is, how it can be used and why DBAs should seriously consider using an AWR warehouse. For those DBAs that are concerned with having to maintain more than days or weeks worth of AWR snapshots but perhaps would like to trend over months or years this is the solution for you. Take all of your individual database AWR snapshots and move them to a centralized AWR warehouse.  A…
Read more

OMS Configuration Failure – ORA-14440

On recent fresh installation of EM 12.1.0.5 during the OMS configuration we received a message saying that the OMS Configuration has failed. Viewing the log file to gather more details we found that we were receiving an ORA-14440: inserted partition key does not map to any partition. Searching My Oracle Support found a direct hit with document 1663277.1, EM 12c: Enterprise Manager Cloud Control OMS Installation Fails At OMS Configuration Stage With Message ‘ORA-14400: inserted partition key does not map to any partition’ Reported In CfmLogger*.log The fix was relatively simply and we followed the steps given in the document.   After we…
Read more

Using 12.1.0.2 DB Template for EM 12.1.0.5

Recently we performed a fresh installation of Oracle Enterprise Manager (EM) 12.1.0.5 using Oracle Database Enterprise Edition 12.1.0.2. as the management repository database.  We also installed Oracle Grid Infrastructure 12.1.0.2 so that we could take advantage of ASM for the database datafiles. Oracle provides a great pre-configured database template to help for this particular setup when using EM 12.1.0.5 and DB 12.1.0.2 that can save a little bit of installation time and eliminate having to manually configure various database parameters, tablespaces, etc.  The first thing to do is to determine if you fall into the small, medium or large deployment of…
Read more