Oracle DBA Automation Quick Reference

Overview

  • Fast, easy automation for every Oracle 9i and 10g DBA!
  • Quick access to real-world examples
  • Installation, database creation, management, monitoring, tuning, and backup/recovery
  • Oracle Universal Installer (OUI), Oracle Net Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)

The fast, practical Oracle 9i/10g ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (12) from $2.88   
  • New (5) from $22.61   
  • Used (7) from $2.88   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$22.61
Seller since 2008

Feedback rating:

(17455)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$22.62
Seller since 2007

Feedback rating:

(23296)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$40.00
Seller since 2010

Feedback rating:

(7)

Condition: New
4-16-04 other 1 BRAND NEW! ONLY Expedited orders are shipped with tracking number! *WE DO NOT SHIP TO PO BOX* Please allow up to 14 days delivery for order with standard ... shipping. SHIPPED FROM MULTIPLE LOCATIONS. Read more Show Less

Ships from: San Jose, CA

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$44.44
Seller since 2013

Feedback rating:

(2)

Condition: New
New

Ships from: San Diego, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$70.00
Seller since 2014

Feedback rating:

(146)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

  • Fast, easy automation for every Oracle 9i and 10g DBA!
  • Quick access to real-world examples
  • Installation, database creation, management, monitoring, tuning, and backup/recovery
  • Oracle Universal Installer (OUI), Oracle Net Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)

The fast, practical Oracle 9i/10g automation reference for every DBA!

Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use. Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now!

  • Master scripting for both Oracle 9i and Oracle 10g!
  • Use Oracle Universal Installer to create response files for automating any installation
  • Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation
  • Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts
  • Manage files and tablespaces, tune memory, perform backup/recovery, schedule automated administration tasks, and more
  • Extend and customize any script to your own needs
  • Includes concise reference to Perl DBI and its Oracle-specific components—with real-world examples and syntax
Read More Show Less

Product Details

Meet the Author

CHARLIE RUSSEL has extensive system administration and Oracle DBA experience, specializing in combined Windows and UNIX environments. He is co-author of more than 20 books for IT professionals, including Microsoft Windows Server 2003 Administrator's Companion (Microsoft Press) and UNIX and Linux Answers! Certified Tech Support (IDG).

ROBERT CORDINGLEY is an Oracle DBA in Austin,Texas. Russel and Cordingley have co-authored Oracle DBA Scripting Quick Reference and Oracle DBA SQL Quick Reference (Prentice Hall PTR).

Read More Show Less

Read an Excerpt

Introduction

The Oracle database is a complex and ever-changing product that has grown increasingly complex and powerful over the years. In the bad old days, the working Oracle database administrator (DBA) had a limited set of tools to automate the day-to-day tasks of maintaining the health and integrity of Oracle databases. Thankfully, that has changed over time, and now with Oracle 9i, and especially Oracle 10g, nearly everything associated with the database can be automated. Unfortunately, Oracle has provided little documentation on exactly how best to accomplish this. We hope this book will help you on your road to discovering the many ways that Oracle can be automated.

Why Automate?

Very few DBAs are allowed the luxury of managing a single database, or even two, or three. In these days of increasing workloads, many of us are managing 20, 30, or more databases, and they're frequently scattered all over the world. With the number of databases in use on the rise, it's important to streamline every step of the process as much as possible. Automation improves your productivity in two very important ways: It reduces the time you need to spend waiting for the database to do something, and it improves the overall quality and repeatability of what you do.

Improved Productivity

The first advantage to automation is improving the overall productivity of the Oracle DBA. When the DBA performs a task manually, there is, inevitably, a substantial amount of time spent waiting for the database to do its thing. There's also a good deal of time usually spent by the database waiting on you to tell it what to do next. In both cases, time is wasted and the overall productivity of the DBA is seriously affected. Besides, let's face it, the stuff you can automate is usually the boring stuff you don't really want to be doing anyway! So let Oracle do the work for you.

Improved Quality

The hidden benefit to automation is a significant improvement in the quality of the DBA's work. An automated task is a predictable and repeatable task. When you do a task manually, especially one you do repeatedly, you will eventually make mistakes. Sometimes they're small mistakes, sometimes big ones. But if you automate the task, it will always be performed the same way, time after time after time.

