Ardent Performance Computing
Jeremy
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
Who’s Accessing That File?
From the occasionally-useful-scripts library… It’s like fuser but shows name of the process (args[0]). Needs lsof installed. I’ve used it on Linux and Solaris. nap01:~$ cat jduser #!/bin/sh [ -n “$1” ] && [ -d “$1” ] || { echo “Usage: $0 [dir]”; exit; } AWK=awk; [ “`uname`” = “SunOS” ] && AWK=nawk; lsof +d … 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
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
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