Latest Posts

OTN Appreciation Day: Oracle RMAN

My favorite feature to date has to be Oracle RMAN (Recovery Manager).  Why?  Well I really believe that at the end of the day the most important job of the DBA (and there are many!) is to ensure that the data is protected.  If you lose an organization’s data not only will you most likely lose your job but you could potentially cause some serious financial issues (not to mention bad reputation) for that organization. I may have a different appreciation for RMAN than those who may have not had an opportunity to work with the Oracle database prior to…
Read more

Chicago Oracle Users Group Meeting August 26th 2016 – Recap

We had another awesome COUG meeting on August 26th. We held the meeting at my old stomping ground, The Pampered Chef located in the suburb city of Addison. They provided us with a roomy space, free giveaways (The Pampered Chef Water Infuser), and held an appetizer/cocktail hour afterwards for us. Oracle Ace Director, Rich Niemiec, lead off the morning with a presentation on Innovation, Big Data, Oracle Cloud, IOT and the Future. This presentation was packed with information and left you with a lot of things to contemplate on the future of Oracle and overall technology as a whole. After a…
Read more

SQL Trace for Oracle MWA

Occasionally the need arises to enable SQL trace for Oracle Mobile Web Applications (MWA) for WMS or MSCA related E-Business Suite modules to track down the source of poor performing queries.  Enabling this is quite easy but may not be obvious when looking at the options in the configuration file.  This particular example is assuming E-Business Suite 12.1.3. Let’s take a look at the MWA configuration file (mwa.cfg) located in $INST_TOP/admin/install.  It’s interesting to note that the parameter that we modify to enable SQL Trace, mwa.LogLevel, doesn’t list the value we need for performing a SQL Trace.  It appears that the…
Read more

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