Any oracle DBAs here?

psd99 · 13 Oct 2015 at 11:52

Hey guys,

looking to move from a unix sysadmin role to oracle. Training be a great start

Have any of you got any tips or advice?

psd99 · 13 Oct 2015 at 13:16

Burnsy2023 said:
I do DBA work for Oracle (inc Exadata) and Postgres - as well as also a lot of other things.

A lot of what you need to know is quite theory based as most performance tuning is quite manual. Oracle training isn't cheap and it's not an easy skill base to break into. Would your work fund a training course?

Hello yes my work will possibly fund the training but I'm wondering what type of training I should begin with?

psd99 · 13 Oct 2015 at 13:23

Burnsy2023 said:
Have you don't any DBA work before on other RDBMS? Is this your first foray into DB admin?

well basic oracle admin commands, creating tns files, creating users etc
but I would consider myself with a very basic level of commands so I probably want entry level courses.

psd99 · 13 Oct 2015 at 13:44

Burnsy2023 said:
What versions are you running in house? Are you running any RAC?

Both RAC and stand-alone setups.

psd99 · 13 Oct 2015 at 13:56

I think mostly 11.2g

psd99 · 13 Oct 2015 at 14:27

thanks for that

psd99 · 13 Oct 2015 at 14:49

bet it is super tough.

I do find it interesting though.
that's a positive.

psd99 · 19 Apr 2016 at 08:35

Burnsy2023 said:
So you have two 11g courses:
Oracle Database 11g: Administration Workshop I Release 2
Oracle Database 11g: Administration Workshop II Release 2

Both are needed although you may wish to still do the 12c equivalents instead.

I would then suggest doing the Oracle Database 11g: RAC Administration Release 2 course as well.

so I managed to get my employers put me on to the
Oracle Database 11g: Administration Workshop II Release 2 course soon!
Thanks for the suggestion.

super excited, as I am fed up of my current role.

This course is going to be tough and challenge me for sure but I hope to learn lots and attempt this exam!!! I don't think I ever had this much passion for an exam since my Uni days

psd99 · 19 Apr 2016 at 09:46

Burnsy2023 said:
Have you done the first workshop?

oh it was a typo!!

this is the course I'm doing:

Oracle Database 11g: Administration Workshop I Release 2

so it's actually workshop 1

phewwww

psd99 · 19 Apr 2016 at 09:50

yep it is a very lucrative industry. Just to install oracle itself is very costly in some companies and the costs behind supporting the product are immense.

psd99 · 19 Apr 2016 at 12:52

glen8 said:
Burnsy you may be able to answer me a question if you don't mind

Currently have a windows server running a local oracle db. I want to replace the server with a newer model with a drive attached to a san containing the db. The san has a replication partner to a sister site. I want to know if it's possible to build an identical server at the sister site, and use windows disk clustering set to manual failover. Then, if the primary site or server fails, I can simply fail over to the remote server

Thanks

one question I got it windows and oracle WHY!? that is like mixing water with oil

unix > windows

psd99 · 3 May 2016 at 09:58

so I did the course it was like 1000 pages +

wow it was very difficult but also exciting. I'm going to become best friends with my oracle friends at work and learn from them.

I got virtual box on my laptop, looking to get some type of oracle database setup
any tips?

psd99 · 3 May 2016 at 11:01

Burnsy2023 said:
I would suggest not trying to run Oracle in Windows, just incase that was your plan.

lol never

I am planning to use oracle linux vm image - I think this can be downloaded from the oracle site itself.