Ardent Performance Computing
Archive for
Replicating Tanel’s Script Library
Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory. Please remember that as Tanel says on his own website, “always proofread the scripts and … Continue reading
Convert Raw/Hex to Timestamp
Just filing this away on my own blog because it seems that I always have hard finding it via google. Here’s some code to convert raw/hex values into timestamps. (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low values in column statistics.) As … Continue reading
Delete Archived Logs from Standby
This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system. (Specifically, a RAC/thread aware script.) There are a few scripts published: Emre Baransel [2009, single-thread only, uses alert … Continue reading
OSP #2b: Build a Standard Platform from the Bottom-Up
This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth. In the first half of this article we discussed platform standardization at a … Continue reading
OSP #2a: Build a Standard Platform from the Bottom-Up
This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth. I hesitate greatly to use the word “standard” having seen the ways it … Continue reading
Minimal-downtime PSUs on CRS with Cloned Golden Images
About a month or two ago, I was doing some work toward developing a process to patch CRS out-of-place using cloned golden images. I held off on publishing anything because I wanted to do some testing but we’ve been so busy with deployments and maintenance over the past month that I haven’t had a chance. … Continue reading
Create Tablespace and ORA-28374
One of the projects I worked on last week was improving our processes around encryption in Oracle. I spent a lot of time becoming intimate friends with the database wallet. Late in the week while attempting to create an encrypted tablespace on an 11.2.0.3 (PSU6) system, we mysteriously ran into ORA-28374. Oddly enough we were … Continue reading
OSP #1: The Foundation
This is the third of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth. As a starting point for our discussion of scalable … Continue reading
Listener Error from addNode.sh with Second Network
Recently I ran into an problem with 11.2.0.3 RAC. I observed this on a system patched to PSU6 and it looks like a bug to me. But the interesting part isn’t the problem – it’s an impressive and creative workaround that my colleague found over the weekend. I should add that this teammate doesn’t have … 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