Author Archive: Alfredo

Purging Oracle EBS Integrated SOA Gateway Tables

If you happen to be using Oracle E-Business Suite Integrated SOA Gateway (ISG) you may at some point find yourself retaining way too much data.  Did you know that there is a seeded purge program available that will delete data from the underlying tables?  This is helpful to maintain the data at a reasonable size to help performance and minimize the storage footprint.   Observations My SOA purging journey began due to a performance related issue.  This occurred when I navigated to the Integrated SOA Gateway responsibility > SOA Monitor, it was taking upwards of 5 minutes to pull up that web page.  When I…
Read more

Collaborate 2017 Recap

Collaborate 2017 Recap Well another Collaborate conference has come and gone.  I cannot even believe how fast it went!  This year marked my 3rd year at Collaborate.  Initially as an attendee registered under IOUG but a few weeks before the conference I was asked by OAUG to present my session from last summer’s Apps Tech virtual conference.  I was more than happy to help and very excited to be presenting again! My goals of the conference were: Attend as many E-Business Suite, Cloud, Big Data, and personal development sessions as possible Inspire some new folks, through my presentation, to extend…
Read more

Chicago Oracle Users Group Meeting February 23rd 2017 – Recap

We kicked off 2017 with an awesome Chicago Oracle Users Group meeting on February 23rd. We had excellent presentations by Moizuddin Mohamed and Oracle Ace Director, Jim Czuprynski! Moizuddin was our COUG “Show and Tell” and provided us with a presentation on GoldenGate High Availability Using DBFS in an Exadata/RAC environment. He demonstrated a use case where he has a DBFS instance at a primary site but uses GoldenGate to replicate the DBFS instance to a disaster recovery site as well.  Giving the ability to easily start the instance at either site for both planned and unplanned outages with minimal…
Read more

Chicago Oracle Users Group – Cloud Experience Workshop Recap

You really can’t go anywhere these days without hearing about the “cloud”.  If you’re an Oracle technologist you should be well aware of all the Oracle Cloud offerings that are available.  If you’re a DBA then it’s critical to understand the role of the Oracle Cloud in your day to day decisions for current and upcoming IT projects. The COUG had an awesome Cloud Experience workshop at the end of October where we were able to experience building a database (single instance or even RAC) in the Oracle Public Cloud. Our workshop was led by Oracle Ace, Erik Benner.  Erik started…
Read more

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