Home » Other » Training & Certification » New to ORACLE
New to ORACLE [message #606619] Mon, 27 January 2014 08:47 Go to next message
socajssr
Messages: 2
Registered: January 2014
Location: London
Junior Member
OK I am crossing over to the darkside and want to learn to Administer Oracle.
I have been a MSSQL DBA for just over 7 years and want to be able to administer both.

So here I am, where do I begin. This is from scratch I have no ORACLE software as such or experience.

Where do I start, Books, WEBCASTS, Youtube, VM etc. I'm bookin a course but don't want to be the class dunce.
Some swotting before I get there would be best.

Pointers please.

Thanks.

Jack.
Re: New to ORACLE [message #606620 is a reply to message #606619] Mon, 27 January 2014 08:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/pls/db112/homepage

Bookmark URL above & start Reading The Fine Manuals & start with URL below

http://docs.oracle.com/cd/E11882_01/server.112/e40540/toc.htm

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: New to ORACLE [message #606621 is a reply to message #606619] Mon, 27 January 2014 08:54 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
socajssr wrote on Mon, 27 January 2014 09:47
OK I am crossing over to the darkside and want to learn to Administer Oracle.


You have that backwards. You are crossing over FROM the darkside.

For 11g, you can start here: http://www.oracle.com/pls/db112/homepage

or go to http://tahiti.oracle.com and pick your version or Oracle.

Of course, you would need to install Oracle to be able to play with it. Learning by books is not going to help at all unless you can implement what you learn.

Register for a free account at http://download.oracle.com
Re: New to ORACLE [message #606629 is a reply to message #606621] Mon, 27 January 2014 10:50 Go to previous messageGo to next message
socajssr
Messages: 2
Registered: January 2014
Location: London
Junior Member
Thanks.

Great starting points. From what I can see there are lots of similarities with MSSQL.

Re: New to ORACLE [message #606631 is a reply to message #606629] Mon, 27 January 2014 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
To a large degree, SQL is SQL regardless in which RDBMS it runs.
Re: New to ORACLE [message #606632 is a reply to message #606629] Mon, 27 January 2014 11:22 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
socajssr wrote on Mon, 27 January 2014 16:50
Thanks.

Great starting points. From what I can see there are lots of similarities with MSSQL.

You need to careful about assuming that Oracle works the same as SQL Server (and even more careful about saying that they are similar - at least, when you are surrounded by Oracle DBAs Smile ). Some common confusions are:

What SQL Server calls a database, we call a tablespace (more-or-less)
A SQL Server instance is an Oracle Home (I think)
A SQL Server cluster is an IOT (sort of); an Oracle cluster is something very different.
Do NOT create temporary tables; use subqueries instead.
You no longer need to worry about read consistency - Oracle is ALWAYS read consistent.
Do not worry about locking - leave it to Oracle, and it will be minimal.
In particular, in Oracle readers and writers do not block each other.
Oracle has separate structures for redo and undo, not just one transaction log (not since release 5).

I think those are the points that I have had most confusion with when working with ex-SQL Server folks. If you ever feeling like writing an article contrasting the two, please post it here on the blog.


Re: New to ORACLE [message #606637 is a reply to message #606632] Mon, 27 January 2014 12:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What SQL Server calls a database, we call a tablespace (more-or-less)
What SQL Server calls a database, Oracle calls a schema
Re: New to ORACLE [message #606640 is a reply to message #606619] Mon, 27 January 2014 13:20 Go to previous message
matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member

There are a number of videos available on YouTube (the quality of which varies considerably, of course).
I've collected links to a number of them as they relate to Oracle admin certification exams:

http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-052
http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-051
Previous Topic: OBIEE Online Training - Register for FREE Workshop
Next Topic: Oracle BPEL 11g Training in Mumbai
Goto Forum:
  


Current Time: Thu Mar 28 14:14:52 CDT 2024