Author: Alex Gorbachev

oracle.com Account Locked – How to Access My Oracle Support?

I got an error message trying to login at oracle.com saying my account was locked. There was a simple solution for this, all you need to do is to use “Forgot password” functionality – this will reset your password and unblock the account.

Read More >

Keeping Up

I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Gwen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.

Read More >

Oracle UTF8 Encoding and String Manipulation Overhead

For one of our customers, I’ve recently reviewed the strategy of migration from single-byte encoding to variable length multi-byte UTF8 (AL32UTF8 encoding in Oracle naming standards). These type of projects are coming up again and again so I think it must be common for many of you. Thus, this bit might be useful. This is the PL/SQL block I came up with

Read More >

APEX — Bulk Images Upload Using EPG

was recently installing one APEX application and needed to upload a bunch of images. APEX was configured to use EGP (Embedded PL/SQL Gateway) so traditional options were to configure FTP or WebDAV but I’d rather not open these services on production environment. Our resident APEX expert pointed me to the installation process and suggested there is a simple way to do that using a single PL/SQL call. It turned out that it was more than a single PL/SQL call involved but nothing too difficult. What you need is to create the hierarchy of files and directories that you want to upload (images or not – doesn’t matter). Then you create an XML file imagelist.xml listing required directories and files to upload. Here is the example:

Read More >

Ultimate SQL Tune-off with Jonathan Lewis and Kyle Hailey

This is just a short blog post to spread the word about the upcoming webinar organized by Embarcadero with fellow member of OakTable Network — Jonathan Lewis and Kyle Hailey — Ultimate SQL Tune-off.

Read More >

Presentation and Interview at NoCOUG Spring Conference

NoCOUG Spring Conference 2010 is in just 10 days, I’ll be doing my two hour long presentation — Demystifying Oracle RAC Workload Management. If it’s your local conference, I hope you can attend and say hello. You might also want to download the whitepaper that I put together few years ago for Hotsos Symposium — Oracle RAC Workload Management.

Read More >

MOW2010 — Slides for Alex Gorbachev’s Sessions

I want to post the slides of the two presentations I did. My first presentation was a double slot session about Oracle Clusterware internals. My second presentation was about how we designed and run 1TB MySQL database in high availability setup.

Read More >

Welcome Gwen Shapira to Pythian

I’m excited to announce that Gwen Shapira has started with Pythian this week. :) Chen is no stranger here and many of my colleagues already know her and were in touch — she just naturally fits in.

Read More >

Oracle Enterprise Manager 11g Documentation Available Online

There you can find the list of EM 11g new features. After I quickly skimmed through it I could mention few areas…Here is the surprise you might not have expected — you now need to install Oracle WebLogic Server 10.3.2 (Oracle Fusion Middleware 11g Release 1 Patch Set 1) as a pre-requisite to Oracle Grid Control installation.

Read More >

When Was Your Last Disaster Recovery Test?

A regular DR procedure validation is designed to minimize the risk of a broken process to go unnoticed. If the failure is detected during a regular switchover process, you are prepared to handle it way better (or potentially just leave services on the currently primary site) than during emergency failover when you get to the “Oh shit!” moment under the tremendous pressure to get services back.

Read More >