Booknews
Written for database administrators, this text covers architecture, installation, tuning, security, networking, and the basics of application development with PL/SQL. The CD-ROM contains a computer based training module and DBAware 2.0. Annotation c. by Book News, Inc., Portland, Or.
Oracle8 Database Administration on Windows NT
by Lynnwood BrownView All Available Formats & Editions
If you're running Oracle8 on a Windows NT Server, all the hard-to-find DBA information you need is right here, in Oracle8 Database Administration on Windows NT. Expert Oracle DBA Lynwood Brown covers architecture, installation, tuning, security, networking, and even the basics of application development with PL/SQL. Whether you're an experienced DBA or a novice,… See more details below
Overview
If you're running Oracle8 on a Windows NT Server, all the hard-to-find DBA information you need is right here, in Oracle8 Database Administration on Windows NT. Expert Oracle DBA Lynwood Brown covers architecture, installation, tuning, security, networking, and even the basics of application development with PL/SQL. Whether you're an experienced DBA or a novice, you'll find invaluable guidance.
Editorial Reviews
Product Details
- ISBN-13:
- 9780139274435
- Publisher:
- Pearson Education
- Publication date:
- 10/16/1998
- Series:
- Prentice Hall Oracle Series
- Edition description:
- BK&CD ROM
- Pages:
- 400
- Product dimensions:
- 7.04(w) x 9.26(h) x 0.89(d)
Read an Excerpt
PREFACE: Preface
This book is intended for people who have a basic understanding of computers and programming. The reader should be familiar with Windows NT, but does not have to be an expert. There are several appendices with helpful tips on the various utilities that are used to install, manage and tune the Oracle relational database management system. The Windows NT operating system will be covered at a level intended to show the integration of Windows NT and Oracle8. The book is written for those people that may have experience with mainframe, UNIX or Windows/DOS computing and need to understand how Oracle's RDBMS functions on the Windows NT platform.
The audience that this book is intended for includes:
- Working professionals who need to understand Oracle8 on the Windows NT platform and are not enrolled in a college or extension course. These are people that work for companies that are considering or have decided to invest in Oracle as a solution to their data processing needs.
- Working professionals that are taking a course in computer systems through a college or a computer training school.
- College students taking a course in computer science or information systems.
The book is compiled from my experience teaching Oracle database administration at the University of California at Berkeley Extension and teaching and consulting and at various corporations including DHL, MCI, Wells Fargo Bank, GTE, InfoWorld and Clarify Inc. I have also drawn on my experience working for the Oracle Corporation in the worldwide technical support group. Many of my students are working professionals who have many years of experienceusing various other RDBMS products and need to learn Oracle to advance their careers. One of my goals in writing this book is to consolidate relevant information on Oracle database administration into one easy to understand book and use this information in training other database administrators. I can be contacted at www.ldbrown.com if additional or specific training or consulting is required.
The intent of the book is not to teach database design or be a guide to SQL programming. The focus of the book is to show a person who has some basic programming skills what is Oracle8 and how can they use it. At various parts in the book the reader will be pointed to reference material that comes from Oracle. Therefore the reader will be able to gain an understanding of Oracle and how to use the system. Should they require further information into the theory behind how Oracle operates they will be pointed to the various Oracle reference manuals. It is my feeling that the Oracle manuals are the best place to get detailed information on Oracle. The problem is that the manuals are usually written for someone that already understands the product and the information is spread out among many manuals.
Some of the material for the book came from my first book on Oracle database administration on the UNIX operating system. This book is an expansion of the first book in that it describes the activities that a DBA performs while administering an Oracle8 database on the Windows NT operating system platform. The job of the database administrator (DBA) can be divided into the various tasks that the DBA may be required to perform during a normal day. These task include:
- Database installation and customization
- Database performance monitoring/analysis
- Database backup and recovery
- Database tuning
- Application tuning
- End user creation and management
- Client server application implementation
- Database capacity planning
- Implementing database security
- Database auditing
This book will demystify Oracle database administration by using real world examples of the various tasks that a DBA will be required to perform on a daily basis. The problem with a lot of the documentation that comes from Oracle concerning it's RDBMS and tools are that it is spread out among too many books. This book seeks to consolidate this information into one text. The book focuses on the following database administration topics:
- Introduction to the Oracle relational database management system and the various products that are offered by the Oracle Corporation. The reader will be introduced to the reasons why the Oracle relational database management system running on the Windows NT platform has become a very popular environment for client server computing.
- The Oracle8 RDBMS architecture. The architectural discussion provides the foundation that will be required in the latter sections on installation considerations and performance and tuning for the Windows NT operating system.
- Installation and configuration of the Oracle relational database management system software. Various tips will be given to help demystify the installation of Oracle on the Windows NT platform. The chapter will show the tight integration between Oracle8 and the Windows NT operating system.
- Client server implementation using Oracle's SQL*NET. The topics include SQL*NET's integration with the Window NT's networking strategy. In addition to defining what is a protocol and what are some of the more popular communications techniques/protocols (SPX/IPX, SNA, TCP/IP etc. ...) the configuration and debug of SQL*NET is covered.
- End user management and system security.
The reader is introduced to the various SQL commands that must be used to accomplish basic DBA task. The purpose of the book is not to teach SQL but an appendix on SQL programming is included. The language reference also includes examples of Oracle's procedural language PL/SQL. The reader is introduced to the SQL commands that are required for the DBA to manage the database. The reader will be introduced to the various graphical user interface (GUI) tools that are part of Oracle8 offering. The relationship between the various GUI tools and the SQL commands that they generate will be covered in detail.
Easy to understand performance guidelines will be covered. The reader is stepped through what system information should be collected from the Windows NT operating system as well as the Oracle kernel. The reader will be guided through how to tune the system based on the performance data.
The book includes sections covering application development and the management of very large databases. The reader will be introduced to table partitioning and how it is used to manage large tables. The reader is also introduced to entity relationship modeling and its role in application development. The goal is to introduce the reader to data modeling as it relates to the DBA.
The book is organized into the following chapters:
Chapter 1 - Introduction
- Introduce the reader to RDBMS from a historical perspective.
- Introduce the Oracle RDBMS and the various tools that make up the Oracle offering. A brief explanation will be given for the various Oracle tools and applications.
Chapter 2 - The Oracle8 RDBMS Architecture
- Introduce the reader to the Oracle RDBMS architecture. The various Oracle services and data structures will be described. The relationship between the data structures and the various Windows NT services will be described both pictorially and in writing.
- Introduce various commands and terminology that will be used in the latter sections of the book.
Chapter 3 - System Installation
- Explain the installation process is integrated with the Windows NT registry.
- Explain the various Windows NT system administration tasks that need to be performed to set up the correct environment for the installation and give examples on how to perform them.
Chapter 4 - Client/Server Implementation
- Introduce the reader to data communications. Various types of data communications architectures will be briefly covered. The OSI model will be described and related to the implementation of client server systems using Oracle's SQL*NET.
- Cover various installation and debug issues using SQL*NET v2.
- Cover the use of SQL*NET in implementing client server and distributed database environments.
Chapter 5 - Database Access and Security
- Introduce the reader to the basic DBA task. The topics will include how to add users, controlling access (security), starting and stopping the database. Various examples will be given. The examples will show how the operations are performed using one of the new GUI tools (such as Data Manager) and it's command line equivalent.
- Sow the relationship between performing the various end user management tasks using the new Oracle GUI's (User Manager, Data Manager etc.) and using the command line utility Server Manager.
Chapter 6 - Database Backup/Recovery
- Backup and recovery techniques will be covered through various examples. The reader will be advised as to how to determine the best backup strategy for their environment.
- Database backup and recovery using the Oracle Backup and Recovery utility and using the command line utility Server Manager.
Chapter 7 - Database Performance and Tuning
- Show the reader how collect and interpret the database performance statistics.
- Show the reader how to tune the system (this includes the RDBMS and how it relates to the Windows NT operating system).
- Show the reader how use the utilities database analysis product DBAware.
Chapter 8 - Database Capacity Planning
- Estimating disk storage requirements.
- Estimating table, index and rollback segment requirements.
- Monitoring disk storage utilization.
Chapter 9 - Application Development
- Entity Relationship modeling and its relationship to application development
- Defining database constraints related to the ER model.
- Managing large tables using table stripping
- Managing large tables using table partitioning
SQL is introduced as the programming language that is used to access the Oracle relational database system. The language reference that is provided contains various examples that the readers can use to familiarize themselves with the SQL language. The SQL language reference has also been expanded to include object oriented SQL and PL/SQL examples.
A project of this size cannot be accomplished without the help of other people. I want to thank my former students Sujata Raju for her assistance in writing the Oracle product summary and Robert Briley (now with Oracle Worldwide Technical Support) for his review and comments. I want to thank Fif W. Agenhu of the University of California at Berkeley Extension's Computer and Information Systems department for her comments on Windows NT system administration. Thank you Paul Osborn of MenloSoftware for providing the database analysis tool DBAware and the section on using DBAware for Oracle database analysis and tuning. I also want to thank Paul for being a good friend who kept me laughing as we discussed topics related and unrelated to database administration. I want to thank the publishing staff of Prentice Hall especially Mark Taub for believing in me and Joanne Anzalone for not giving up on me. I want to thank Barbara Brown for being my mom. As always I want to thank my sister Stephanie Brown for indexing the manuscript, tolerating all of my last minute changes and being my best friend.
Customer Reviews
Average Review: