ocm2016之腾科11gocm sec0专业专注超越

-OracleCertifiedMaster(OCM)11g参加OCMEverycandidatemusthavetheir9-characterOracleTestingIDtoinitiatetheOCMCompletePRIORCERTIFICATION:OCP-OracleDatabase11g(or12c)AdministratorCertifiedCompletetheAdvancedorSpecialtycoursestomeettheHandsOnCourse 回访、培训教学50WPM /或金山打字软 OracleLinuxRelease5.4(32-OracleDatabase11gEnterpriseEditionRelease.0(32-OracleEnterpriseManager11gGridControlRelease1(.0)(32-考试评分准则(ExamScoringExamPassingOracleroutinelypublishesnewversionsofitsOracleCertificationexams.Thepassingscoreforeachexamversionissettlytomaintainaconsistentscoringstandardacrossversions.Forexample,tomaintainaconsistentstandardforsuccess,anewversionofanexamwhichcontainsmoredifficultquestionsthanthepriorversionwillbeassignedasomewhatlowerrequiredpassingscore.Forthisreason,passingscoresmayvarybetweendifferentexamsinyourcertificationtrack,andbetweenla ndearlierversionsofthesameexam.Oracledoesnot mendanexampreparationstrategytargetingthepassingscore,aspassingscoresaresubjecttochangewithoutnotice.ScoredandUnscoredYourex ycontainunscoredquestionsinadditiontothescoredquestions,sothetotalnumberofquestionsthatarepresentedtoyoumaybegreaterthanthenumbershownontheexampage.Thisisstandardtestingpractice.Youwillnotknowwhichquestionsareunscored.Ifyourexamcontainsunscoredquestions,thetimeallowedfortheexamtakesintoconsiderationthetimeyouwillneedtoanswerallquestionsandreviewyourwork.Yourexamresultswillreflectyourperformanceonthescoredquestionsonly.Participantsarescoredontheirabilitytocompleteassignedtasksandtorecoverfromvariousdatabasefailurescenarios.Datafromeachparticipanvironmentiscollectedatofeachscenarioandusedtodetermhefinalscore.Insomescenarios,participantsmayreceivepartialcredit,howevertheinabilitytorecoverfromafailurescenarioresultsinzerocreditforanentirescenario.Theproctorisnotresponsibleforscoringtheexamandwillnothavescoringinformationduringthe世界公认的OCM、OCM名片、OCM服可申请载入Oracle官网11gOCM大师名册(/education/otn/ocm-OCMOCM11g1Server[]Createthe[]Determineandsetsizingparametersfordatabase[]Createandmanagetemporary,permanent,andundo[]Stripedatafilesacrossmultiplephysicaldevicesand[]Configurethedatabaseenvironmenttosupportoptimaldataaccess[]Createandmanagedatabaseconfiguration[]Createandmanagebigfile[]CreateandManageatablespacethatusesNFSmountedfilesystem[]Createandmanagemultiplworkconfiguration[]Createandconfigurea[]Configurethedatabaseinstancetosupportsharedserver[]Setuwork[]ManageOraclwork[]Configurethworkenvironmenttoallowconnectionstomultiple[]Useconfigurationless[]UseOPatchtoinstalla[]UseGridInfrastructuretomanageoracledatabasesandother[]UseEnterpriseManagerConfigurationAssistant(EMCA)2EnterpriseManagerGrid[]InstallandPatchEnterpriseManagerGridControl[]ConfiguretheEnterpriseManager[]CreateEnterpriseManagerGridControl[]UseEnterpriseManagertomodifyadatabase[]ConfigureEnterpriseManagertomodifydatabase[]Createandmanage[]Createandmonitor[]Create[]ImplementGridControlandDatabase[]Choosetheappropriatetablespacetypefortheintended[]CreateScheduler[]Create[]Assignjobsto[]Create[]Createjob[]2.16InstalltheEnterpriseManagerGridControlinfrastructure[]2.17DeployEnterpriseManagerGridControlagents[]2.18ConfigureGridControlforbusinessManagingDatabaseAvailability[]3.1Mantainrecoverycatalogs[]3.2ConfigureRecovery[]3.3UseRecoveryManagertoperformdatabase[]3.4UseRecoverManagertoperformcompletedatabaserestoreandrecoveryoperations[]3.5ConfigureRMAN[]3.6CreatedifferenttypesofRMANbackupstocaterfordifferentperformanceandretentionrequirements[]3.7SetFlashbackDatabaseparameters[]3.8ConfigureaFastRecoveryArea[]3.9PerformvariousrecoveryoperationsusingFlashbackData[]4.1ManageMaterializedViewstoimproverewriteandrefreshperformance[]4.2Configureandmanagedistributedmaterializedviews[]4.3CreateandManageencrypted[]4.4ManageTransportoftablespacesacross[]4.5Configureaschematosupportastartransformationquery[]4.6Administerexternaltables[]4.7ImplementDataPumpexportandimportjobsfordatatransfer[]4.8ImplementDataPumptoandfromremotedatabases[]4.9Configureanduseparallelexecutionforqueries[]4.10UseSQL*Loader[]4.11Administer,manageandtuneparallelDataWarehouse[]5.1Administerpartitionedtablesandindexesusingappropriatemethodsandkeys[]5.2Performpartitionmaintenanceoperations[]5.3Maintainindexesonapartitionedtable[]5.4ImplementsecurefileLOB[]5.5CreateandmanageLOB[]5.6Implementfine-grainedaccesscontrol[]5.7Createandmanagecontexts[]5.8Administerflashbackdataarchiveandschema Performance[]6.1AdministerResource[]6.2UseResult[]6.3Usemulticolumn[]6.4Gatherstatisticsonaspecifictablewithoutinvalidating[]6.5Usepartitioned[]6.6 ndtuneschemaobjecttosupportvariousaccess[]6.7Interpretexecution[]6.8UseSQLtuningtoolsand[]6.9UseSQLTuning[]6.10UseSQLAccess[]6.11UseSQLPerformance[]6.12Configurebaselem[]6.13UseSQLnManagement[]6.14Implementinstance GridInfrastructureand[]7.1InstallOracleGrid[]7.2CreateASMDisk[]7.3CreateandmanageasASM[]7.4ImplementASMfailure[]7.5CreatingACFSFile[]7.6Start,stop,configureandadministerOracleGrid RealApplication[]8.1InstalltheOracleDatabase11gR2[]8.2ConfigureASMfortheshareddisksandcreateaclustered[]8.3Configure[]8.4ConfigureservicesusingbothandManaged Data[]9.1CreatePhysicalStandbyDatabasewithreal-time[]9.2Configurethedataguardenvironmenttoreduceoverheadsoffastrementalontheprimary[]9.3Configurethe[]9.4Switchoverandswitch[]9.5Configureconnecttime[]9.6Convertthestandbytoasnapshot[]9.7Configurearchivelog fortheDataguard-CreateVirtualInVMware->File->NewVirtualSection->SectionHardwareCompatibility="Workstation10.0"->"Installerdiscimage"Installerdiscimagefile(iso)":Enterprise-R5-U4-Server-i386-VirtualMachinename=andLocationVirtualMachinename=Numberofprocessors=1,Numberofcoresperprocessor=1->Memory=Memory=2048workConnectionworkConnection"NAT"(or"Bridged"/"HostSelect"LSILogic mended)"->Select"Createanewvirtualdisk"->umdisksize(GB)="Splitumdisksize(GB)="Splitvirtualdiskintomultipleand ->DiskFile="ODD.vmdk"->Remove"Floppy","Printer","SoundCard","USBClickRemove"Floppy","Printer","SoundCard","USBClick"Close"->ClickTheVMhoststarts,andtheOracleLinux will-InstallationOracleLinuxStarttheVMhostPressthe"Enter"Clickon"Skip"(Idon'twanttocheckusClickSelectlanguage"English(English)"->Keyboard"English"->Awarningmessageappearstoinitializethesdadevice->Select"Createcustomlayout."->AddthefollowingClick"new"->FileSystemType:"swap,"Size(MB):Click"new"->MountPoint:"/",FileSystemType:"ext3",select"Fillto umallowableClickLeavedefaultbootsettings->ClickConfigureth workdevice.（192.168.12.xxx/）Click"Edit"configuration->IPAddress="0,mask)="Deselect"EnableIPv6Hostname= MiscellaneousSettings-Gateway="",PrimaryDNSClickincity(e.g.)->ClickEnterRootPassword(e.g.)->ClickClickCustomize"->ClickSelectthefollowingadditionalBaseSystem->SystemTools->OptionalPackages->Select"oracle-validated-..."->ClickClick"Next"tobegintheClick"Reboot"tofinishtheClickthebottombuttonofVMware"IfinishedinstallingtheClick"Forward",select"Yes,IagreetotheLicenseAgreement"->Click

DisableDisableSELinuxDisableFirewallDonotselectKdump->ClickSetthecorrectlocaltime->

->Click"Forward"->inthewindowofwarningClick->Click"Forward"->inthewindowofwarningClick"Yes"ClickClick"Forward"(noneedtomodifythesettingsofthesoundClick"Finish"->confirmbyclickingIntheVMware,ClickVM->Click"InstallVMwareLoginthehostIntheVMware,ClickVM->Click"InstallVMwareOpenaterminal,Click"Applications"->Click"Accessories"->ClickRunthefollowingcommandstoinstallcp/media/VMWARE\Tools/VMwareTools-*.tar.gztar-zxvfVMwareTools-*.tar.gzcdvmware-tools-distribClick"Enter"..."Enter"->Enter3[1024xShutdowntheVMhost,Click"System"->Click"ShutDown..."->Click"ShutSettheVMsettings->Options->VMwareTools->Select"Synchronizeguesttimewith->ClickRestartVMhost,loginasrootandsettheX11Monitorand yto（可选）关闭无用的Linux(as#servicesendmail[OK[OK#servicesendmailShuttingdownsm-:Shuttingdownsendmail:#chkconfigsendmail#chkconfig-- #vi#vi##init#shutdown-h常用Linuxlinuxuname-auname-cat/etc/redhat-releaseidtail-n<N>-f$tail-n20-f/u01/app/oracle/diag/rdbms/prod1/PROD1/trace/alter_PROD1.log altersystemswitchlogfile;df-du-h-netstat-ps-ef|grepXXXenv|grepORAecho$PATHlocatefind<path_dir>-name-InstallationSoftwareOracleDatabaseInstallationGuidefor加载OracleLinux5.4DVDClick"VM"->->Click"Settings"-->Click"CD/DVD(IDE)"-->ClickBrowse-->SelecttheISO"Enterprise-R5-U4-Server-i386-dvd.iso"-->Click"OK"-->Click"Connected"-->ClickRPMpackagesascd/media/Enterprise\Linux\ rpm-Uvhlibaio-devel-0.3.106-rpm-Uvhlibstdc++44-devel-4.4.0-rpm-Uvhsysstat-7.0.2-rpm-UvhunixODBC-2.2.11-rpm-UvhunixODBC-devel-2.2.11-/usr/sbin/groupadd-g502/usr/sbin/groupadd-g502/usr/sbin/groupadd-g503/usr/sbin/groupadd-g504/usr/sbin/groupadd-g505/usr/sbin/usermod-a-Goper,asmadmin,asmoper,asmdbapasswd--Passwordoftheuser--Afteroraclepreinstallation,thegroupoinstall,dbaanduseroraclewillbeetc/security/limits.confasvivioraclesoftnprocoraclehardnprocoraclesoftnofileoraclesoftstackoraclehardnofileoffile(Thesesettingswillbesetby--Addthefollowinglinesvifs.aio-max-nrfs.file-maxvifs.aio-max-nrfs.file-maxkernel.shmallkernel.shmmaxkernel.shmmni=kernel.sem=25032000100net.ipv4.ip_local_port_range=9000net.core.rmem_default=net.core.rmem_maxnet.core.wmem_default=net.core.wmem_max/sbin/sysctl-#vi--Addthefollowingshmfs/dev/shmtmpfssize=2gmkdir-pmkdir-pmkdir-pchown-Roracle:oinstallod-R775mkdir-pchown-Roracle:oinstallod-R775（可选）设置oracle--AddthefollowinglinestothefileexportexportexportexportPS1='[\u@\h-$ORACLE_SID\W]\\$DownloadandcopytheinstallfilestotheVMhost.(WinSCP工具) _112030_LINUX_1of7.zip->/stage _112030_LINUX_2of7.zip->/stage _112030_LINUX_6of7.zip->Unzipsoftwarewiththeoracleuseranddeletecompressed-un