oracle 11g管理篇

Connecting to the Database with SQL*Plus................................................................................... 1-7 Identifying Your Oracle Database Software Release.....................................................................1-12 Release Number Format.................................................................................................................1-13 Checking Your Current Release Number....................................................................................1-13 About Database Administrator Security and Privileges...............................................................1-14 The Database Administrator's Operating System Account......................................................1-14 Administrative User Accounts......................................................................................................1-14 Database Administrator Authentication..........................................................................................1-16 Administrative Privileges..............................................................................................................1-16 Selecting an Authentication Method for Database Administrators........................................1-18 Using Operating System Authentication.....................................................................................1-20 Using Password File Authentication............................................................................................1-21 Creating and Maintaining a Password File......................................................................................1-22 Creating a Password File with ORAPWD...................................................................................1-23 Sharing and Disabling the Password File....................................................................................1-24 Adding Users to a Password File..................................................................................................1-26 Maintaining a Password File.........................................................................................................1-27 Data Utilities..........................................................................................................................................1-28 2 Creating and Configuring an Oracle Database

About Creating an Oracle Database..................................................................................................... 2-1 Considerations Before Creating the Database............................................................................... 2-2 Creating a Database with DBCA........................................................................................................... 2-5 Creating a Database with Interactive DBCA.................................................................................. 2-5 Creating a Database with Noninteractive/Silent DBCA.............................................................. 2-5 Creating a Database with the CREATE DATABASE Statement..................................................... 2-6 Step 1: Specify an Instance Identifier (SID).................................................................................... 2-7 Step 2: Ensure That the Required Environment Variables Are Set............................................. 2-7 Step 3: Choose a Database Administrator Authentication Method............................................ 2-7 Step 4: Create the Initialization Parameter File.............................................................................. 2-8 Step 5: (Windows Only) Create an Instance................................................................................... 2-9 Step 6: Connect to the Instance......................................................................................................... 2-9 Step 7: Create a Server Parameter File.........................................................................................2-10 Step 8: Start the Instance ...............................................................................................................2-10 Step 9: Issue the CREATE DATABASE Statement.....................................................................2-11 Step 10: Create Additional Tablespaces.......................................................................................2-14 Step 11: Run Scripts to Build Data Dictionary Views ...............................................................2-14 Step 12: (Optional) Run Scripts to Install Additional Options.................................................2-15 Step 13: Back Up the Database......................................................................................................2-15 Step 14: (Optional) Enable Automatic Instance Startup............................................................2-15 Specifying CREATE DATABASE Statement Clauses....................................................................2-15 Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM....................2-16 Creating a Locally Managed SYSTEM Tablespace.....................................................................2-17 About the SYSAUX Tablespace.....................................................................................................2-17 Using Automatic Undo Management: Creating an Undo Tablespace....................................2-18 Creating a Default Permanent Tablespace..................................................................................2-18 Creating a Default Temporary Tablespace..................................................................................2-18 iv