常用DBA工具.pptVIP

常用的DBA工具 目标 学完这个课程，你应该可以掌握你下内容: 区别常用的对于DBA来说有用的管理工具 区别 Oracle Universal Installer 的功能 使用 SQL*Plus 来管理 Oracle database 列出Oracle Enterprise Manager主要的功能组件 Database Administration Tools Oracle Universal Installer Used to install, upgrade, or remove software components, and create a database Based on a Java engine Features include: Automatic dependency resolution Allows for Web-based installations Tracking inventory of component and suite installations Deinstallation of installed components Support for multiple Oracle homes Support for globalization technology Starting the Universal Installer To start Oracle Universal Installer on UNIX: To start Oracle Universal Installer on NT: Non-Interactive Installation Using Response Files Allows for no user interaction Response files: Templates that must be edited Text files containing variables and values Parameters are customized To start Universal Installer in non-interactive mode: Oracle Database Configuration Assistant The Oracle Database Configuration Assistant allows you to: Create a database Configure database options Delete a database Manage templates Database Administrator Users Users SYS and SYSTEM are created automatically During database creation Granted the DBA role SYS Password: change_on_install Owner of the database data dictionary SYSTEM Password: manager Owner of additional internal tables and views used by Oracle tools SQL*Plus An Oracle tool providing: Capability to interact with and manipulate the database Ability to start up and shutdown the database, create and run queries, add rows, modify data, and write customized reports Subset of the standard SQL language with specific add ons Connecting to SQL*Plus Oracle Enterprise Manager Serves as a centralized systems management for DBAs A tool to administer, diagnose, and tune multiple databases A tool to administer multiple network nodes and services from many locations Use to share tasks with other administrators Provides tools for administering paralle