文档详情

吉林大学大型数据库设计与实现dba-04.ppt

发布:2025-06-11约4.73千字共26页下载文档
文本预览下载声明

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

显示全部
相似文档