1 / 23

Oracle for SQL Server DBAs

A comprehensive session for SQL Server DBAs to understand Oracle database fundamentals, installation, physical storage, backup and recovery with demos.

jjason
Download Presentation

Oracle for SQL Server DBAs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle for SQL Server DBAs Gavin Payne

  2. Agenda • Inside the database • Programmability • Tools • Next Steps Q&A • Why Oracle? • Installation • Physical Storage • Backup and Recovery 20 slides in 50 minutes

  3. About Me Gavin Payne Solution Architect 3.5 years SQL Server DBA 10 yearsinc Oracle DBA 2 years SQL Bits 7 SQL Server User Group SQL Social Blog http://blog.gavinpayneuk.com Twitter @GavinPayneUK

  4. Introduction • Today I am not going to:tell you Oracle is better than SQL Servertell you SQL Server is better than Oracle • This is a Level 100 session for newcomers to Oracle:Oracle is a massive product, even the basicsSet your expectations appropriately!

  5. Why Oracle? • Very successful product • Lion’s share of the market (think Unix not just Wintel) • Massive legacy install base and still being deployed • Some things only work or are stored with Oracle • One day you will bump into one of those things

  6. Platforms • Oracle runs on many platforms: HP-UX PA-RISC AIX PowerPC Solaris Sparc Linux x86/x64/Itanium Windows x86/x64/Itanium • Traditionally a very Unix/Linux focussed product • But today Windows is just as common, if not more

  7. Installation Tools • Download from oracle.com – free dev downloads • Oracle Universal Installer – product setup wizard • DBCA – database (instance) setup wizard

  8. Installation Tips • You can use a virtual machine – I’m using Windows 2008 R2 on Hyper-V • More resource hungry than SQL Server – memory, IO, CPU, in that order • Just accepting the defaults is fine

  9. Oracle Enterprise Manager • Browser based administration tool • Focuses on platform and schema control rather than data • Primarily of DBA, not developer, interest • Compared to SSMS it’s pretty shocking • Portability over functionality • Not all functionality is free! • Demo

  10. Oracle Database Components Database writer Log writer Checkpoint Sys Mon Process Mon Archiver Job Queue

  11. Oracle’s Physical Files

  12. Oracle’s Logical Hierarchy

  13. Oracle Recovery Mechanism

  14. Backup and Recovery • Archivelog mode Equivalent to Full recovery mode Writes and then empties the changes in an inactive redo log to an operating system disk file transaction log backup Key to performing point in time recoveries And online backups!

  15. RMAN • Oracle’s Recovery Manager • Command line backup and cataloguing manager • Equivalent of T-SQL Backup and Restore • Production DBA’s best friend • Highly comprehensive scripting language • DEMO

  16. High Availability

  17. Inside The Database Database Object Types Program Object Types • TablesRelational Object XML • Indexes • Views • Synonyms • Sequences • Packages • Package Bodies • Procedures • Functions • Triggers • Java Classes • Java Sources

  18. Programmability • Oracle supports 3 languagesSQL PL/SQL Java • PL/SQL is similar to C, although based on Ada • Similar feature set to T-SQL 2005 onwards • But not as friendly?

  19. Programmability Key PL/SQL Differences with T-SQL descobject_name; Select sysdatefrom dual; Select seq_name.nextval from dual; Procedures cannot return data!

  20. Tools Oracle Tools 3rd Party Tools • Enterprise Manager • SQL*Plus • JDeveloper • Quest Toad • Red Gate • DEMO

  21. Next Steps • Download and install, get to the Enterprise Mgr page • Decide what you want to learn more about next? • What we didn’t cover:Networking and Listeners Security Memory management Dynamic and Flash storage PL/SQL

  22. Reading Material • Oracle 2-day DBA Guide(download) • Oracle – A Beginner’s Guide(Oracle Press) • Oracle for SQL Server DBAs(Oracle Press) Nov 2010

  23. Q & A

More Related