| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Making It Work | |
| |
| |
| Checking Space | |
| |
| |
| Checking Object Status | |
| |
| |
| Monitoring the Alert Log | |
| |
| |
| Automating Tasks | |
| |
| |
| Creating a Database | |
| |
| |
| Optimal Flexible Architecture (OFA) | |
| |
| |
| Oracle DBCA | |
| |
| |
| PFILE | |
| |
| |
| Starting and Stopping a Database | |
| |
| |
| Shutdown Options | |
| |
| |
| Startup Options | |
| |
| |
| Managing Users | |
| |
| |
| Profiles | |
| |
| |
| Resource Group Directives | |
| |
| |
| Password Group Parameters | |
| |
| |
| The CREATE USER Statement | |
| |
| |
| Working with Roles | |
| |
| |
| Control of Data Access | |
| |
| |
| Summary | |
| |
| |
| Getting Things Done | |
| |
| |
| Database Connections | |
| |
| |
| Connection Basics | |
| |
| |
| Connecting as a User | |
| |
| |
| Connecting as SYSDBA or SYSOPER | |
| |
| |
| Connecting with a Script | |
| |
| |
| Disconnecting Users | |
| |
| |
| Auditing Database Connections | |
| |
| |
| Using Oracle's Auditing Feature | |
| |
| |
| Limiting User Connection Time | |
| |
| |
| PL/SQL | |
| |
| |
| Handy Oracle-Provided PL/SQL Facilities | |
| |
| |
| PL/SQL Procedures | |
| |
| |
| PL/SQL Functions | |
| |
| |
| Using Packages in PL/SQL | |
| |
| |
| Wrapping PL/SQL Code | |
| |
| |
| Triggers | |
| |
| |
| Summary | |
| |
| |
| Saving It and Bringing It Back | |
| |
| |
| Some Concept Definitions | |
| |
| |
| User-Managed Backup vs. RMAN-Managed Backup and Recovery | |
| |
| |
| User-Managed Backup and Recovery | |
| |
| |
| RMAN-Managed Backups | |
| |
| |
| Strategy | |
| |
| |
| Requirements | |
| |
| |
| Failures | |
| |
| |
| Cold Backups | |
| |
| |
| Shutdown | |
| |
| |
| Copying Files | |
| |
| |
| Startup | |
| |
| |
| Restoring from Cold Backups | |
| |
| |
| Disadvantages | |
| |
| |
| Warm Backups | |
| |
| |
| Differences | |
| |
| |
| Putting Tablespaces into Backup Mode | |
| |
| |
| Scripting | |
| |
| |
| Recovering from Warm Backups | |
| |
| |
| An Aside | |
| |
| |
| Real-Time Backups | |
| |
| |
| Suspended Backup | |
| |
| |
| RMAN | |
| |
| |
| Vocabulary | |
| |
| |
| To Catalog or Not to Catalog | |
| |
| |
| Creating a Catalog | |
| |
| |
| Connecting | |
| |
| |
| REGISTER DATABASE | |
| |
| |
| Allocating Channels | |
| |
| |
| Creating Backup Sets | |
| |
| |
| Restoring and Recovering from Backup Sets | |
| |
| |
| Reporting | |
| |
| |
| Scripting | |
| |
| |
| Extras | |
| |
| |
| Backing Up Parts and Pieces | |
| |
| |
| Backing Up Your Control File | |
| |
| |
| Backing Up with Exports | |
| |
| |
| Summary | |
| |
| |
| Database Tuning: Making It Sing | |
| |
| |
| Database Design | |
| |
| |
| Application Tuning | |
| |
| |
| Memory Tuning | |
| |
| |
| Disk I/O Tuning | |
| |
| |
| Database Contention | |
| |
| |
| Operating System Tuning | |
| |
| |
| Finding the Trouble | |
| |
| |
| EXPLAIN Please | |
| |
| |
| Traces | |
| |
| |
| Statspack | |
| |
| |
| Users | |
| |
| |
| Fixing the Trouble | |
| |
| |
| Tuning Database Parameters | |
| |
| |
| Tuning the Database Structure | |
| |
| |
| What, More? | |
| |
| |
| Oracle 10g | |
| |
| |
| Making It Sing | |
| |
| |
| Materialized Views | |
| |
| |
| Clusters | |
| |
| |
| Summary | |
| |
| |
| Database Down! Bring It Back Alive! | |
| |
| |
| Database Down | |
| |
| |
| Restarting | |
| |
| |
| If It Doesn't Start | |
| |
| |
| If It Doesn't Stop | |
| |
| |
| Finding Out Why | |
| |
| |
| Tools | |
| |
| |
| Alert Log Monitors | |
| |
| |
| Database Monitoring | |
| |
| |
| History | |
| |
| |
| Panic Mode | |
| |
| |
| Hot Standby Database | |
| |
| |
| Problem Resolution | |
| |
| |
| No Oracle Connectivity | |
| |
| |
| Database Links | |
| |
| |
| RDA | |
| |
| |
| Test Cases | |
| |
| |
| Summary | |
| |
| |
| High Availability | |
| |
| |
| High Availability | |
| |
| |
| Simple High Availability | |
| |
| |
| Hardware Failure and High Availability | |
| |
| |
| What It Isn't | |
| |
| |
| Grid | |
| |
| |
| The Only Answer | |
| |
| |
| For Everyone | |
| |
| |
| What It Is | |
| |
| |
| Want to Try It Out? | |
| |
| |
| No Need for Fencing | |
| |
| |
| No Need for Oracle Cluster File System or Raw Devices | |
| |
| |
| No Need for Multiple Oracle Homes | |
| |
| |
| Init File | |
| |
| |
| Parameters | |
| |
| |
| Single-Node RAC on Linux | |
| |
| |
| RAC on a Single VMware Node | |
| |
| |
| RAC on Multiple VMware Nodes | |
| |
| |
| RAC with Network Block Devices | |
| |
| |
| What, There's More? | |
| |
| |
| Data Guard | |
| |
| |
| Protection Modes | |
| |
| |
| Oracle 10g | |
| |
| |
| Maximum Availability Architecture | |
| |
| |
| Grid | |
| |
| |
| Summary | |
| |
| |
| Other Stuff | |
| |
| |
| OEM | |
| |
| |
| Standalone Use | |
| |
| |
| Intelligent Agents | |
| |
| |
| Blackouts | |
| |
| |
| Using Jobs | |
| |
| |
| Setting Events | |
| |
| |
| OAM | |
| |
| |
| Configuration Information | |
| |
| |
| Oracle Workflow Mailer Management | |
| |
| |
| System Alerts | |
| |
| |
| Diagnostic Log Viewer | |
| |
| |
| Patch Advisor | |
| |
| |
| License Manager | |
| |
| |
| Init.ora Parameters | |
| |
| |
| Monitoring and Analysis | |
| |
| |
| Other Oracle Systems | |
| |
| |
| Express | |
| |
| |
| Oracle 9i Lite | |
| |
| |
| Warehouse Builder | |
| |
| |
| Discoverer | |
| |
| |
| Oracle Text | |
| |
| |
| HTML DB | |
| |
| |
| Ultra Search | |
| |
| |
| Spatial | |
| |
| |
| How Does It Do That? | |
| |
| |
| XML DB | |
| |
| |
| Collaboration Suite | |
| |
| |
| E-Business Suite | |
| |
| |
| Oracle iAS | |
| |
| |
| Concurrent Managers | |
| |
| |
| ADI | |
| |
| |
| FSG | |
| |
| |
| Workflow | |
| |
| |
| Customization | |
| |
| |
| Passwords | |
| |
| |
| Summary | |
| |
| |
| Will It Work? | |
| |
| |
| Planning and Organization | |
| |
| |
| Develop a Test Plan | |
| |
| |
| Requirements-Based Testing | |
| |
| |
| What Testing Is | |
| |
| |
| Important | |
| |
| |
| A Tool | |
| |
| |
| What Testing Is Not | |
| |
| |
| What Good Testing Does | |
| |
| |
| Functional Testing | |
| |
| |
| The Proper Environment | |
| |
| |
| Limiting Variables | |
| |
| |
| Collecting Results | |
| |
| |
| Unit Testing | |
| |
| |
| Component Testing | |
| |
| |
| Integration Testing | |
| |
| |
| An Example and a Counter Example | |
| |
| |
| Load Testing | |
| |
| |
| How to Determine Possible Loads | |
| |
| |
| Regression Testing | |
| |
| |
| Clone | |
| |
| |
| Building a Library | |
| |
| |
| Tools | |
| |
| |
| Mercury WinRunner | |
| |
| |
| OUNIT | |
| |
| |
| Optimization | |
| |
| |
| Collection | |
| |
| |
| Analysis | |
| |
| |
| Configuration | |
| |
| |
| Testing Again | |
| |
| |
| Summary | |
| |
| |
| Glossary | |
| |
| |
| Index | |