ocm官方文档

OracleDatabase10g:OCMEXamPreparationActivityGuide Contents OracleEnterpriseManager10gGridControlEd2 PracticesforChapter2:DeployingtheOracleManagementAgent (EM10gGridControlEd2-Chapter4 PracticeSolutionsforChapter2:DeployingtheOracleManagementAgent (EM10gGridControlEd2-Chapter4) PracticesforChapter3:JobSystem 18 (EM10gGridControlEd2-Chapter14) PracticeSolutionsforchapter3Jobsystem 22 (EM10gGridControlEd2-Chapter14) OracleDatabase10g:PerformanceTuningEd1.1 PracticesforChapter4:UsingStatspack 48 (10gPerformanceTuningEd1.1-Chapter5 PracticeSolutionsforChapter4:UsingStatspack 52 (10gPerformanceTuningEd1.1-Chapter5) PracticesforChapter5:UsingAutomaticWorkloadRepository 70 (10gPerformanceTuningEd1.1-Chapter6) PracticeSolutionsforChapter5:UsingAutomaticWorkloadRepository 72 (10gPerformanceTuningEd1.1-Chapter6) PracticesforChapter6:TuningtheSharedPool............,…,………103 (10gPerformanceTuningEd1.1-Chapter8 PracticeSolutionsforChapter6:TuningtheSharedPoc....….….…… .107 (10gPerformanceTuningEd1.1-Chapter8 PracticesforChapter7:AutomaticSharedMemoryManagement .131 (10gPerformanceTuningEd1.1-Chapter10 PracticeSolutionsforChapter7:AutomaticSharedMemorymanagement 134 (10gPerformanceTuningEd1.1-Chapter10 (1 gPerformanceTuningEd11-Chapter1“…154 PracticesforChapter8:TuningPGaandTemporarySpace……… PracticeSolutionsforChapter8:TuningPGAandTemporarySpace 158 (10gPerformanceTuningEd1.1-Chapter13 OracleDatabase10g:OCMEXamPreparationActivityGuide OracleDatabase10g:SQLTuningEd2 PracticesforChapter9:GatheringStatistics 178 (10gSQLTuningEd2-Chapter7) PracticeSolutionsforChapter9:GatheringStatistics 179 (10gSQLTuningEd2-Chapter7) OracleDatabase10g:RACforAdministratorsEd2 PracticesforChapter11:OracleClusterwareInstallationandConfiguration 185 (10gRACforAdminEd2-Chapter1) PracticeSolutionsforChapter11:OracleClusterwareInstallationandConfiguration 187 (10gRACforAdminEd2-Chapter1) PracticesforChapter12:RACSoftwareInstallation .212 (10gRACforAdminEd2-Chapter2) PracticeSolutionsforChapter12:RACSoftwareInstallation 国画面 215 (10gRACforAdminEd2-Chapter2) PracticesforChapter13:RACDatabasecreation ∴236 (10gRACforAdminEd2-Chapter3) PracticeSolutionsforChapter13:RACDatabaseCreation 239 (10gRACforAdminEd2-Chapter3 PracticesforChapter14:Services 275 (10gRACforAdminEd2-Chapter7 PracticeSolutionsforChapter14:Services 279 (10gRACforAdminEd2-Chapter7) OracleDatabase10g:DataGuardAdministrationEd2 PracticesforChapter15:Creatingaconfigurationandphysicalstandbydatabase 339 (10gDataGuardAdminEd2-Chapter4 PracticesforChapter16:ConfiguringDataProtectionModesandRedoTransportServices........342 (10gDataGuardAdminEd2-Chapter6) PracticesforChapter17:CreatingaLogicalStandbyDatabasebyUsingEnterpriseManager..343 (10gDataGuardAdminEd2-Chapter7) PracticesforChapter18:PerformingSwitchoverandFailover 345 (10gDataGuardAdminEd2-Chapter9 OracleDatabase10g:securityed2 PracticesforChapter20:UsingApplicationContexts 347 (10gSecurityEd2-Chapter11) OracleDatabase10g:OCMEXamPreparationActivityGuide PracticeSolutionsforChapter20:UsingApplicationContexts 350 (10gSecurityEd2-Chapter11) PracticesforChapter21:ImplementingFine-GrainedAccessControl 358 (10gSecurityEd2-Chapter12) PracticeSolutionsforChapter21:ImplementingFine-GrainedAccessControl 360 (10gSecurityEd2-Chapter12) OracleDatabase10g:ImplementandAdministeraDataWarehouse PracticesforChapter22:ParalleloperationsindataWarehouses 365 (10gImplementandAdministeraDataWarehouse-Chapter8) PracticeSolutionsforChapter22:ParallelOperationsinDataWarehouses 368 (10gImplementandAdministeraDataWarehouse-Chapter8 OracleDatabase10g:DevelopPL/SQLProgramUnitsEd2 PracticesforChapter23:ManipulatingLargeObjects 378 (10gDevelopPL/SQLProgramUnitsEd2-Chapter9 PracticeSolutionsforChapter23:ManipulatingLargeObjects 379 (10gDevelopPL/sQLProgramUnitsEd2-Chapter9 OracleDatabase10g:OCMEXamPreparationActivityGuide PracticesforChapter2:DeployingtheOracleManagementAgent (EM10gGridControlEd2-Chapter4) OracleEnterpriseManager10gGridControlA-11 Practice4-1:DeployingtheManagementAgent Inordertobeginmonitoringyourtargets,youneedtodeploythemanagementAgent.In thelesson,youlearnedthatthereareseveralmethodsavailablefordeployingtheagent Themethodthispracticeisgoingtouseistoinstalltheagentusingalocallystagedcopy ofthegridControlsoftware.Thereareviewletsavailabletoshowdeployingtheagent usingagentdownloadandthencwagentdeployapplication 1)Onyourhost,youfindthestagedsoftwareinthe /modules/stage/gridctlr2/DiskldirectoryLaunchtheInstallerand choosetheAdditionalManagementAgentoption.Fortheinstallationlocation,use /uol/app/oracleastheparentdirectoryFortheManagementServiceHost Name,usethefullyqualifiedname(includingdomain)ofthemanagementserver hostfortheclassroom.LeavetheManagementServiceportas4889.TheAgent Registrationpasswordisoraclel.Afterenteringtherequiredinformation,click Install OracleEnterpriseManager10gGridControlA-12 Practice4-2:ConfiguringYourDatabase Nowthatthemanagementagenthasbeendeployedtoyourtargetsyouneedto decidedtoperformindividualAgentDeploystoyourmachines,thestudentattheou configuremonitoringcredentialsforyourdatabase.Ifyouandthestudentnexttoyo machinewiththe10gApplicationServerwillskipthisstep 1)LogintotheGridControlconsoleasthesysmanusergotothetargetstaband findyour10gdatabasctarget.Notcthatonthedatabasessubtab,yourdatabasc's Statusisunavailable.ThisisbecauseGridControldoesnothavemonitoring credentialsconfiguredyetforthisdatabase.Thisinvolvessettingthemonitor passwordforthedbsnmpuseronyourdatabasetotheappropriatevalueinthiscase oracle.SelectyourdatabaseandthenclickConfiguretocompletethe configurationtask OracleEnterpriseManager10gGridControlA-13 Practice4-3:GridControlCaseStudy NowthatyouhavelearnedmoreaboutthedeploymentoptionsforGridControl,update thecasestudyyoustartedbackinthelessontitled"Gridcontrolarchitecture"toinclude someofthetopicslearnedinthislesson.Thiscanbeintheformofdiagramsornotes whateverisbestforyou.Thisisagoodopportunitytousetheconceptsyouarelearning hereintopracticaluscSomcconsiderationsmightinvolvcthefollowing 1)Howtodeploytheagent? 2)CanImakeanychangestothearchitecturetomakeGridControlmorehighly available? 3)WhatsecurityoptionswillIwant/need? OracleEnterpriseManager10gGridControlA-14