Karl Arao's Blog

Just another weblog about Oracle,Linux,Troubleshooting,Performance,etc..etc..

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!)..

Karl Arao

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: 

Thanks for dropping by, happy reading! and would love to hear some comments.. :)

23 Responses to “About”

  1. 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

  2. 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

  3. 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.

  4. 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.

  5. Dear Karl Arao,

    Nice to meet you. Your blog’s very nice .

  6. 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 :)

  7. Mico Lademora said

    Hey Karl

    You did it… Congrats..And thanks for the tips. God Bless.

  8. rpm said

    Hi karl, where can i take a RHCE / RHCSA certification sa phil. thanks pre.

  9. 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.

  10. 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

  11. 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

  12. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 27 other followers