Oracle管理员用户指南.docx

?

?

Oracleadministrator’sguide

?

?

administrator’s?guide

PartIBasicDatabaseAdministration

1GettingStartedwithDatabaseAdministration

1.1TypesofOracleDatabaseUsers

1.1.1DatabaseAdministrators

1.1.2SecurityOfficers

1.1.3NetworkAdministrators

1.1.4ApplicationDevelopers

1.1.5ApplicationAdministrators

1.1.6DatabaseUsers

1.2TasksofaDatabaseAdministrator

1.2.1Task1:EvaluatetheDatabaseServerHardware

1.2.2Task2:InstalltheOracleDatabaseSoftware

1.2.3Task3:PlantheDatabase

1.2.4Task4:CreateandOpentheDatabase

1.2.5Task5:BackUptheDatabase

1.2.6Task6:EnrollSystemUsers

1.2.7Task7:ImplementtheDatabaseDesign

1.2.8Task8:BackUptheFullyFunctionalDatabase

1.2.9Task9:TuneDatabasePerformance

1.2.10Task10:DownloadandInstallReleaseUpdatesandReleaseUpdateRevisions

1.2.11Task11:RollOuttoAdditionalHosts

1.3SQLStatements

1.3.1SubmittingCommandsandSQLtotheDatabase

1.3.2AboutSQL*Plus

1.3.3ConnectingtotheDatabasewithSQL*Plus

1.3.3.1AboutConnectingtotheDatabasewithSQL*Plus

1.3.3.2Step1:OpenaCommandWindow

1.3.3.3Step2:SetOperatingSystemEnvironmentVariables

1.3.3.4Step3:StartSQL*Plus

1.3.3.5Step4:SubmittheSQL*PlusCONNECTCommand

1.3.3.5.1SyntaxoftheSQL*PlusCONNECTCommand

1.4IdentifyingYourOracleDatabaseSoftwareRelease

1.4.1AboutOracleDatabaseReleaseNumbers

1.4.2CheckingYourCurrentReleaseNumber

1.5AboutDatabaseAdministratorSecurityandPrivileges

1.5.1TheDatabaseAdministratorsOperatingSystemAccount

1.5.2AdministrativeUserAccounts

1.5.2.1AboutAdministrativeUserAccounts

1.5.2.2SYS

1.5.2.3SYSTEM

1.5.2.4SYSBACKUP,SYSDG,SYSKM,andSYSRAC

1.5.2.5TheDBARole

1.6DatabaseAdministratorAuthentication

1.6.1AdministrativePrivileges

1.6.2OperationsAuthorizedbyAdministrativePrivileges

1.6.3AuthenticationMethodsforDatabaseAdministrators

1.6.3.1AboutAuthenticationMethodsforDatabaseAdministrators