Oracle for SQL DBA

Question

Post reply

Oracle for SQL DBA

AJ-CH

SSC Rookie

Points: 30
More actions
May 3, 2010 at 5:00 am

#386838

Hi all
i am looking for some advise. I am a SQL DBA (10years exp.) looking to get into Oracle. I was wondering if anyone could suggest a best way of becoming an Oracle DBA. I found out that the oracle does workshops for the beginners, judging by the schedule some of it looks a bit basic.
Has anyone done this kind of transition successfully..
any input is appreciated.
cheers
Arick

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luzi62 Ten Centuries Points: 1218 More actions · Answer 1

Hi,

if you start new with oracle it's best to start from scratch.

As a Oracle DBA you have not only the RDBMS to master. You also have Linux, UNIX and WINDOWS to deal with. As SQL DBA you need at least also basic understanding in Linux and Unix. (Crontab, Filesystem, Batchjobs (KSH, SH), Editors like VI 🙂 etc. It Also depends what version of oracle you have to deal with. In Oracle 11 you have new features like ASM. So if you have no expirience with Oracle, the Beginner Course make sense. Because you have a lot more to deal with Storage and Memory parameters and so on.

I started with the Oracle DBA for Oracle 9i and a extra Course for RMAN, the Backup tool. had a lot of New features course since then.

For Prerequisites take a look at the Oracle Univerity.

http://www.oracle.com/education/chooser/selectcountry_new.html

regards

AJ-CH SSC Rookie Points: 30 More actions · Answer 2

Hey Luzi62,

thanks for the feedback. That was also my feeling. The SQL part is not too bad but the other other bits are bit more complicated.

cheers

A

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

About two years after starting working with Oracle is when you will start to realize how different are SQL Server and Oracle implementations of the same basic principles.

Question is, do you have access to Oracle? are there Oracle databases in you shop?

If the answer is Yes, ask your boss to allow you start working on Oracle related tasks.

If the answer is No, go to oracle.com and download Oracle software, install it at home and start learning.

Good news are...

... Oracle is free for training purposes.

... All Oracle documentation is free and public.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

PaulB-TheOneAndOnly (5/6/2010)
About two years after starting working with Oracle is when you will start to realize how different are SQL Server and Oracle implementations of the same basic principles.
Question is, do you have access to Oracle? are there Oracle databases in you shop?
If the answer is Yes, ask your boss to allow you start working on Oracle related tasks.
If the answer is No, go to oracle.com and download Oracle software, install it at home and start learning.
Good news are...
... Oracle is free for training purposes.
... All Oracle documentation is free and public.

Great tips.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events