Oracle for SQL Server DBAs. Gavin Payne. Agenda. Inside the database Programmability Tools Next Steps Q&A. Why Oracle? Installation Physical Storage Backup and Recovery 20 slides in 50 minutes. About Me. Gavin Payne Solution Architect 3.5 years
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Oracle for SQL Server DBAs Gavin Payne
Agenda • Inside the database • Programmability • Tools • Next Steps Q&A • Why Oracle? • Installation • Physical Storage • Backup and Recovery 20 slides in 50 minutes
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
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!
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
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
Installation Tools • Download from oracle.com – free dev downloads • Oracle Universal Installer – product setup wizard • DBCA – database (instance) setup wizard
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
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
Oracle Database Components Database writer Log writer Checkpoint Sys Mon Process Mon Archiver Job Queue
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!
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
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
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?
Programmability Key PL/SQL Differences with T-SQL descobject_name; Select sysdatefrom dual; Select seq_name.nextval from dual; Procedures cannot return data!
Tools Oracle Tools 3rd Party Tools • Enterprise Manager • SQL*Plus • JDeveloper • Quest Toad • Red Gate • DEMO
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
Reading Material • Oracle 2-day DBA Guide(download) • Oracle – A Beginner’s Guide(Oracle Press) • Oracle for SQL Server DBAs(Oracle Press) Nov 2010