oracle ocp Less03_DB_DBCA_MB3

Copyright©2005,Oracle.Allrightsreserved.CreatinganOracleDatabase3-2Copyright©2005,Oracle.Allrightsreserved.ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:•CreateadatabasewiththeDatabaseConfigurationAssistant(DBCA)•CreateadatabasedesigntemplatewiththeDBCA•GeneratedatabasecreationscriptswiththeDBCA3-3Copyright©2005,Oracle.Allrightsreserved.PlanningtheDatabaseAsaDBA,youmustplan:•Thelogicalstoragestructureofthedatabaseanditsphysicalimplementation:–Howmanydiskdrivesdoyouhaveforthis?–Howmanydatafileswillyouneed?(Planforgrowth.)–Howmanytablespaceswillyouuse?–Whichtypeofinformationwillbestored?–Arethereanyspecialstoragerequirementsduetotypeorsize?•Theoveralldatabasedesign•Abackupstrategyforthedatabase3-4Copyright©2005,Oracle.Allrightsreserved.Databases:Examples•DataWarehouse:–Researchandmarketingdata–Stateorfederaltaxpayments–Professionallicensing(doctors,nurses,andsoon)•TransactionProcessing:–Storecheckoutregistersystem–Automatictellermachine(ATM)transactions•GeneralPurpose:–Retailbillingsystem,forexample,ofasoftwarehouseoranursery3-5Copyright©2005,Oracle.Allrightsreserved.DatabaseConfigurationAssistant(DBCA)3-6Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabase3-7Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabase343-8Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabase5673-9Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabase893-10Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabaseAB103-11Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoCreateaDatabase11123-12Copyright©2005,Oracle.Allrightsreserved.PasswordManagementABC3-13Copyright©2005,Oracle.Allrightsreserved.CreatingaDatabaseDesignTemplate3-14Copyright©2005,Oracle.Allrightsreserved.UsingtheDBCAtoDeleteaDatabase3123-16Copyright©2005,Oracle.Allrightsreserved.SummaryInthislesson,youshouldhavelearnedhowtousetheDBCAto:•Createadatabase•Createadatabasedesigntemplate•Generatedatabasecreationscripts3-17Copyright©2005,Oracle.Allrightsreserved.PracticeOverview:UsingtheDBCAThispracticecoversthefollowingtopics:•CreatingtheORCLdatabasebyusingtheDBCA•UnlockingtheHRschemaNote:CompletingthedatabasecreationandunlockingtheHRschemaiscriticalforallfollowingpracticesessions.Optionally:•CreatingtheORCLdatabasedesigntemplatebyusingtheDBCA•CreatingdatabasecreationscriptswiththeDBCA