Oracle 11g For Dummies [Paperback]

Chris Zeis (Author), Chris Ruel (Author), Michael Wessler (Author)

Book Description

ISBN-10: 0470277653 | ISBN-13: 978-0470277652 | Publication Date: January 14, 2009 | Edition: 1

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle.

This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers:

• The building blocks behind the database engine as well as Oracle’s physical and logical structures
• Hardware, software, system, and storage requirements for implementation
• How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
• Daily and intermittent tasks necessary to keep your database running properly
• How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures
• When to use online, offline, controlfile, and archivelog backups
• Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities
• Different ways to manage your database
• How to automate jobs with the Oracle Scheduler
• Using SQL in Oracle, and a great deal more

Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Editorial Reviews

From the Back Cover

Grow wise about Oracle and get going with the leading database software!

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? Either way, this book will guide you through the mysteries of Oracle and database administration. Here are the nuts and bolts of creating an Oracle database, implementing it, and keeping it running in tiptop form.

• Build it — learn the building blocks behind the database engine and understand Oracle's physical and logical structures

• Prepare for takeoff — review the hardware, software, system, and storage requirements for implementation

• Know your environment — recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX

• Defend it — assess potential threats to your database, configure Oracle Recovery Manager, and create backup and recovery procedures

• Maintain it — know the daily and intermittent tasks necessary to keep your database running properly

• Head off trouble — implement the system troubleshooting methodology, use Oracle database logs, and explore other diagnostic utilities

• Manage it — monitor with Oracle Enterprise Manager

Open the book and find:

• Two ways to manage your database

• What tablespaces are and how to use them

• How to automate jobs with the Oracle Scheduler

• Ten common installation tips

• How to use SQL in Oracle

• When to use online, offline, control file, and archive log backups

• Database encryption options

• Advantages of the Flashback database

About the Author

Chris Zeis is Chief Technology Officer and partner at Perpetual Technologies, Inc., an Oracle partner. Chris Ruel is an Oracle database administrator and consultant. Michael Wessler manages multiple Web applications for the Department of Defense and consults at various government and private agencies.

Product Details

• Paperback: 408 pages
• Publisher: For Dummies; 1 edition (January 14, 2009)
• Language: English
• ISBN-10: 0470277653
• ISBN-13: 978-0470277652
• Product Dimensions: 9.1 x 7.3 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #237,982 in Books (See Top 100 in Books)
  • #40 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars It's great!!, August 21, 2011

By 

RJAY11 - See all my reviews

Amazon Verified Purchase

This review is from: Oracle 11g For Dummies (Paperback)

It's good. Easy to read and understand. Provides good step by step instructions. Great for those who are doing independent studies.

4.0 out of 5 stars Another good book in the Dummies series, February 25, 2011

By 

Gerard W. White - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Oracle 11g For Dummies (Paperback)

I like the Dummies series because of the good technical information contained in them and their cool sense of humor.
Most database books are good for curing insomnia, but this is actually interesting. Nice job!