Latest Posts

E-Business 12.1.3 Displaying Clear Text Password

Recently I came across a post in one of the LinkedIn groups that someone shared about discovering the apps password being displayed in clear text in Oracle E-Business Suite 12.1.3 when compiling Oracle Forms either by the adpatch or adadmin utilities.  The person had an SR open with Oracle Support on the issue and they provided them with a patch to resolve it.  Thankfully he shared the patch number with everyone. It seems that this security flaw was fixed sometime back but through some other set of patches must of broken this functionality.  I decided to test in a sandbox…
Read more

Chicago Oracle Users Group Meeting June 22nd 2016 – Recap

We had another great meeting on June 22nd. We had 3 excellent presenters with a mix of awesome topics! Our first presentation was by Brad Petrus, Vendita’s Vice President of License Management, who presented on Oracle Licensing. We had some technical difficulties with the projector which turned this into an impromptu Q&A. This was fantastic as we had all kinds of interesting questions about certain configurations which Brad fielded like a pro. Very informative! There should be more presentations and discussions on Oracle licensing. Perhaps this would help to clear some of the mystery surrounding licensing. Our next presentation was…
Read more

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

COLLABORATE16 – First Time Presenting

I just returned from another great Oracle user group conference in Las Vegas, Collaborate 2016. The folks at OAUG, IOUG and Quest did a wonderful job again! This was my second time attending Collaborate with last year being my first. In fact, right after last years’s conference, I opened up my blog and wrote my first post called Collaborate15 – First Time Attending. This year I took a chance and submitted two abstracts to see if I would get accepted as a presenter. I was fortunate enough that one of these presentations was selected (Extending Oracle EBS 12.1.3 with Oracle…
Read more

Chicago Oracle Users Group – Two Year Retrospective

It’s been a little over two years since I first became President of the Chicago Oracle Users Group and I’ve been looking back at this whole journey.  It all started in January of 2014 when COUG members received an email from the previous President with a special message.  He was apologetic in his email as he had been busy with various startup companies and had let the focus of the group lapse.  This was completely understandable as he was running the COUG solo and anyone that’s ever been involved with a user group knows that this isn’t a paid position but…
Read more

Extending RAC Database Home Hangs

Recently I had to extend the RAC database home of an existing RAC cluster to two new servers using addnode.sh and it was hanging at 100%. The particular version of the Oracle database is 11.2.0.3 running on Oracle Enterprise Linux 5.8.  I didn’t see anything in the log files but notice that the underlying java server process is consuming 100% of CPU when issuing top. I try restarting the addnode.sh step multiple times but I continue seeing the same behavior (even waiting more than 60 minutes with no progression). I start by increasing the Java heap size for the JRE used by the…
Read more

Chicago Oracle Users Group Meeting February 18th 2016 – Recap

We kicked off 2016 with a great meeting on February 18th. We had an excellent presentation by Tony Jedlinski and two presentations by Oracle Ace Director, Jim Czuprynski! Tony was our COUG “Show and Tell” and provided us with a great demo on how quickly you can go from a spreadsheet to a full blown Oracle Application Express (APEX) application in a matter of minutes. Now instead of a spreadsheet sitting on someone’s PC you have a browser accessible, secure and scalable application in an Oracle database. Jim’s first presentation was titled Analyze This! Leveraging Oracle 12c Analytical Functions. Jim went over…
Read more

Adding New SAN Disks to ASM for OCR Disk Group

Recently we had to migrate our ASM disks to a new SAN.  In this particular post we’ll take a look at the steps we went through for the diskgroup that is used by our Oracle RAC servers for the Oracle Cluster Registry (OCR) and the voting files.  The environment is Oracle database 11.2.0.3 on Oracle Linux 6.4.  This particular diskgroup (we’ll call it OCR) was originally created with 3 disks with normal redundancy.  We provisioned 3 new LUNS from our new SAN to replace the current OCR disks. Note: The original disks were named VOL1 – VOL3 while the new ones…
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