Oracle的C模板,Oracle19c官⽅⽂档系
列-《DatabaAdministr。。。
Oracle 19c 官⽅⽂档系列-《Databa Administrator’s Guide》
免费
专栏简介
19c 作为 Oracle Databa 12c 的最终稳定版版，出来也有⼀些时间了，经过⼀年多的认真学习及实验，由于内容的快速迭代，从18c开始，将《Databa Administrator’s Guide》 分为了两部分，分别为《Databa Administrator’s Guide》和《Multitenant Administrator's Guide》两本⼿册。出于分享和探讨的⽬的，特开启这两部⼿册的翻译，⼀起分享，共同进步，希望对各位同⾏有所帮助。
原⽂档信息如下：
Oracle® Databa\Databa Administrator’s Guide \19c \E96348-06\December 2019
专栏⼤纲
Part I Basic Databa Administration
1 Getting Started with Databa Administration
1.1 Types of Oracle Databa Urs 1-1
除日1.1.1 Databa Administrators 1-2
1.1.2 Security Officers 1-3
欧美女人图片1.1.3 Network Administrators 1-3
1.1.4 Application Developers 1-3
1.1.5 Application Administrators 1-4
1.1.6 Databa Urs 1-4
1.2 Tasks of a Databa Administrator 1-4
1.2.1 Task 1: Evaluate the Databa Server Hardware 1-5
1.2.2 Task 2: Install the Oracle Databa Software 1-5
1.2.3 Task 3: Plan the Databa 1-6
1.2.4 Task 4: Create and Open the Databa 1-6
1.2.5 Task 5: Back Up the Databa 1-7
iii
1.2.6 Task 6: Enroll System Urs 1-7
1.2.7 Task 7: Implement the Databa Design 1-7
1.2.8 Task 8: Back Up the Fully Functional Databa 1-7
1.2.9 Task 9: Tune Databa Performance 1-7
1.2.10 Task 10: Download and Install Relea Updates and Relea Update Revisions 1-8
1.2.11 Task 11: Roll Out to Additional Hosts 1-8
1.3 SQL Statements 1-9
1.3.1 Submitting Commands and SQL to the Databa 1-9
1.3.2 About SQL*Plus 1-10
1.3.3 Connecting to the Databa with SQL*Plus 1-10
1.3.3.1 About Connecting to the Databa with SQL*Plus 1-11
1.3.3.2 Step 1: Open a Command Window 1-11
1.3.3.3 Step 2: Set Operating System Environment Variables 1-11
1.3.3.4 Step 3: Start SQL*Plus 1-12
1.3.3.5 Step 4: Submit the SQL*Plus CONNECT Command 1-12
1.4 Identifying Your Oracle Databa Software Relea 1-17
1.4.1 About Oracle Databa Relea Numbers 1-17
1.4.2 Checking Your Current Relea Number 1-19
1.5 About Databa Administrator Security and Privileges 1-19
照片文件大小怎么改1.5.1 The Databa Administrator's Operating System Account 1-20
1.5.2 Administrative Ur Accounts 1-20
1.5.
2.1 About Administrative Ur Accounts 1-21
1.5.
2.2 SYS 1-21
1.5.
2.3 SYSTEM 1-22
1.5.
2.4 SYSBACKUP, SYSDG, SYSKM, and SYSRAC 1-22
1.5.
2.5 The DBA Role 1-23
1.6 Databa Administrator Authentication 1-23
1.6.1 Administrative Privileges 1-24
1.6.2 Operations Authorized by Administrative Privileges 1-25
1.6.3 Authentication Methods for Databa Administrators 1-27
1.6.3.1 About Authentication Methods for Databa Administrators 1-27 1.6.3.2 Noncure Remote Connections 1-29
1.6.3.3 Local Connections and Secure Remote Connections 1-29
1.6.4 Using Operating System Authentication 1-30
1.6.4.1 Operating System Groups 1-30
1.6.4.2 Preparing to U Operating System Authentication 1-32
1.6.4.3 Connecting Using Operating System Authentication 1-32
1.6.5 Using Password File Authentication 1-33
1.6.5.1 Preparing to U Password File Authentication 1-33
1.6.5.2 Connecting Using Password File Authentication 1-35
iv
1.7 Creating and Maintaining a Databa Password File 1-36
藏在微笑里的秘密1.7.1 ORAPWD Syntax and Command Line Argument Descriptions 1-36
1.7.2 Creating a Databa Password File with ORAPWD 1-43
好词句
1.7.3 Sharing and Disabling the Databa Password File 1-44
1.7.4 Keeping Administrator Passwords Synchronized with the Data
Dictionary 1-45
1.7.5 Adding Urs to a Databa Password File 1-46
1.7.6 Granting and Revoking Administrative Privileges 1-47
1.7.7 Viewing Databa Password File Members 1-48
1.7.8 Removing a Databa Password File 1-48
1.8 Data Utilities 1-49
2 Creating and Configuring an Oracle Databa
2.1 About Creating an Oracle Databa 2-2
2.2 Considerations Before Creating the Databa 2-3
2.2.1 Planning for Databa Creation 2-3
2.2.2 About Selecting a Character Set 2-5
2.2.3 About Configuring an Oracle Home in Read-Only Mode 2-6
2.2.4 Prerequisites for Databa Creation 2-7
2.3 Creating a Databa with DBCA 2-7
2.3.1 About Creating a Databa with DBCA 2-8
2.3.2 About Creating a Databa with Interactive DBCA 2-8
2.3.3 About Creating a Databa with Noninteractive/Silent DBCA 2-8
2.4 Creating a Databa with the CREATE DATABASE Statement 2-8
2.4.1 About Creating a Databa with the CREATE DATABASE Statement 2-10 2.4.2 Step 1: Specify an Instance Identifier (SID) 2-11
2.4.3 Step 2: Ensure That the Required Environment Variables Are Set 2-12
烧肥肠的家常做法
2.4.4 Step 3: Choo a Databa Administrator Authentication Method 2-12 2.4.5 Step 4: Create the Initialization Parameter File 2-13
2.4.6 Step 5: (Windows Only) Create an Instance 2-14
2.4.7 Step 6: Connect to the Instance 2-14
2.4.8 Step 7: Create a Server Parameter File 2-15
2.4.9 Step 8: Start the Instance 2-16
2.4.10 Step 9: Issue the CREATE DATABASE Statement 2-17
2.4.11 Step 10: Create Additional Tablespaces 2-20鼻孔大怎么办
2.4.12 Step 11: Run Scripts to Build Data Dictionary Views 2-21
2.4.13 Step 12: (Optional) Run Scripts to Install Additional Options 2-22
2.4.14 Step 13: Back Up the Databa 2-22
2.4.15 Step 14: (Optional) Enable Automatic Instance Startup 2-23
2.5 Specifying CREATE DATABASE Statement Claus 2-23
2.5.1 About CREATE DATABASE Statement Claus 2-24
v
2.5.2 Protecting Your Databa: Specifying Passwords for SYS and SYSTEM Urs 2-24
2.5.3 Creating a Locally Managed SYSTEM Tablespace 2-25
2.5.4 Specify Data File Attributes for the SYSAUX Tablespace 2-26
2.5.4.1 About the SYSAUX Tablespace 2-26
2.5.5 Using Automatic Undo Management: Creating an Undo Tablespace 2-27 2.5.6 Creating a Default Permanent Tablespace 2-27
2.5.7 Creating a Default Temporary Tablespace 2-28
2.5.8 Specifying Oracle Managed Files at Databa Creation 2-29
2.5.9 Supporting Bigfile Tablespaces During Databa Creation 2-30
2.5.9.1 Specifying the Default Tablespace Type 2-31
2.5.9.2 Overriding the Default Tablespace Type 2-31
2.5.10 Specifying the Databa Time Zone and Time Zone File 2-32
2.5.10.1 Setting the Databa Time Zone 2-32
2.5.10.2 About the Databa Time Zone Files 2-32
2.5.10.3 Specifying the Databa Time Zone File 2-33
2.5.11 Specifying FORCE LOGGING Mode 2-33
2.5.11.1 Using the FORCE LOGGING Clau 2-34
2.5.11.2 Performance Considerations of FORCE LOGGING Mode 2-34
2.6 Specifying Initialization Parameters 2-35
2.6.1 About Initialization Parameters and Initialization Parameter Files 2-36 2.6.1.1 Sample Initialization Parameter File 2-37
2.6.1.2 Text Initialization Parameter File Format 2-38
2.6.2 Determining the Global Databa Name 2-39
2.6.2.1 DB_NAME Initialization Parameter 2-39
2.6.2.2 DB_DOMAIN Initialization Parameter 2-40
2.6.3 Specifying a Fast Recovery Area 2-40
2.6.4 Specifying Control Files 2-41
2.6.5 Specifying Databa Block Sizes 2-41
研究生招生人数2.6.5.1 DB_BLOCK_SIZE Initialization Parameter 2-42
2.6.5.2 Nonstandard Block Sizes 2-42
2.6.6 Specifying the Maximum Number of Process 2-43
2.6.7 Specifying the DDL Lock Timeout 2-43
2.6.8 Specifying the Method of Undo Space Management 2-44
2.6.8.1 UNDO_MANAGEMENT Initialization Parameter 2-45
2.6.8.2 UNDO_TABLESPACE Initialization Parameter 2-45
2.6.9 Specifying the Databa Compatibility Level 2-45
2.6.9.1 About the COMPATIBLE Initialization Parameter 2-46
2.6.10 Setting the Licen Parameter 2-47
2.7 Managing Initialization Parameters Using a Server Parameter File 2-47 2.7.1 What Is a Server Parameter File? 2-48
vi
2.7.2 Migrating to a Server Parameter File 2-49
2.7.3 Server Parameter File Default Names and Locations 2-50
2.7.4 Creating a Server Parameter File 2-51
2.7.5 The SPFILE Initialization Parameter 2-51
2.7.6 Changing Initialization Parameter Values 2-52
2.7.6.1 About Changing Initialization Parameter Values 2-52
2.7.6.2 Setting or Changing Initialization Parameter Values 2-52
2.7.7 Clearing Initialization Parameter Values 2-54
2.7.8 Exporting the Server Parameter File 2-55
2.7.9 Backing Up the Server Parameter File 2-56
2.7.10 Recovering a Lost or Damaged Server Parameter File 2-56
