Oracle DBA Checklists Pocket Reference [Paperback]

Quest Software (Author)

Book Description

Publication Date: April 15, 2001

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material.

The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities:

• Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and active and inactive redo logs).
• Installation and configuration. Contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. Also includes special steps for configuring a parallel database.
• Network management. Helps with installing, configuring, and testing Net8 software on server and client machines. Tasks include confirming network availability and Net8 connectivity, verifying Net8 name resolution, configuring Net8 clients (with LDAP or Oracle Names), configuring Net8 on the server, configuring the Multi-Threaded Server (MTS), tracing client connections, and tracing the Net8 listener.

This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need--and find it fast.

Editorial Reviews

About the Author

This pocket reference distills Oracle DBA information from one of the knowledge bases developed by RevealNet, the industry leader in knowledge-based solutions and development tools for Oracle and DB2. The goal of these knowledge bases is to fully anticipate the daily challenges of database professionals. RevealNet's code-formatting technology has become the industry standard for Oracle source code formatting. RevealNet's products help database professionals rapidly apply solutions that save hundreds of programming and research hours every year.

Product Details

• Paperback: 80 pages
• Publisher: O'Reilly Media; 1st edition (April 15, 2001)
• Language: English
• ISBN-10: 0596001223
• ISBN-13: 978-0596001223
• Product Dimensions: 7 x 4.2 x 0.3 inches
• Shipping Weight: 2.9 ounces (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #935,952 in Books (See Top 100 in Books)
  • #64 in Books > 4-for-3 Books > Computers & Internet > Programming

Customer Reviews

Most Helpful Customer Reviews

15 of 16 people found the following review helpful:

5.0 out of 5 stars Great tool - not *just* for DBAs, June 30, 2001

By 

Linda Zarate "IT Ops Consultant" (Azusa, CA United States) - See all my reviews

This review is from: Oracle DBA Checklists Pocket Reference (Paperback)

The checklists in this 80-page guide are both comprehensive and complete. While this book's obvious value is to DBAs (which I'm not), it is also an invaluable tool for a number of other IS/IT areas. Specifically:

* Change control analysts who need to develop or validate implementation and rollback plans

* Project and release managers who want to scope out and plan the key tasks for upgrades and implementations

* Desktop support folks who install and configure client software

* Help desk analysts who are tasked with developing problem screening and identification checklists.

For the last group the checklists for confirming network connectivity via Net8 can make the difference between misassigning an Oracle Net8 problem to the network group, which only slows the resolution process. You do not have to be a DBA to benefit from this excellent book.

11 of 11 people found the following review helpful:

4.0 out of 5 stars For DBAs knowing what they are going to do, August 4, 2002

By 

VeeKoo (Sunnyvale, CA United States) - See all my reviews

This review is from: Oracle DBA Checklists Pocket Reference (Paperback)

This is, as the title suggests, a pocket size collection of checklists about how common operations are done. This is a good reference but not a book for you if you are still learning how to use Oracle.
DBA Checklists is an excellent reference, when you are performing one of covered operations:
- In a hurry
- Middle of night (and in a hurry)
- First time after few months last time you did it
- Making sure a junior DBA does things properly

Summary: this reference you want to keep in a bookshelf close to you workstation.

11 of 11 people found the following review helpful:

5.0 out of 5 stars Simple, lightweight, Precise Guidelines, June 6, 2001

By 

Anthony Lai Cheuk Tung "Anthony LAI, CISSP, C... (Hong Kong SAR) - See all my reviews

This review is from: Oracle DBA Checklists Pocket Reference (Paperback)

it covers many areas like preparing a database for production, conducting recovery, installation and network management. It gives a precise guidelines to take a concept how to start some administrative job and investigation. Of course, it covers some brief steps and ideas, it is enough for me and I can get more details from those Oracle press "Bible" ^_^...Quite Thick and heavy.

Simple DBA task list is good to people taking an initial concepts on administering Oracle. If there is a PDA book for it, it is much more convenient!!