吉林大学大型数据库设计与实现dba-04.ppt
CreatingaDatabase
ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:UnderstandtheprerequisitesnecessaryfordatabasecreationCreateadatabaseusingOracleDatabaseConfigurationAssistantCreateadatabasemanually
ManagingandOrganizingaDatabaseCreatingadatabaseisthefirststepinmanagingadatabasesystemAdatabasemayhavebeencreatedautomaticallyaspartofOracle9iServerinstallation,oryoucancreateanewonelaterOracleDataMigrationAssistantisusedtomigratefromanearlierversionofthedatabase
CreationPrerequisitesTocreateanewdatabase,youmusthavethefollowing:Aprivilegedaccountauthenticatedinoneofthefollowingways:BytheoperatingsystemUsingapasswordfileSufficientmemorytostarttheinstanceSufficientdiskspacefortheplanneddatabase
PlanningDatabaseFileLocationsKeepatleasttwoactivecopiesofadatabasecontrolfileonatleasttwodifferentdevices.Multiplextheredologfilesandputgroupmembersondifferentdisks.Separatedatafileswhosedata:WillparticipateindiskresourcecontentionacrossdifferentphysicaldiskresourcesHavedifferentlifespansHavedifferentadministrativecharacteristics
CreatingaDatabaseAnOracledatabasecanbecreatedusing:OracleDatabaseConfigurationAssistantTheCREATEDATABASEcommand
OperatingSystemEnvironmentOnUnix,setthefollowingenvironmentvariables:ORACLE_BASEORACLE_HOMEORACLE_SIDORA_NLS33PATHLD_LIBRARY_PATH
UsingtheDatabaseConfigurationAssistantTheDatabaseConfigurationAssistantallowsyouto:CreateadatabaseConfiguredatabaseoptionsDeleteadatabaseManagetemplatesCreatenewtemplateusingpre-definedtemplatesettingsCreatenewtemplatefromanexistingdatabaseDeletedatabasetemplate
CreateaDatabase
DatabaseInformationSpecify:GlobaldatabasenameandSIDThefeaturesyouwanttouseforyourdatabase,suchas:OracleSpatialOracleOLAPServicesExampleSchemasModeinwhichyouwantthedatabasetoopera