About
I’m an Oracle Database Consultant at Enkitec (an Oracle Platinum Partner and one of the first Oracle partners to acquire its own Exadata Database Machine!)..

I made this weblog to serve as my Knowledge File…To share and keep track of all ideas, learnings, and experiences about my areas of interest on ORACLE (RAC, Performance, Security, etc, etc..) and LINUX. Well, it may not be “too complete” as I have envisioned but I’m working on it little by little
I hope some of the posts would be useful to the community as well..
When I’m not busy with technology.. I do Underwater Hockey and Mountaineering
My Certifications and Recognitions:
Red Hat Certified Engineer – RHEL5 (certificate #805010044156260), 12/2010
Oracle ACE – 1st in the Philippines (bit.ly/karlarao), 05/2010
Red Hat Certified System Administrator – RHEL5 (certificate #100-073-857), 8/2008
Red Hat Certified Technician – RHEL5 (certificate #605008645020295), 8/2008
Oracle10g Database Administrator Certified Professional, 09/2007
Oracle10g Database Administrator Certified Associate, 01/2007
My Current OPN Certificates:
Oracle Database 11g PreSales Champion
Oracle Enterprise Manager 10g Presales Champion
Trainings Attended:
Advanced Oracle Troubleshooting Seminar by Tanel Poder – Singapore
11i Install, Patch, and Maintain Oracle Applications
Looking Under the Hood at RAC by Murali Vallath – Makati, PH
Oracle Application Server 10gR2: Administration Workshop I
Governance, Risk & Compliance – Information Security & Privacy (Security Deep Dive Training) – Kuala Lumpur, Malaysia
Oracle Database 10g: SQL Tuning Workshop
DB2 for Oracle DBAs
Oracle Database 10g Administration Workshop II
Oracle Database 10g Administration Workshop I
Oracle 9i PL/SQL
Oracle 9i Introduction to SQL
Presentations:
- Mining the AWR (v2) - Rocky Mountain Oracle Users Group (RMOUG) training days 2012 http://goo.gl/7vAbp - Feb 14-16, 2012
- Mining the AWR - Virtathon http://goo.gl/5iowa - July 16-21, 2011
- Mining the AWR repository for Capacity Planning, Visualization, & other real world stuff (event) – Hotsos Symposium 2011, March 6-10, 2011
- Mining the AWR repository for Capacity Planning, Visualization, & other real world stuff(pdf)(event) – OOW 2010 – Unconference, 09/22/2010
- Graphing the AAS ala EM + doing some cool linear regression(pdf)(event) – Oracle Closed World 2010, 09/20/2010
- Virtualization?(pdf) – DEVCON Event@Asia Pacific College, 03/19/2010
- Characterizing the workload(blog post)(event) – Oracle Philippines DBA round table (Performance is the topic), 02/18/2010
- Performance Scenario – Sudden slow down on RAC(pdf)(event) – Oracle Philippines DBA round table (RAC is the topic), 07/21/2009
- Oracle Event, Scale Above the Limits of High Availability(event) – Customer Case Study for National Transmission Corporation, 09/25/2008
All of the slides can also be viewed at Slideshare
Articles:
- Written an article for NoCOUG journal titled – “why my database is slow?” – http://www.nocoug.org/Journal/NoCOUG_Journal_201105.pdf
- Oracle ACE spotlight for Oct 2011 newsletter issue http://www.oracle.com/technetwork/community/oracle-ace/ace-newsletter-oct2011-522155.pdf
Thanks for dropping by, happy reading! and would love to hear some comments..





Robert Lucente said
You made a comment on “Upgrade RHEL 4 to RHEL 5 on RAC system” and referred to
http://karlarao.files.wordpress.com/2009/04/single-instance-and-rac-kernel-upgrade.pdf
I can’t seem to find the above file
karlarao said
Hi Robert,
I’ve just updated the thread (http://forums.oracle.com/forums/thread.jspa?messageID=3383323�) to reflect the new link for the file. You can also check on Index Of My Posts for that paper. If you have any questions or clarifications just let me know. Happy Reading!
sundar said
Hi Karl Arao,
Nice to see your blogs. I would like know some basic details. Now we have a plan to upgrade our Linux 2.1 AS to RHEL 5. Is it possible and what is the best method. We plan to upgrade our Oracle 8i to 10g (for SAP). Simultaneously we want to upgrade Linux also. Please let me know your thoughts.
karlarao said
Interesting question.
First, you need to certify your machine if it’s possible to run the RHEL5. Regarding your upgrade from RHL2.1 to RHEL5, it is best practice to do a clean install of RHEL5 then restore your backed up config files on the new system. I’ve talked to an RHCA support engineer before and he recommended the same migration path.
Once the OS is okay, then you may now migrate your database to 10gR2. You can do an export/import (but check this with your SAP support because this is a packaged app, I know in Oracle Apps there’s a specific note for export/import), or you could check with Oracle Support if it’s possible to do a direct manual upgrade given your database files are coming from RHL2.1 to RHEL5.
I could give you some references, and send it on your mail.
Sundar, just keep this in mind. You need to certify everything (from Storage->HW->OS->DB->APPS)..
Hope this helps..
- Karl Arao
Sundar said
Dear Karl Arao,
Thank you for your reply. We purchased new IBM x3500 M2 with Dual Quad Core processor with 16 GB RAM and 6 x 300 GB HDD SAS. It will support RHEL5.It will support 64 bit but we planned to keep in 32 bit. Since we planned to keep the existing x235 Server as DR Server. It will support only 32 bit.
We planned to migrate as follows
From Linux 2.1 AS to RHEL 5
From Oracle 8i to Oracle 10g
From SAP 4.7 to SAP 4.7
From IBM X235 to IBM x3500 M2
One of my friend recommeded that we have to upgrade the Linux Kernal for this upgradation. Please recommand.
karlarao said
Hi Sundar,
Are you planning to configure both of the servers on Data Guard? The highest possible OS that you can put in x235 is RHEL4 AS 32bit. And in Data Guard you must have the same architecture on both primary and standby, so yes you’ll stick to 32bit (From Metalink 294223.1: The Data Guard product recommends that the configuration platforms use the same operating system version, but this is not a requirement. The important factor is the copy of the Oracle software you use and it’s bit level. You must use the same software media for both the standby and primary environment). If you’ll push through with these machines, you could install RHEL5 32bit on x3500 M2 and RHEL4AS 32bit on x235 but the effect would be:
- you’ll be on 32bit, and you have 16GB of RAM. You’ll not be able to fully utilize that big memory. Unless, you have to make workarounds, but still you’ll have limits.
- you’ll not be able to utilize the full power of your new server
See links below:
x235 – supported OS
http://www-03.ibm.com/servers/eserver/serverproven/compat/us/nos/redchatold.html
x3500 M2 – supported OS
http://www-03.ibm.com/servers/eserver/serverproven/compat/us/nos/redchat.html
And these other links:
x235 (8671) Compatibility
http://www-03.ibm.com/servers/eserver/serverproven/compat/us/xseries_old/x235.html
x3500 M2 (7839) Compatibility
http://www-03.ibm.com/servers/eserver/serverproven/compat/us/xseries/7839.html
sundar said
Dear Karlarao,
We have bought IBM X3500M2 server and try to install RHEL 4. but the system is not recognising the Server Raid. But if I try to install Linux 5 it is working properly.
Since the IBM Server does not contain floppy drive, i use USB Floppy to load the required server. But due to SDA of USb Floppy drive and Raid it does not recognise my hard disk. Please let me know your suggestions.
karlarao said
Yes RHEL5 32bit would be fine
You can just do a network install… Either through
- FTP
- HTTP
- NFS
Surachart Opun said
Dear Karl Arao,
Nice to meet you. Your blog’s very nice .
karlarao said
Thanks Surachart
Ali Bermudez said
Hello Karl,
I just like to congratulate you on your very promising career and for being so gracious in sharing your knowledge. It was such great privilege to have worked with you in the past. I know your success in your chosen field will be tremendous.
God bless you! You’re making your fellow Pinoys proud.
karlarao said
Hi Sir Ali,
Thanks for the kind words, I’ll be missing the kind of issues we had before on the RAC environment
God bless to you and your family
Mico Lademora said
Hey Karl
You did it… Congrats..And thanks for the tips. God Bless.
karlarao said
Thanks a lot Mico!!!
rpm said
Hi karl, where can i take a RHCE / RHCSA certification sa phil. thanks pre.
karlarao said
I took my RHCE exam at IT Group http://www.itgroup.com.ph , thanks for dropping by!
rpm said
Thank you very much karl, very helpful.
br
Ed said
Wow, Kabayan … super-loaded ang mga qualifications mo ah … very impressive, surprise you are still in the Philippines, on the other hand, I missed life and food
in the Philippines.
Keep up the good work … thanks for your scripts …
Would have been good if I can work as an online-DBA somewhere …
Have a nice day. I will sure be following your blogs and posts.
Ed said
Oops, just checked again .. you are in the US … my bad
- … that seems to be the best place to be for Oracle DBAs
karlarao said
Hi Ed,
Thanks, glad the scripts were useful.. I have no intention to go here though, I just pursued my passion and interest plus I met friends along the way.
Just continue to be curious kabayan! that’s the secret sauce
-Karl Arao
Jeff Jacob said
Hi Karl,
It was great meeting you at RMOUG lunch on Wednesday! I didn’t attend your session ’cause I’m not a DBA and it looked way over my head. Mainly I support the data warehouse (Cognos) at my company.
Anyway, I wish you the best with your career and life in general.
Jeff
karlarao said
Hi Jeff,
It was really nice meeting you. You are a very lucky man to win an ipad2
and have your name picked up from another sponsor for another ipad2! :p
I’ll see you again next RMOUG!
-Karl
Eric Yen said
I don’t know if you have seen this yet. But I thought you would be interested.
http://www.gmanetwork.com/news/story/249404/scitech/technology/10-000-students-to-benefit-from-oracle-dost-program