Oracle DBA on Unix and Linux

Overview

Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This ...

See more details below
Other sellers (Paperback)
  • All (23) from $1.99   
  • New (7) from $12.03   
  • Used (16) from $1.99   
Sending request ...

Overview

Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9I coverage; and iAS--Internet Application Server.

Read More Show Less

Editorial Reviews

From The Critics
This book covers Oracle databases on both Unix and Linux platforms, offering techniques that bridge the gap between the database administrator and the Unix/Linux system administrator. The core responsibilities of the Oracle database administrator are covered in depth, from the Unix and Linux perspectives. Coverage includes the architecture of both operating systems, with material on system planning, installation, database creation, maintenance, troubleshooting, and backup and recovery. Installation and configuration of new products, such as Oracle Portal, is discussed. Wessler is an Oracle consultant working at the Department of Defense. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780672321580
  • Publisher: Prentice Hall
  • Publication date: 10/28/2001
  • Series: Kaleidoscope Series
  • Pages: 600
  • Product dimensions: 7.20 (w) x 9.00 (h) x 1.20 (d)

Meet the Author

Michael Wessler received his B.S. in Computer Technology from Purdue University in West Lafayette, IN. He is an Oracle Certified Database Administrator for Oracle 8 and 8i. He has administered Oracle databases on NT, and various flavors of Unix, and Linux at several different companies ranging from a handful of employees to IT staffs in the thousands. Included in this experience is working at a true .com startup and managing a mission-critical OPS database on a Sun Cluster. Michael has also programmed professionally in COBOL, SQL, and PL/SQL. Currently, he is an Oracle consultant for Perpetual Technologies working at the Department of Defense in Indianapolis, Indiana. Michael is coauthor of Oracle Unleashed, Second Edition; Unix Primer Plus, Third Edition; and COBOL Unleashed. Michael can be reached at mwessler@yahoo.com.

Read More Show Less

Table of Contents

Introduction.

Who Should Read This Book? What Makes This Book Different?

1. Role of the DBA.

What Is a DBA? Types of DBAs. Database Administration Principles. Database Administration Responsibilities. Roles Within the IT Organization. DBA Mindset. Summary.

2. Architecture of the Oracle Server.

Oracle Products Relating to Database Servers. Database Versus Instance. Oracle File Types. Memory Structures. Oracle Processes. Transaction Control. Miscellaneous Database Files. Summary.

3. Planning a Database.

System Architecture. Capacity Planning/Sizing. Optimal Flexible Architecture. Application and Database Considerations. Summary.

4. Machine Setup and Installation.

Pre-Installation Setup. Installing Oracle. Summary.

5. Creating a Database.

Generating Creation Scripts. Creating the Database. Post-Creation Activities. Configuring Net8 for the New Database. Customizing Your .profile File. Summary.

6. Daily Activities.

Database Views. Oracle Startup/Shutdown. User Management. Space Management. Monitoring. Summary.

7. GUI Management Products.

Oracle Enterprise Manager. TOAD. Summary.

8. DBA Utilities.

Export and Import. Common Export/Import Uses. Maintenance Benefits of Export/Import. Advanced Export and Import Techniques. Using SQL*Loader. Using LogMiner. Summary.

9. Backup and Recovery.

Importance of Backups. Backup Types. Incurring Damage on the Database. Performing Backups and Recoveries. Comprehensive Planning and Testing. Summary.

10. When Things Go Wrong.

Responding to Problems. File and Space Management. Locking. "Snapshot Too Old" Rollback Errors. Summary.

11. Oracle Server Tuning.

Database Tuning Approach. Diagnostic Utilities: UTLBSTAT/UTLESTAT and STATSPACK. Tuning Memory Structures. Tuning Rollback Segments. Avoiding File Contention. Wait Events. Locally Managed Tablespaces. Tuning Tables. Indexes. Summary.

12. Unix Operation System Architecture.

Imperative Concepts. Understanding the Kernel. Startup/Shutdown Processes in Unix. Understanding the Hardware Architecture. Summary.

13. Unix Server Monitoring.

Need for Monitoring the Server. Overview of Monitoring the Server. Monitoring Memory Issues. Monitoring Disk I/O. Monitoring the CPU. Monitoring the Network. Summary.

14. Patches and Upgrades.

What Are Patches and Upgrades? When and How to Apply Patches. When and How to Upgrade. Additional Considerations. Summary.

15. Migrations.

What Is a Migration. Reasons to Migrate Your Database. Preparation. Migration Methods. Using ODMA. Summary.

16. Java Inside the Database Server.

Understanding the Role and Future of Java Inside Oracle. Java Overview. Supporting Java with Oracle. Managing Java Inside the Database. Summary.

17. WebDB/Oracle Portal.

What Are WebDB and Oracle Portal? WebDB/Oracle Portal Architecture. Installation. Basic WebDB Maintenance. Log into the Site. Key Differences between Oracle Portal and WebDB. Summary.

18. Internet Application Server (iAS).

Web Environment. Understanding and Using iAS. Installation. Configuration File Location and Apache Control. Summary.

19. 9i Server New Features.

Installing the 9i Server. Setting Up Security and Logging In. Creating a Server Parameter File (SPFILE). Using Oracle-Managed Files. Using Dynamic Memory Parameters and Multiple Block Sizes. Using Undo Tablespaces. Comprehensive Sample Schemas. Miscellaneous Features and Changes. Summary.

20. Growth of the DBA.

Growth of the DBA. Motivation. Continuing Your Education. Getting Certified. Networking with Other DBAs. Learning Systems Administration and Architecture. Learning Java. Summary.

Appendix A. Basic Unix Commands.

Appendix B. vi Editor.

Cursor-Movement Commands. Entering Text. Editing Text. Saving and Exiting. Miscellaneous Commands.

Appendix C. Scripts.

Hot Backup Script.

Glossary.

Index.

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)