Use What's Already There

Right from the very beginning, with the initial software installation, Oracle allows you to reduce or eliminate the need for a DBA to watch and wait. Once Oracle has been installed, you can configure the network and create one or more databases automatically, with no human intervention.

After the software is installed and the database created, the DBA finally reaches the real meat of the job. For the experienced DBA, there's a very real tendency to keep using the tools he or she has always used, even if the tools were originally created for use with Oracle 7. The fledgling DBA can run into similar problems, since it's difficult to discover all the different automation opportunities included with Oracle while simultaneously dealing with demands from users, developers, and management.

In spite of these challenges, or even because of them, it's vitally important to automate as much as is possible. It's equally important to avoid recreating a capability that's already available. The two most recent versions of Oracle have added an almost unbelievable wealth of options for the overworked DBA to automate his or her way to a quieter pager.

Test Everything First

With the multitude of new capabilities in recent versions, there's a temptation to implement everything that the documentation says will help improve operations or performance. Resist the temptation—at least long enough to allow time for testing of each and every new feature prior to implementation. Some of the new features will help in all situations, some will help in all but a few situations, and a few might create problems in certain circumstances. Testing prior to implementation is essential.

What's in this Book?

Chapter 1 will introduce the Oracle Universal Installer (OUI), and explain the use and creation of response files, which are files that provide your responses to the installer. Response files allow a highly automated installation session to proceed with little or no user intervention. You can even use these files as templates for manual installs, when you need to deviate slightly from the response file's intended course.

In Chapter 2, Oracle Network Configuration Assistant (NetCA) will receive similar treatment. While not as automation-friendly as the OUI, NetCA does have a reasonable amount of flexibility, using response files similar to those used by OUI.

Chapter 3 is all about the Oracle Database Configuration Assistant (DBCA). The DBCA is one of the most versatile parts of a DBA's toolkit, and extremely easy to automate. You can use DBCA-specific response files, but the real strength of the tool lies in its unique use of template files. The DBCA can create databases, clone them, and even "reverse-engineer" an existing database into a template, or even a set of scripts.

Finally, Chapter 4 can be regarded as a "survey course" of Oracle features that can be used to automate some of the tasks that consume a DBA's time day in and day out.

Talk to Us

We have made every attempt in this short volume to provide as complete a reference as we could, always with the goal of keeping it brief and easy to find the information you need. Our goal was to give the working Oracle DBA a tool to make him or her more productive, and we sincerely hope you find it useful. Every effort has been made to be both complete and accurate. If you do find an error or omission, or have a comment on the book, we very much want to hear from you. Please write us at: OracleAutomation@scribes.com. We don't promise to answer every question or comment, but we do read them and very much appreciate them.

Read More Show Less

Table of Contents

Introduction.

Why Automate? Improved Productivity. Improved Quality. Use What's Already There. Test Everything First. What's in this Book? Talk to Us. Acknowledgements.

1. Oracle Universal Installer.

Automated Installation. Reference. Sample Files.

2. Network Configuration.

Automated Network Configuration. Command Line Parameters. Oracle's Sample Response Files. Response File Syntax. Example NetCA Response File.

3. Database Creation.

Using the DBCA. Automating Database Creation without the DBCA. Automating Database Deletion without the DBCA. Reference. Sample DBCA Response File. Sample Database Template. Basic Initialization (init.ora) Parameters. oradim Command Line Parameters.

4. Day-to-Day Administration.

Use What's Already There. Test Everything First. File and Tablespace Management. Automatic Memory Tuning. Scheduling. Scheduling Reference.

Index.

Read More Show Less

Preface

Introduction

The Oracle database is a complex and ever-changing product that has grown increasingly complex and powerful over the years. In the bad old days, the working Oracle database administrator (DBA) had a limited set of tools to automate the day-to-day tasks of maintaining the health and integrity of Oracle databases. Thankfully, that has changed over time, and now with Oracle 9i, and especially Oracle 10g, nearly everything associated with the database can be automated. Unfortunately, Oracle has provided little documentation on exactly how best to accomplish this. We hope this book will help you on your road to discovering the many ways that Oracle can be automated.

