Ardent Performance Computing
Technical
E-Business Suite Applications 11i on RAC/ASM
I recently mentioned working with a client to convert their E-Business Suite environment to RAC and ASM. I enjoyed this project; there are a few good high-level guides to the process but there are still a lot of small hiccups and configuration decisions where I could put my RAC experience to work. The main guide … Continue reading
Automating Those Pesky Linux Prerequisites
Was just perusing Sergio Leunissen’s blog this morning and a couple of his recent posts caught my attention: First off, as someone who frequently installs Oracle on Linux, his post last month about the recently released RPM oracle-validated was great – can’t believe I’d missed that. Basically it’s an RPM that makes sure you have … Continue reading
Listener Subscription To ONS For Cluster Events
Just three quick updates… First of all, yesterday we re-ran rconfig a few times and confirmed – for sure – that the PRKP-1001 and CRS-0215 errors tuesday were from the listener/ONS problem. Secondly, just an observation – I noticed yesterday that somehow a few of the listeners are still registering with ONS even with the … Continue reading
Crazy Networking Problem on Linux
And the saga continues… Tuesday I mentioned a PRKP-1001 from rconfig – however I think that the root cause might have been something quite different from my original suspicion. Yesterday we discovered a rather major issue on the server… when trying to configure EM dbcontrol I started receiving errors indicating that the ports weren’t free. … Continue reading
PRKP-1001 Converting To RAC+ASM With Rconfig
This week I’m working with a client to help them get an Oracle Applications environment up and running on RAC. We started with metalink note 362135.1 as a general guide for the process. Although I am much more familiar with RMAN this note recommended using rconfig to convert the database to RAC+ASM. (rconfig is the … Continue reading
LOCAL_LISTENER and ORA-12545
How ironic that just this afternoon I read James Morle’s recent whitepaper about Connection Management in an Oracle RAC Configuration. One of the first things that James unearthed during his testing was a bug in how Oracle’s assistants configured RAC networking settings – specifically in how they don’t correctly set the LOCAL_LISTENER parameter. Of course … Continue reading
Centralized TAF Configuration in 10g, Part 2
For the past month I’ve been intending to put together a post about DBMS_SERVICES and TAF – so I guess it’s about time to do it. I introduced the topic back in February in my discussion of 10g enhancements to client-side TAF configuration. As I pointed out then, there are two ways to configure TAF … Continue reading
NOT NULL Plus TAF Causing ORA-08176
Just stumbled onto an interesting situation with TAF. Turns out that you can get an ORA-08176 error (consistent read failure; rollback data not available) from a SELECT statement that fails over with Transparent Application Failover in a RAC configuration. And I seem to have found a situation where adding a NOT NULL constraint to a … Continue reading
DBCA Slow? Check Host Equivalence.
Heh – just ran into an all-too-familiar “duuh” situation. I was launching DBCA to update a few settings on some services in a test database and it was taking …f…o…r…e…v…e…r… to run. It must have spent a minute on this partially updated screen. Now I haven’t launched DBCA in a week or so on this … Continue reading
Tuning SQL Statement Execution in 10g, Part 2
Tuesday I wrote about a client in Houston and removing the RULE hint from queries as part of their 10g migration. This led into a discussion about the four ways to control SQL statement execution: rewriting the SQL, hints, stored outlines and SQL profiles. I then discussed the first two methods – rewriting SQL and … Continue reading
Disclaimer
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.
contact: schneider @ ardentperf.com
Ardent Performance Computing 
Recent Comments