Inside a recent forum discussion I authored lower a tough outline from the approach I believe people must take to become competent DBA. This short article represents my ideas with that matter. Remember, this really is only a viewpoint.
- Step One : Pick Your Beginning Operating-system Wisely
- Step Two : Consider Oracle Certification (OCP)
- Step Three : Understand Virtualization
- Step Four : Broaden Your Operating-system Understanding
- Step Five : Oracle on Linux
- Step Six : Automatic Storage Manager (ASM)
- Step 7 : Real Application Clusters (RAC)
- Conclusion
Step One : Pick Your Beginning Operating-system Wisely
When you're a new comer to Oracle, you need to minimize the amount of unknowns you throw in to the mix. As a result, you need to most likely start the training process around the operating-system you're most acquainted with. If you're most joyful on Home windows, then go ahead and try the Home windows downloads of Oracle Database. It's a great way to enter into the merchandise, without getting to begin learning any new OS technology.
Most Oracle systems I've labored with happen to be placed on some type of UNIX or Linux, so you'll certainly have to understand individuals sooner or later, until then, stick to that which you know.
Step Two : Consider Oracle Certification (OCP)
I believe the Oracle Certified Professional (OCP) certification is a nice good beginning point for just about any ambitious DBA. It isn't perfect and having the certification does not cause you to an excellent DBA, however if you simply approach it correctly it'll have taken the very first steps along your path. Read much more about the OCP within the following articles.
- Oracle Certification : Faq's (OCA, OCP, OCE, OCM)
- Oracle Database OCA & OCP Certification
Step Three : Understand Virtualization
Like a DBA you'll be focusing on a number of os's. A great way to get an understanding of new os's would be to try playing about with Oracle VirtualBox. It will help you to run multiple virtual machines with various os's on your computer, providing you with an chance to obtain more acquainted with these questions safe atmosphere. This may also be a walking stone to doing more difficult stuff later. There's a fundamental illustration of developing a VM using VirtualBox here.
I have written numerous fundamental installation guides for Linux, which you'll find here.
I recommend you play about with creating a couple of VMs, installing Home windows and a number of Linux distros, including Oracle Linux versions, Ubuntu, maybe Fedora too. It isn't important to enter an excessive amount of depth with these Linux distributions initially. This really is much more about reducing your teeth on VirtualBox. Doing a number of things can help you understand virtualization generally and also the product itself. You could also take advantage of studying a fundamental summary of virtualization, like my article here.
Step Four : Broaden Your Operating-system Understanding
Following on in the previous step, when you are feeling confident with the fundamentals to be an Oracle DBA and virtualization, you need to most likely begin to broaden your understanding of os's. This is also true in case your primary learning platform was Home windows. The majority of the work you need to do being an Oracle DBA is going to be on UNIX and Linux systems, so you will need to be comfy on individuals.
The simplest way into that is by using Oracle Linux, that is free and supported. I have already associated with development of a VM and installation articles for a number of Linux distributions, including Oracle Linux, but you will need to know a little more about Linux itself if you're seriously interested in as being a DBA onto it. Read a lot of stuff about this here.
The greater your grounding in Linux, the simpler you'll find more complicated tasks, like RAC installations, later on.
Step Five : Oracle on Linux
When you feel good with VirtualBox and installing of Linux on VMs, you can look at carrying out a simple Oracle installation on the Linux VM. Something similar to individuals described here. Personally, I'd stick to Oracle around the fundamental file system initially, staying away from more complicated features like ASM before you tend to be more confident.
Play about with this particular stuff. Break it and then try to repair it. Do backup and recovery. Do multiple installations. Try upgrades from the database and OS etc. Attempt to mimic normal DBA tasks. Don't merely assume one effective installation means you are prepared to move ahead.
Step Six : Automatic Storage Manager (ASM)
When you're feeling at ease with that fundamental stuff, you can look at searching at installations using Automatic Storage Manager (ASM). Using ASM means you'll need some facets of the Grid Infrastructure technology, that is your walking stone to Real Application Cluster (RAC) installations. Should you spend some time to understand ASM and Grid Infrastructure technologies like Oracle restart, the progression to RAC is going to be much simpler.
Step 7 : Real Application Clusters (RAC)
When all of the previous foot work continues to be done and you'll need a bigger challenge you can look at an online RAC installation. There are several types of these on this web site here.
Oracle RAC requires some understanding in many areas, including os's as well as networking. Without individuals you'll make lots of mistakes and discover the procedure incredibly infuriating. For those who have taken your time and effort to understand all of the prerequisites, it'll seem like an all natural progression.
Conclusion
So now you must the selection:
- Come methodically with the technology stack. Browse the manuals along the way and test stuff. Develop a good foundation that may help you progress, have ideas of your and be a great DBA.
- Race through attempting to install RAC as rapidly as you possibly can. Write plenty of posts forums complaining how stuff does not work, how difficult Oracle is and just how rubbish people's content is simply because they did not hands-hold you thru doing something you most likely should not happen to be attempting to begin with. In the finish of this you'll have little real understanding and can most likely not manage to doing anything significant like a DBA inside a work atmosphere.
It's your choice. Choose wisely. :)
No comments:
Post a Comment