oracle 11g管理篇

Contents

Preface (xxxv)

Audience (xxxv)

Documentation Accessibility (xxxv)

Related Documents (xxxvi)

Conventions (xxxvi)

What's New in Oracle Database Administrator's Guide? (xxxvii)

Oracle Database 11g Release 2 (11.2.0.3) New Features in the Administrator's Guide (xxxvii)

Oracle Database 11g Release 2 (11.2.0.2) New Features in the Administrator's Guide (xxxvii)

Oracle Database 11g Release 2 (11.2.0.1) New Features in the Administrator's Guide (xxxix)

Part I Basic Database Administration

1 Getting Started with Database Administration

Types of Oracle Database Users............................................................................................................ 1-1 Database Administrators.................................................................................................................. 1-1 Security Officers................................................................................................................................. 1-2 Network Administrators................................................................................................................... 1-2 Application Developers..................................................................................................................... 1-2 Application Administrators.............................................................................................................. 1-3 Database Users................................................................................................................................... 1-3 Tasks of a Database Administrator....................................................................................................... 1-3 Task 1: Evaluate the Database Server Hardware.......................................................................... 1-3 Task 2: Install the Oracle Database Software................................................................................. 1-4 Task 3: Plan the Database.................................................................................................................. 1-4 Task 4: Create and Open the Database........................................................................................... 1-5 Task 5: Back Up the Database........................................................................................................... 1-5 Task 6: Enroll System Users.............................................................................................................. 1-5 Task 7: Implement the Database Design......................................................................................... 1-5 Task 8: Back Up the Fully Functional Database............................................................................ 1-5 Task 9: Tune Database Performance............................................................................................... 1-5 Task 10: Download and Install Patches.......................................................................................... 1-6 Task 11: Roll Out to Additional Hosts............................................................................................ 1-6 Submitting Commands and SQL to the Database............................................................................. 1-6 About SQL*Plus.................................................................................................................................. 1-7

iii