Author: Christo Kutrovsky

So, you just installed the Oracle 10g clusterware, you just ran root.sh and got an error, you just went to metalink Note:316583.1 or Note:387691.1 the given interface(s), “eth0” is not public, public interfaces should be used to configure virtual IPs, it just failed, and now you are relying on Google to help you with what Metalink couldn’t. Well look no more, and here’s the solution.

Linux is a wonderful operating system. However there are a number of things that one needs to do to make sure it runs as efficiently as possible. Today, I would like to share one of them. It has to do with using ASM (Automatic Storage Manager) disks.

In this new installment of Pythian Goodies Doug Burns discusses Parallel Basics. This video is a good introduction to using Oracle Parallel features and most importantly, what problems you may have with it.

Two weeks ago, I released a video about Flash Recovery Area as part of the Pythian Goodies project. Here is the next video in the sequence, Oracle I/O Basics.

I got a call from a developer who had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled how this could be. We changed the sequence to “ordered” and increased the cache to 1000. Now selecting on either node gets the next number as he expected. I warned him that there would be some performance implications due to cluster synchronization. Him being a responsive developer, asked me what the impact would be, so I tested it out.

On Friday, I announced the Pythian Goodies project, and now here it is, the very first video of the series. The topic is “Flash Recovery Area,” and how can it make your life easier.

I’ve been wondering for a while now how best to transfer knowledge efficiently and in a fun way. Presentations are good, but they require a lot of effort in preparation and research, and they are not as interactive as they could be when the group is smaller. To answer some of these issues, I would like to introduce you to Pythian Goodies. What is a Pythian Goody session you ask? Find out here.

Many people would like to know how well their application will run in RAC. Would it be faster or slower? Would it run at all? Well, I have a query that can answer that question. There’s a caveat however. You have to first put your application in RAC, then the query can tell you how well it runs.

As I was poking around metalink, I found the following extremely interesting section. It’s in a very obvious place, but it’s new, so many of you may have not noticed it. It’s called “Support case studies” and provides some amazing articles.

When I read Note: 391116.1 with the full list, I noticed the following bugs that we’ve encountered are fixed. Unfortunately, an important bug in 10.2.0.2 posted on the Sept. 29 is not listed as fixed in this patch list.