Why Automate?

Very few DBAs are allowed the luxury of managing a single database, or even two, or three. In these days of increasing workloads, many of us are managing 20, 30, or more databases, and they're frequently scattered all over the world. With the number of databases in use on the rise, it's important to streamline every step of the process as much as possible. Automation improves your productivity in two very important ways: It reduces the time you need to spend waiting for the database to do something, and it improves the overall quality and repeatability of what you do.

Improved Productivity

The first advantage to automation is improving the overall productivity of the Oracle DBA. When the DBA performs a task manually, there is, inevitably, a substantial amount of time spent waiting for the database to do its thing. There's also a good deal of time usually spent by the database waiting on you to tell it what to do next. In both cases, time is wasted and the overall productivity of the DBA is seriously affected. Besides, let's face it, the stuff you can automate is usually the boring stuff you don't really want to be doing anyway! So let Oracle do the work for you.

Improved Quality

The hidden benefit to automation is a significant improvement in the quality of the DBA's work. An automated task is a predictable and repeatable task. When you do a task manually, especially one you do repeatedly, you will eventually make mistakes. Sometimes they're small mistakes, sometimes big ones. But if you automate the task, it will always be performed the same way, time after time after time.

Use What's Already There

Right from the very beginning, with the initial software installation, Oracle allows you to reduce or eliminate the need for a DBA to watch and wait. Once Oracle has been installed, you can configure the network and create one or more databases automatically, with no human intervention.

After the software is installed and the database created, the DBA finally reaches the real meat of the job. For the experienced DBA, there's a very real tendency to keep using the tools he or she has always used, even if the tools were originally created for use with Oracle 7. The fledgling DBA can run into similar problems, since it's difficult to discover all the different automation opportunities included with Oracle while simultaneously dealing with demands from users, developers, and management.

In spite of these challenges, or even because of them, it's vitally important to automate as much as is possible. It's equally important to avoid recreating a capability that's already available. The two most recent versions of Oracle have added an almost unbelievable wealth of options for the overworked DBA to automate his or her way to a quieter pager.

Test Everything First

With the multitude of new capabilities in recent versions, there's a temptation to implement everything that the documentation says will help improve operations or performance. Resist the temptation—at least long enough to allow time for testing of each and every new feature prior to implementation. Some of the new features will help in all situations, some will help in all but a few situations, and a few might create problems in certain circumstances. Testing prior to implementation is essential.

What's in this Book?

Chapter 1 will introduce the Oracle Universal Installer (OUI), and explain the use and creation of response files, which are files that provide your responses to the installer. Response files allow a highly automated installation session to proceed with little or no user intervention. You can even use these files as templates for manual installs, when you need to deviate slightly from the response file's intended course.

In Chapter 2, Oracle Network Configuration Assistant (NetCA) will receive similar treatment. While not as automation-friendly as the OUI, NetCA does have a reasonable amount of flexibility, using response files similar to those used by OUI.

Chapter 3 is all about the Oracle Database Configuration Assistant (DBCA). The DBCA is one of the most versatile parts of a DBA's toolkit, and extremely easy to automate. You can use DBCA-specific response files, but the real strength of the tool lies in its unique use of template files. The DBCA can create databases, clone them, and even "reverse-engineer" an existing database into a template, or even a set of scripts.

Finally, Chapter 4 can be regarded as a "survey course" of Oracle features that can be used to automate some of the tasks that consume a DBA's time day in and day out.

Talk to Us

We have made every attempt in this short volume to provide as complete a reference as we could, always with the goal of keeping it brief and easy to find the information you need. Our goal was to give the working Oracle DBA a tool to make him or her more productive, and we sincerely hope you find it useful. Every effort has been made to be both complete and accurate. If you do find an error or omission, or have a comment on the book, we very much want to hear from you. Please write us at: OracleAutomation@scribes.com. We don't promise to answer every question or comment, but we do read them and very much appreciate them.

Read More Show Less

Introduction

Introduction

