Oracle DBA Checklists Pocket Reference

《Oracle DBA Checklists Pocket Reference》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、OracleDBAChecklistsPocketReferenceBeijing•Cambridge•Farnham•Köln•Paris•Sebastopol•Taipei•TokyoTableofContentsIntroductionDatabaseManagementPerformingRoutineDBAProceduresPreparingaDatabaseforProductionPerformingBackupandRecoveryInstallationandConfigurationInstallingOracleonUnixI

2、nstallingOracleonWindowsNTInstallingOracleonVMSCreatingaParallelOracleDatabaseNetworkManagementConfirmingNetworkAvailabilityConfirmingNet8ConnectivityVerifyingNet8NameResolutionConfiguringNet8ClientsConfiguringNet8ClientstoUseLDAPConfiguringNet8ClientstoUseOracleNamesConfigurin

3、gNet8ontheServerConfiguringMulti-ThreadedServerTracingClientConnectionsTracingtheListenerOracleDBAChecklistsPocketReferenceIntroductionThepurposeoftheOracleDBAChecklistsPocketReferenceistohelpOracleDBAsquicklylookuptheproceduresthey’llneedtofollowwhenperformingkeyOracledata-bas

4、eadministrationtasks.ThisbookisdividedintothreemajorsectionscoveringthethreemainareasofanOracleDBA’sresponsibilities:data-basemanagement,installationandconfiguration,andnetworkmanagement.Whilewecan’tpossiblycovereveryDBAtaskinthisconcisereference,we’vehighlightedthemostimportan

5、ttaskswithineachofthesethreefundamen-talareas.TheinformationpresentedhereshouldbehelpfultobothnewandexperiencedDBAs.Eachsectiontakesa“cookbook”orchecklist-styleapproachtopresentingthematerial.OurgoalistomakethemostimportantDBAinformationasaccessibleasitcanbesoyou’llbeabletousei

6、tmosteffectivelyinyourdailywork.Whilewe’vedesignedthestepstobeeasytofollow,pleasenotethatthisbookisnotaself-containeduserguide;basicknowledgeofOracle,SQL,andSQL*Plusisassumed.YouwillneedtorefertoOracledocumentationandotherthird-partybooksfordetailedinformation.Inaddition,everyO

7、raclesitehasitsownspecialprocedures.You’llneedtosupplementtheproceduresdescribedinthisbookandintheOracledocumentationwithyourownsite’sprocedures.1ConventionsThefollowingtypographicalconventionsareusedinthisbook:ItalicUsedforfilenames,directorynames,andURLsConstantwidthUsedforco

8、deexamplesandtheoutputofcommandsConstantwidthitalicInd