Ardent Performance Computing
Technical
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
RAC File Permissions Quick Reference
I was just thinking today about how useful it might be to have a quick reference to permissions on Oracle RAC databases. Can’t tell you how many time I’ve asked “what should the permissions be for this”… so I’m just going to use this post for all the files I can think of and their … 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