常用的DBA工具

《常用的DBA工具》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、常用的DBA工具目标学完这个课程，你应该可以掌握你下内容:区别常用的对于DBA来说有用的管理工具区别OracleUniversalInstaller的功能使用SQL*Plus来管理Oracledatabase列出OracleEnterpriseManager主要的功能组件DatabaseAdministrationToolsDescriptionToolUsedtoinstall,upgrade,orremovesoftwarecomponentsOracleUniversalInstaller(OUI)Agraphicaluserinterface

2、toolthatinteractswiththeOUI,orcanbeusedindependently,tocreate,delete,ormodifyadatabaseOracleDatabaseConfigurationAssistantAutilitytoaccessdatainanOracledatabaseSQL*PlusAgraphicalinterfaceusedtoadminister,monitor,andtuneoneormoredatabasesOracleEnterpriseManagerOracleUniversalIns

3、tallerUsedtoinstall,upgrade,orremovesoftwarecomponents,andcreateadatabaseBasedonaJavaengineFeaturesinclude:AutomaticdependencyresolutionAllowsforWeb-basedinstallationsTrackinginventoryofcomponentandsuiteinstallationsDeinstallationofinstalledcomponentsSupportformultipleOraclehom

4、esSupportforglobalizationtechnologyStartingtheUniversalInstallerTostartOracleUniversalInstalleronUNIX:TostartOracleUniversalInstalleronNT:$./runInstallerD:>setupNon-InteractiveInstallationUsingResponseFilesAllowsfornouserinteractionResponsefiles:TemplatesthatmustbeeditedTextfi

5、lescontainingvariablesandvaluesParametersarecustomizedTostartUniversalInstallerinnon-interactivemode:./runInstaller-responsefilemyrespfile-silentOracleDatabaseConfigurationAssistantTheOracleDatabaseConfigurationAssistantallowsyouto:CreateadatabaseConfiguredatabaseoptionsDeletea

6、databaseManagetemplatesDatabaseAdministratorUsersUsersSYSandSYSTEMarecreatedautomaticallyDuringdatabasecreationGrantedtheDBAroleSYSPassword:change_on_installOwnerofthedatabasedatadictionarySYSTEMPassword:managerOwnerofadditionalinternaltablesandviewsusedbyOracletoolsSQL*PlusAnO

7、racletoolproviding:CapabilitytointeractwithandmanipulatethedatabaseAbilitytostartupandshutdownthedatabase,createandrunqueries,addrows,modifydata,andwritecustomizedreportsSubsetofthestandardSQLlanguagewithspecificaddonsConnectingtoSQL*Plussqlplus/nologconnect/assysdbaConnectedto

8、anidleinstance.OracleEnterpriseManagerServesasacentral