ALL POSTS

Failovers with Oracle Dataguard

In the last month, we have been hit with two clients’ large-scale failures. The first involved network issues; the second, disk failures. What happened?. We took one of the standbys and turned it into a primary. The other standby then automatically started recovering from the new primary! That was it. What a let down! No magical status updates, no little “dots” going across the screen. Just one line and 15 seconds. Oracle, get your act together! I even had to use bold text to make it stand out.

Using the Oracle Wait Interface to Troubleshoot I/O Issues

One of our more stable clients had some serious “mystery” production problems. To paraphrase, their app that was running “OK” starting running “sucky”. I knew that nothing had changed from our end and so being the intrepid super-sleuths that we are, we determined that the problems were related to I/O.

Oracle Data Pump Can’t Import LONG Columns

If you are using Oracle Data Pump to backup tables containing LONG or LONG RAW columns, then you might be surprised when trying a recovery. Well, you tested it already. Didn’t you? ;-) Right now I’m in the middle of a production migration. Earlier this week while testing this migration, I noticed couple strange errors during Data Pump import:

Oracle Data Pump Schema Export and Public Synonyms

While testing a migration, I figured out that schema export using Data Pump doesn’t capture public synonyms on the objects in this schema. Does anyone know how to make Data Pump include public synonyms with schema export? Update: This is actually the same behavior as old Export utility.

Oracle popularity – 8i vs. 9i vs. 10g

A few days ago Kevin Closson (keep an eye on this new blog and expect to find something interesting there) mentioned that Oracle 8.1.7 is one of the most mature releases (at least I understood it this way). I agree with him that many people still use it, but how many? Visit Google Trend and enter “oracle 8i, oracle 9i, oracle 10g” and take in the popularity trends.

Page 229 of 251« First...102030...227228229230231...240250...Last »