Latest Posts

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

Chicago Oracle Users Group Meeting September 17th 2015 – Recap

We had another great user group meeting recently! We had two excellent presentations by well known Oracle Ace Director, Tim Gorman! The first presentation was focused on Accelerating DevOps using Data Virtualization. This was a great presentation and really demonstrated that the next step in virtualization is at the data/storage level. Only with data virtualization can you accelerate the testing/deployment cycle to speed up project times, improve project quality and put a company at a competitive edge. All of this while using less storage than we ever thought was possible but with the ability to provide numerous copies of our production…
Read more

Chicago Oracle Users Group – RAC Attack! 12c Workshop

The Chicago Oracle Users Group organized a great RAC Attack! 12c workshop last Saturday, August 22nd. Even with the gorgeous summer weather we had an amazing turnout! Over 30 people showed up to learn how to install Oracle RAC on virtual machines on their own laptops. I had a great team of mentors that were helping our participants in the workshop. A special thanks to Ashok Sivasankaran, Ittichai Chammavanijakul and Omar Ahmad for helping folks get past issues they may have had. Additionally, Ashok gave us a great presentation overview on Oracle RAC and Omar did one on VM templates for…
Read more

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

The Problem Recently I was going through a list of our top largest tables in our E-Business Suite (12.1.3) database (11.2.0.3) and found many tables in the GL schema that began with XLA_GLT_*.  Looking into this further I found over 300 of these tables (which also had indexes and synonyms) consuming over 30 Gigs of space.     Research After doing some research on My Oracle Support I found several articles that helped explain what we are seeing.  One of them in particular was a direct match to our problem, “SLA: Temporary Tables XLA_GLT_ % Are no Longer Dropped (Doc…
Read more

Chicago Oracle Users Group Meeting July 23rd 2015 – Recap

We had another great user group meeting this past Thursday! We had two excellent presentations by two very well known speakers! Our 1st presentation was by Oracle Ace, Biju Thomas. He did a great job going over a lot of cool new features available in 12c especially for those of us that are still 11g DBAs. Our 2nd presentation was by Oracle Ace Director, Jim Czuprynski. He provided a great presentation on the JSON features available in the Oracle Database 12.1.0.2. In his presentation he mentioned a really cool data mocking site called Mockaroo. I’ll have to keep that in…
Read more

12c New Feature – Online Statistics Gathering for Bulk Loads

How many times have we had to execute a CREATE TABLE AS SELECT or INSERT INTO…SELECT that involved a large amount of data then wondered why queries against this table are slow? Did we forget to gather statistics after the fact perhaps? Well in Oracle Database 12c there is a new feature that will gather online statistics for you when performing bulk loads when using either one of two bulk loading methods: 1) CREATE TABLE AS SELECT 2) INSERT INTO … SELECT into an empty table using a direct path insert   Example – Default Behavior (CREATE TABLE AS SELECT)…
Read more

Chicago Oracle Users Group Meeting May 13th 2015 – Recap

We had another great user group meeting this past Wednesday! We had 2 excellent presentations. Our 1st presentation was by Oracle Principal Sales Consultant Omar Amad on Oracle Linux, Oracle VM and Oracle Cloud.  This also included a live demo of Oracle Ksplice and why not installing the latest security patches can leave us open to vulnerabilities. Our 2nd presentation was by Oracle Ace Director, Michelle Malcher, on Oracle Database 12c Security. She provided a very informative overview of security improvements in 12c which gives us yet another reason why we should be moving towards this version. Our meeting was…
Read more

RMAN Duplicate Error with ASM and 4k Sector Size Disk

The Problem I recently ran into an issue when performing a RMAN duplicate on a server with a fresh installation of OEL 6.4 x86-64 using a brand new SAN (NetApp Data ONTAP 8.2).  The database version is Enterprise Edition 11.2.0.3. The datafiles restored without an issue but when we got to those archived redo logs I hit an ORA-00600.  Specifically it was this error. At first I chalked it up as a fluke, so I tried the RMAN duplicate again.  Well the datafiles restored just fine but once again when I got to the archived redo logs I hit the ORA-00600…
Read more

Chicago Oracle Users Group (COUG)

As of February 2014, I feel fortunate and honored to be put in charge of running the Chicago Oracle Users Group (COUG). I really feel like I’m doing our user community a great service by coordinating these periodic meetings to allow all of us to continue to get educated on the latest Oracle technologies as well as provide beneficial networking opportunities. Last year we were able to hold 5 meetings including one large meeting with Tom Kyte. This year we are off to a good start with a meeting in Feburary and another one coming up in May. If you…
Read more