Oracle 19C 模板建库 EMREP-ORACLE OCP认证考试.docx

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

1、模板建库是不完全恢复Is以OraC1e用户登录，检查监听是否启动，如果没有启动，在$0RAC1E_H0MEybin目录下，执行Isnrct1start启动监听2、配置远程图形界面3、运行dbca,建库，建库过程如下截图：DatabaseConfigurationAssistantManagetemp1ates-Step1of6Se1ectDatabaseOperationIQCORAC1IDDatabaseDatabaseOperationTemDIdteM&naaementSe1ecttheoperationthatyouwanttoperform.Mdndgetemp1ates选择新建da

2、tabaseSe1ectDatabaseCreationModeWCORAC1,DatabaseIypica1configurationDatabaseODeratiOnCreationModeDeo1ovmentTvDeDatabaseFaStRecovejstratrePaSSw1,0CreateP1uggabi,AdyancedconfigurationIie1PYYrrecoveryupcescOptionsConfirmpassword:DBJJNQUEJ4AMEIV班CkHNeXtI选择自定义图DatabaseConfigurationAssistant-Create*orddat

3、abase-Step3of14Se1ectDatabaseDep1oymentTypeTCreAt1onMOdeDep1oymentType；DatabaseIdem1fiCationFastRecoveryOptionYDatabaseOptionsConfigurationOptionsYM02mentOsYUserCredentia1sYCrcdtionOptionSummaryICOnCe1WCORAC1,DatabaseSe1ectthetypeofdatabaseyouwanttocreatePatdbdSetype.Orac1eSing1eInstancedatabaseConf

4、igurationtpe:iManaQedSe1ectatemp1ateforyourdatabase.ITemp1atenameIInc1udedatafi1esDetai1sDataWarehouseYesVieWdetai1sCustomDatabaseNoVIeWdetti1s。Genera1PurposeorTransactionProcessingYesVIeWdetai1sTemp1atesthatinc1udedatafi1escontainprecreatcddatabases.Theya11owyoutocreateanewdatabasequick1y.Usetempht

5、eswithoutdatafi1eson1ywhennecessary,suchaswhenyouneedtochangeattributes1ikeb1ocksizethatCannotbea1teredafterdatabasecreation.Temp1ate1ocation：u01apporac1eproduct19.30dbhom-1assitantdbcarnp1atee选择DataWarehouse图DtbseConfigurationAssistant-Createorddatabase-Step4of14SpecifyDatabaseIdentificationDetai1s

6、-WCORAC1DatabaseProvideauniquedatabaseidentifierinformation.AnOrac1edatabaseisunique1yidentifiedbyaG1oba1databasename,typica11yoftheformname.domain”.rTiTDeD1OVnWntTvDeDatabaseIdentificationStorAQBODtionG1oba1databasenameemrepCreateasContainerdatabase0USe1oc4OaeatedCreateaSe1ectDatabaseStorageOption1

7、DatdbdSeIdenbfiCatiOnIV艮kIHeXt)ICarKe1)输入实例名图DatabaseConfigurationAssistantCreate,mrep,databaseStep5of14QCORAC1,IVDatabaseyStorageOptionFtRftfrtvftrvOntinOUSetemp1atefi1efordatabasestorageattributesStoragetypeand1ocationfordatabasefi1eswi11bepickedupfromthespecifiedtemp1ate(DataWarehouse).JUsefo11ow

8、ingforthedatabasestorageattributesA11thedatabasefi1eswi11beputatthespecified1ocationbe1ow.Youcancustomizethenameand1ocationofeachdata1eInthesubsequentscreen.Databasefi1esstoragetype:esystemFDatabasefi1es1ocation:ORCXtICanCe1选择闪回区，指定闪回区大小图DatabaseConfigurationAssistantCreAteemrep,databaseStep7of14Spe

9、cifyNetworkConfigurationDetai1s-IQCORAC1IDatabaseCYFdfReCOVerVODtiOnJTHHCanCe1!Memoryn必ngCharactersetsCfinnect1onmodeMIieIP配置数据库可使用的内存，SGA、PGADdtbaseConfigurationAssistantCreate,mrep,databaseStep9of15SpecifyConfigurationOptions-XIQCORAC1IDatabaseDatabaseIdentificationStOrageOptionNetworkConfiguratio

10、nDataVaUitODtiOnConfigurationOptionsManaaeEentODtiOnSMemorySizingCharactersetsConnectionmodeSampschemasAb1ockisthsma11estunitofstoragefora11ocationandforI/O.Itcannotbechangedoncethedatabaseiscreated.Specifythemaximumnumberofoperatingsystemuserprocessesthatcanbesimu1taneous1yconnectedtothisdatabase.T

11、heva1ueofthisparameterinc1udestheuserprocessesandthOrac1ebackgroundprocesses.Processes:pB配置并发连接数SpecifyConfigurationOptionsTDataVaUItODttOnvConfigurationOptionsManaqementODtiOnSIJTrcIf11(茂1(KIjePIMemorySzigCharactersets,ConnectionmodeSdmP1eschemasThedatabasecharactersetdetermineshowcharacterdataisstoredinthedatabase.Us