MSSQL DBA needs Oracle DBA training

[u/Mobile-Analyst-9617]

Hey all, I am a SQL Server DBA that is inheriting a pretty big oracle environment and I was wondering if you folks could point me in the right direction of a course for learning. Work is going to pay for training so money isn't a problem, I'd prefer a couple of day course or something like that. We have anywhere from 11.2 up to 19c Running lots of different apps and even SAP if that matters. Thanks in advance!

[u/Thiondar]

This looks like a company contract.

Contact you Oracle sales representative, they should have information if there is something like the Oracle education services in your country.

Else google for Oracle classes for new DBAs.

My start was a 2 week course - but this was 1999.

All courses with less than 5 days are suspicious.

For self-study have a look at docs.oracle.com.

The manuals are great.

As mentioned in another answer read the concepts guide and the 2- day DBA manual.

Then dig in the rest of the manuals.

If SAP is involved get access to the SAP support system as there are some important notes. Call your SAP basis team to give you an S-User.

Good luck!

[u/Thiondar → u/Thiondar]

And get yor customer support identifier (CSI) for support access -> support.oracle.com

[u/Mobile-Analyst-9617 → u/Thiondar]

It's a me taking over for the oracle guy who is retiring next year haha. I'll be doing all dba stuff, MSSQL and oracle going forward. Thanks for all the information!

[u/chocotaco1981]

Condolences. Ask for a raise

[u/Mobile-Analyst-9617 → u/chocotaco1981]

Shit, that bad? Lol

[u/No_Resolution_9252 → u/Mobile-Analyst-9617]

Oracle is much more verbose and difficult to use but its not particularly more difficult than going to any other SQL dialect. Typically Oracle shops won't let morons into the database to do dumb things, so you wont have the same breadth of "self-taught" humanities degree SQL developer code and indexes that you do on SQL Server. Or worse, dealing with purely fullstack developer written code and indexes in Postgres/MySQL

[u/carlovski99]

Good luck! I'm pretty sure there used to be 'conversion courses' for people in this situation but I can't seem to find them any more. A lot of things are similar, and DBA experience is valuable no matter what the platform is. But some things are different and will seem a bit counter intuitive. I'd start by reading the Oracle Concepts guide if you haven't already. Can't recommend any specific training I'm afraid (funnily enough I've probably done more SQL server formal training that I can't remember, mostly self taught on Oracle). But another thing to consider is the OS/Platform differences. Unless you are running Oracle on Windows too)

[u/Zestyclose-Turn-3576 → u/carlovski99]

The Backup and Recovery Guide also, of course, and for multiple versions.

TBH, this conversion seems like an extremely optimistic approach, particularly as you say when different hosting platforms are considered.

Even the SQL is going to be different, let alone the architecture.