Ardent Performance Computing
Oracle
Redo Log Filename Extension
I have to say that I really like the oracle-l mailing list. It tends to stay pretty focused on DBA stuff, there’s a low volume of spam and there are a lot of really smart guys who post there. I was just catching up on some threads from last week and a comment about how … Continue reading
Fidelity Case Study
So I guess this is old news since they finished this implementation back in June last year and even presented at Open World. But this case study is just a goldmine of information and totally worth reviewing if you’re anywhere close to RAC, Data Guard, ASM, RMAN, or Flashback (and more I’m sure). The big … Continue reading
Controlfile Recovery Requires RESETLOGS
In response to a small discussion on the oracle-l mailing list last week I thought I’d put together a quick demo of exactly what I was referring to in my email. Basically I was discussing how even when you do a normal shutdown – leaving your database in a consistent state that doesn’t require recovery … Continue reading
Recovering Your Controlfile Without a Backup
Little trick I’d seen once that might come in handy for someone. Lets suppose that somehow you accidentally delete (“rm”) all copies of your current controlfile – and you don’t have a backup!! If the database is still running then don’t shut it down! There might actually be a way to recover the control file. … Continue reading
The Clusterware C API
Well I’ve been incognito for the past two weeks or so because I’ve been finishing up a pretty detailed paper about Oracle Services. Finally finished up the first draft yesterday… it’s 16 pages in the IEEE Computer Society article LaTeX class – which doesn’t leave much whitespace! It’s a pretty comprehensive review of pretty much … Continue reading
Migrating to RAC/ASM with RConfig
That 11i/RAC/ASM project turned out to be fairly interesting for quite a few reasons – another reason was that it gave me an opportunity to become quite a bit more familiar with RConfig. RConfig an Oracle provided java-based utility to fully automate the process of converting a database from single-instance to RAC. It will also … Continue reading
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
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