Oracle 19C 定制建库 ORCL-ORACLE OCP认证考试.docx

《Oracle 19C 定制建库 ORCL-ORACLE OCP认证考试.docx》由会员分享，可在线阅读，更多相关《Oracle 19C 定制建库 ORCL-ORACLE OCP认证考试.docx（12页珍藏版）》请在第一文库网上搜索。

1、-IQCORAC1IDatabaseDatabaseOperationCreationModeIieIPHextICenCe1一、DB上定制建库Ord定制建库是完全恢复路径:u01apporac1eproduct19.3.0dbhome_2Is以OraC1e用户登录，在grid下启动监听2、配置远程图形界面3、运行dbca,建库，建库过程如下截图：注意查看dbhome路径图DaUbdseConfigurationAssistantCreate,ord*dtabdse-Step1of14Se1ectDatabaseOperationSe1ecttheoperationthatyouwanttop

2、erformCreateadatabaseOConfigureanexistingdatabaseDe1etedatabaseManagetemp1atesManageEIUggdb1edatabasesSe1ectDatabaseCreationModeORAC1DatabaseIDdtdbdseODerdtiOn、CreationModeDeDIoVmentTUDeStorageOptiondatabaseOptionProgresIieIPOTypica1configurationAdvancedconfigurationJV旦ackNeXtICance1CreationMOdeDep1

3、oymentTypeDatabaseIdentifiCAtiOn-IQCORAC1IDatabaseTemp1atenameInc1udedatafi1esDetai1sDataWarehouseYeeMeWdetai1sCustomDatabaseNoVIeWdetai1sGenera1PurposeorTransactionProcessingYesVieWdetai1sTemp1atesthatinc1udedatafi1escontainprcreatddatabases.Theya11owyoutocreateanewdatabasequick1y.Usetemp1ateswitho

4、utdatefi1eson1ywhennecessary,suchaswhenyouneedtochangeattributes1ikeb1ocksizethatcannotbea1teredafterdatabasecreation.国DatabaseConfigurationAssistantCreateadatabase-Step3of14Se1ectDatabaseDep1oymentTypeSe1ectthetypeofdatabaseyouwanttocreate.Databasetype:IOSCIeSingIeInStanCedatabaseCf1nfigurationtype

5、:IAdmmManagCd,Se1ectatemp1ateforyourdatabaseTemp1ate1ocation:u01pporac1eproduct19.3.0dbhome1assistantsdbcaemphChange,tesSpecifyDatabaseIdentificationDetai1sORAC1DatabaseProvideauniquedatabaseIdentifierinformation.AnOrac1edatabaseisunique1yIdentifiedbyaG1oba1databasename,typica11yoftheformname.domain

6、”.iDeO1t)VmentTVDeyDatabaseIdentificationStoraaeODtiOnG1oba1databasename:OrC1nDQJCreateasContainerdatabaseCreateaContainerHoIVRackJNCXtCance1y圄DebaseConfigurationAssistantCreate,orcdtdbseStep5of14Se1ectDatabaseStorageOptionQCORAC1IDatabaseJYI1YcreationModedIDep1oymentTypeTDAtabd8eIdenttfication-Stor

7、ageOptionYFd-tReCOVerVODtiOnUsetemp1ate1efordatabasestorageattributesStoragetypeand1ocationfordatabasefi1eswi11bepickedupfromthespecifiedtemp1ate(CustomDatabase).JUSefo11owingforthedatabasestorageattributesA11thedatabasefi1eswi11beputatthespecified1ocationbe1ow.Youcancustomizethenameand1ocationofeac

8、hdatab1eInthesubsequentscreen.Qatdbasefi1esstoragetype:Databasefi1es1ocation:F1eSystemORAC1JBASE0Qdat*DRUNIQUJNAMEB1OWSe.Orac1eManagedfi1esoptionwi11enab1eOrac1etoautomatica11ygeneratethenamesofthedatafi1esforsimp1ifieddatabasemanagement.Us。Orac1e-ManagedFi1es(OMF)Mu1tip1exredo1ogsandcontro1fi1es.fi

9、1e1ocationvariab1es.Se1ectFastRecoveryOptionCreationModeStOraQeODtiOn,Fa5tRecoveryOptionChoosetherecoveryoptionsforthedatabase3SpecifyfastRecoveryAreaRecoveryfi1esstoragetype:FastRoCOVeryArea:FastRecoveryAreasize:口BnabIearchivingF1eSystemi1E_BftSE/fast_recovery_drea/DB_UNIQUE_NAMEBrOjSSe.I46003W痴Dat

10、abaseODtiOnSIieIPCance1j图Da匕baseConfigurationAssistantCreate,orddatabaseStep7of14SpecifyNetworkConfigurationDetai1s-IQCORAC1IDatabaseCreationModeIUstenerse1ection1istenerfromGridInfrastructurehomeandDatabaseOrac1ehomeare1istedbe1ow.Specifythe1istenernameandporttocreateanew1istenerindatabaseOrac1ehom

11、e.FdStReCoVerVODtionyNetworkConfigurationConfiQUratIonODt1OnSrCredenti.mmaryCreateanew1istenerrport:IQCORAC1IDatabase-IQCORAC1IDatabaseSAsize;1543件Imbu=208PGASize:YStorageOption-1-：MBUseManua1SharedMemoryManagement9d.DatabaseODtIOnSdpooConfigurationOptions1evapoo1size:ManaaementODtionSsize:图Databdse

12、ConfigurationAssistantCreAte,orddatebaseStep8of15Se1ectDatabaseOptionsOotaboseOperationYCrgatiODMode【-Y-TNetWorkCOMiaUratjOn(DatabasecomponentsSe1ectthestandarddatabasecomponentsyouwanttoconfigureforuseinyourdatabase.Orac1erecommendsthatyouo1waysinsta11thesecomponentsinyourdatabase.Dese1ectingthesec

13、omponentsmaycauseyoutono1ongerbeab1etochoosesomecomponentsonthesubsequentpage.Se1ectComponentTab1cspace，Orac1eJVM0Orac1eIextSYSAUXwDatabaseOptions0Orac1eMu1timediaSYSAUX回Orac1eO1APSYSAUXBOrac1eSpatia1.SYSAUX口Orac1e1abe1SecurityOrac1efipp1icotioExpressOrac1eDatabaseVau1tCOnfiaUQtiOnOptionsYManagement

14、OptionsUserCredentia1sYCrcdtionvpcoYSurtyYProgressPGgej*FinishV班CkjHextCance1j图DatabaseConfigurationAssistantCreate,ordC1A匕baseStep9of15SpecifyConfigurationOptionsMemoryS2ingCharactersetsConnectionmodeSampschemaseationMode，USeAutomaticSharedMemoryManagementUseAutomaticMemoryManagement3906304=40%15760SpecifyConfigurationOptionsYCreationModeYDeP1OymentTypeYDatabaseIdentificationYStorageOptionYFd$tRecoveryOptionYNetworkConfigurationTDatabaseODtiOn$vConfiguration