Over the weekend, I spent four long hours resolving an issue with a particular Oracle schema. It turned out to be an issue with the special characters in the password, or you can say: I did not treat special characters specially.

I was playing with an old Perl script on my Oracle 10g enterprise edition database server,  running on Redhat Enterprise Linux Advanced Server 4 (RHEL AS4) Read more »

On one of my old CD-ROM drives, I found a old piece of Perl code that I wrote for Oracle 8i. Thought I could enhance that to work with Oracle 10g and perhaps enhance it. My test server is an RHEL AS4 box and I did install Perl when I installed the OS. My script failed due to missing DBI and Oracle DBD modules Read more »

A good friend of mine once approached me asking if I could summarize Oracle OFA (Optimal Flexible Architecture). He said there is a ton of documentation on-line but nothing that he could read in few minutes. Later that night I wrote him an email and now I modified that email to publish here. What you find below is Read more »