Posts Categorized: Technical Blog

Oracle 11G SCAN:Questions and Answers Post

his is a follow up post to answer questions you asked during my “Oracle 11G SCAN: RAC SIG webcast” at June 16th. You can get the full presentation HERE..If you are not a member please feel free to join the RAC SIG. The membership is free and it will take you just couple of minutes to get registered (hint: check your spam folder if you don’t see password email from RAC SIG).

Applying External Timing Data to Untimed Events

If you are familiar with debugging ssh connections you are probably familiar with the ‘-v’ option that directs ssh to output verbose comments stating which operation is currently taking place. You can add up to three -v options on the command line, increasing the verbosity with each one. An example follows.

ANZ: Oracle RAC SIG let meet at InSync11

This post is addressed to all RAC SIG members who are planning to participate in the InSync11 conference this August in Sydney Australia! InSync11 is organized by Oracle Community for Oracle Community and is one of the biggest Oracle technology dedicated events in Australia and New Zealand region. This is a wonderful opportunity to learn from others, listen to experts from around the world and meet face to face people from your networks (including RAC SIG).

On Disaster Recovery and my SQL Rally 2011 Presentation

I was reading my session evaluation results and came accross comment that said: “copy and paste coder.” I’ve been doing this specific presentation for almost 5 years now with a few tweaks every once in a while based on feedback. Yes, I live and breathe disaster recovery as part of my day-to-day job. However, there are several reasons why I do not type nor write code during my presentations. Here are a few of them.

Silent MyISAM Table Definition Changes and mysqldump

While trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destination server. I did some digging and found that the problem was that the MyISAM engine silently changed the table definition without any indications. Here are some solutions.

Using a Custom Timezone? Beware Oracle 11.2.0.2 Grid Infrastructure!

We have a client that runs an application that, for whatever reasons, does NOT like daylight saving time. For that reason, the Oracle server is kept in Eastern Standard Time and does not change with the rest of the eastern United States when DST begins and ends every year. They accomplish this with a custom /etc/localtime file. However, they left /etc/sysconfig/clock set to “TZ=America/New_York,” which would prove fateful as I shall point out.

Page 32 of 61« First...1020...3031323334...405060...Last »