My Profile

March 12th, 2010 Leave a comment Go to comments

My Profile

certs

Working experience

  • 7 years working experience with Oracle Databases, UNIX operating systems and EMC (prior Legato) Networker
  • Certified Oracle Trainer

Working experience on Oracle databases

  • starting with version 8i up to and including 11g Release 2
  • High Availability Solutions (RAC, Data Guard, ASM)
  • Backup and Cloning (RMAN, custom Scripts, Storage-based Cloning)
  • Database Upgrades
  • Tuning
  • Troubleshooting
  • skills handling large databases (> 10 TB)
  • installing and configuring Oracle Grid Control
  • Oracle Certified Trainer; courses held so far:
    • Oracle 11g Release 2 Admin I Workshop
    • Oracle OCE: Managing Oracle on Linux

Working experience with UNIX operating systems

  • several operating systems: Linux (RedHat, SuSE, Debian, Ubuntu), Solaris (SPARC / x86), HP-UX,  AIX
  • Install
  • Configure
  • Optimize

Working experience with EMC Networker

  • Install
  • Update
  • Troubleshoot
  1. October 27th, 2009 at 08:51 | #1

    Hi ronny,
    I was wondering if you can advise me of buying a hardware for me to install oracle Application with 10gRAC on OEL 5.3 with oracle vmware.
    is this system need to be bare bone or if there is window OS installed that can be wipedout and Linux can be installed?
    I have implemented oracle apps and middleware on several unix system which was already configured by OS sysAdmin but never have done by myself on any bare bone Pc or server !!

  2. Ronny Egner
    October 27th, 2009 at 09:05 | #2

    Hi Nikhil,
    at least i will try.
    I understand from your question that you want to build a 10g RAC with OEL 5.3 as operating system with some kind of virtualization (either VMWARE or Oracle VM).

    So let me starting with some remarks:
    - RAC mean at least TWO nodes (or systems); if you use virtualization you might get away with one system but that should be used for educational purposes only
    - VMWARE (ESX or ESXi) is an operating system on it´s own. It is installed on the server (plus some management interface) just like an operating system. With the
    VMWARE Management Console you create your virtual machines, start them and install the operating system there.
    - Oracle VM is also installed like an operating system. If you installed OEL or Red Hat before you will notice the installer is the same and asking the same questions.
    After installation you need to create VMs and install an operating system there.
    - Note that RAC in virtualized environments is only supported on Oracle VM!

    The Hardware needed for running a RAC is low: at least 2 Cores (one for each node) and at least 4 GB memory (2 GB for each node).
    The 2 GB memory for each node are required for the operating system itself (1 GB) plus the clusterware components (1 GB). If you
    need a database instance (of course you do) just add the amount of memory you need to each node. For the oracle application
    component you also need some memory.

    So my basic recommendation for starting would be: a Quad-Core-CPU with 16 GB memory for a two-node rac cluster.
    Required space per node is approx 100 GB plus database size.

    Ronny

  3. Frank
    March 17th, 2010 at 16:52 | #3

    Your comment is awaiting moderation.

    Hello

    We recently suffered from a ASM diskgroup failiure on out standby DB(Solaris 10(x86)). The problem was corrupt ASM metadata. The wierd thing was the (standby) DG was only offlined after a delete statement was issued at our production site ( which was DataGuarded) to a standby site) which (according to oracle) accessed these corrupt ASM metadata block which offlined the (standby) DiskGroup.

    My question to you is When trying to startup the ASM instance, how does it know it has corrupt ASM metadta, does it check them all on startup.

    If not, is it still possible to start the ASM Instance, even with corrupt ASM Metadata( not an official way of course, Im looking for a hack!!!!!)

    Many thanks

    Frank

  4. Ronny Egner
    March 17th, 2010 at 16:56 | #4

    Yes, ASM checks disk headers on startup. I guess something corrupted the disk header. So you are unable to mount the diskgroup. You can query the disk header with kfed utility (check here: http://blog.ronnyegner-consulting.de/2009/09/21/building-the-kfed-utility/).

  1. No trackbacks yet.