The Oracle database is a complex and ever-changing product that has grown increasingly complex and powerful over the years. In the bad old days, the working Oracle database administrator (DBA) had a limited set of tools to automate the day-to-day tasks of maintaining the health and integrity of Oracle databases. Thankfully, that has changed over time, and now with Oracle 9i, and especially Oracle 10g, nearly everything associated with the database can be automated. Unfortunately, Oracle has provided little documentation on exactly how best to accomplish this. We hope this book will help you on your road to discovering the many ways that Oracle can be automated.

Why Automate?

Very few DBAs are allowed the luxury of managing a single database, or even two, or three. In these days of increasing workloads, many of us are managing 20, 30, or more databases, and they're frequently scattered all over the world. With the number of databases in use on the rise, it's important to streamline every step of the process as much as possible. Automation improves your productivity in two very important ways: It reduces the time you need to spend waiting for the database to do something, and it improves the overall quality and repeatability of what you do.

Improved Productivity

The first advantage to automation is improving the overall productivity of the Oracle DBA. When the DBA performs a task manually, there is, inevitably, a substantial amount of time spent waiting for the database to do its thing. There's also a good deal of time usually spent by the database waiting on you to tell it what to do next. In both cases, timeis wasted and the overall productivity of the DBA is seriously affected. Besides, let's face it, the stuff you can automate is usually the boring stuff you don't really want to be doing anyway! So let Oracle do the work for you.

Improved Quality

The hidden benefit to automation is a significant improvement in the quality of the DBA's work. An automated task is a predictable and repeatable task. When you do a task manually, especially one you do repeatedly, you will eventually make mistakes. Sometimes they're small mistakes, sometimes big ones. But if you automate the task, it will always be performed the same way, time after time after time.

Use What's Already There

Right from the very beginning, with the initial software installation, Oracle allows you to reduce or eliminate the need for a DBA to watch and wait. Once Oracle has been installed, you can configure the network and create one or more databases automatically, with no human intervention.

After the software is installed and the database created, the DBA finally reaches the real meat of the job. For the experienced DBA, there's a very real tendency to keep using the tools he or she has always used, even if the tools were originally created for use with Oracle 7. The fledgling DBA can run into similar problems, since it's difficult to discover all the different automation opportunities included with Oracle while simultaneously dealing with demands from users, developers, and management.

In spite of these challenges, or even because of them, it's vitally important to automate as much as is possible. It's equally important to avoid recreating a capability that's already available. The two most recent versions of Oracle have added an almost unbelievable wealth of options for the overworked DBA to automate his or her way to a quieter pager.

Test Everything First

With the multitude of new capabilities in recent versions, there's a temptation to implement everything that the documentation says will help improve operations or performance. Resist the temptation—at least long enough to allow time for testing of each and every new feature prior to implementation. Some of the new features will help in all situations, some will help in all but a few situations, and a few might create problems in certain circumstances. Testing prior to implementation is essential.

What's in this Book?

Chapter 1 will introduce the Oracle Universal Installer (OUI), and explain the use and creation of response files, which are files that provide your responses to the installer. Response files allow a highly automated installation session to proceed with little or no user intervention. You can even use these files as templates for manual installs, when you need to deviate slightly from the response file's intended course.

In Chapter 2, Oracle Network Configuration Assistant (NetCA) will receive similar treatment. While not as automation-friendly as the OUI, NetCA does have a reasonable amount of flexibility, using response files similar to those used by OUI.

Chapter 3 is all about the Oracle Database Configuration Assistant (DBCA). The DBCA is one of the most versatile parts of a DBA's toolkit, and extremely easy to automate. You can use DBCA-specific response files, but the real strength of the tool lies in its unique use of template files. The DBCA can create databases, clone them, and even "reverse-engineer" an existing database into a template, or even a set of scripts.

Finally, Chapter 4 can be regarded as a "survey course" of Oracle features that can be used to automate some of the tasks that consume a DBA's time day in and day out.

Talk to Us

We have made every attempt in this short volume to provide as complete a reference as we could, always with the goal of keeping it brief and easy to find the information you need. Our goal was to give the working Oracle DBA a tool to make him or her more productive, and we sincerely hope you find it useful. Every effort has been made to be both complete and accurate. If you do find an error or omission, or have a comment on the book, we very much want to hear from you. Please write us at: OracleAutomation@scribes.com. We don't promise to answer every question or comment, but we do read them and very much appreciate them.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)