A quick walkthrough of a problem I encountered with the ASO_ORDER_FEEDBACK_T table growing out of control.
-
Content License
-
Category Archives: EBS
Quick tip: Moving an SSO-integrated E-Business Suite database
29 May 2009 – 11:45
It seemed simple enough. We were moving our E-Business Suite database to a new server. References to the old database server had to be replaced in a variety of places: Oracle Internet Directory, a handful of tnsnames.ora files, and of course, the context files on the application tier servers. After that, everyone could connect to the database just as they always had. No problems, right?
Well, okay, maybe one small problem.
Things I learned this weekend (5/16-17/2009)
18 May 2009 – 21:30
The excitement of solving mysteries makes me bad at math In my last post, I failed to notice that a HugePages_Total of 4645, while satisfyingly greater than zero, is definitely not 8196, the desired and expected value I had configured. Upon reflection, the reason was pretty obvious: the OS will only allocate contiguous blocks of [...]
EBS 12.1 now generally available
4 May 2009 – 9:40
E-Business Suite Release 12.1 is now available. I’ve started collecting reference links that could be relevant to an upgrade, and am making them available here.
How old is that E-Business Suite clone, really?
30 April 2009 – 11:56
In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.
More fun with Grid Control and EBS
22 March 2009 – 19:50
After two months of cheerfully monitoring your E-Business Suite instances, Grid Control declares that most of the Apps tier targets have ‘Unknown’ status. What just happened? Sunspots? Evil gnomes? E-Business Suite snubbed Grid Control at an enterprise software social event? Maybe. Or maybe you just have password problems.
Whose log file is it, anyway?
17 March 2009 – 22:20
Today, I wrote a quick and dirty script to query FND_PROFILE tables to get information about a log file I found on an E-Business Suite app tier. Not particularly revolutionary, but on the off-chance that it helps someone, I’m sharing.
R12 Apps DBA certifications are shipping…
18 February 2009 – 22:50
In which I engage in a little self-indulgent “tooting my own horn” in the wake of receiving my R12 Apps DBA OCP certification.
The strange case of a failing adstrtal.sh script…
11 February 2009 – 13:47
I recently ran across an interesting situation while I was working on an E-Business Suite environment: the adstrtal.sh and adstpall.sh scripts weren’t doing anything. They weren’t showing errors, but neither were they starting or stopping services. This post takes a look at the problem, unearths the cause, and presents a solution that isn’t always palatable, but in this case is warranted.
Fixing file permission problems on Grid Control targets
26 January 2009 – 16:33
When installing Grid Control on a Linux or Unix platform, a recommended practice is to install the monitoring agent software as a user that doesn’t own the ORACLE_HOMEs to be monitored. This poses a challenge when configuring monitoring for some targets, particularly those based on Oracle Application Server 10g. This post lists some changes you can make to work around a variety of target discovery and metric collection errors.