chapter02 数据库管理工具

objectives:

after completing this lesson, you should be able to do the following:

a. identify common database administration tools available to a DBA

b. identify the features of various database administration tools

c. use sql*plus to interact and manipulate an oracle database

1. DB administration tools

  a.  oui (oracle universal installer)

  used to install, upgrade, or remove software components

  b. dbca (database configuration assistant)

  a graphical user interface tool that interacts with the OUI, or can be used independently to create, delete, or modify a database

  c. netca (network configuration assistant)

  用来配置网络

  d. netmgr (network manager)

  用来配置网络

  e. sql*plus

  a utility to access data in an oracle database

  f. rman (recovery manager)

  自动化的备份与恢复工具

  g. exp/imp  expdp/impdp

  导出与导入数据的工具

  h. sqlldr (sql loader)

  用来加载数据的工具

2. DB administration users

一旦数据库建好之后，会默认创建两个管理员账号：sys和system

  a. users SYS and SYSTEM are created automatically

  -- during database creation

  -- granted the DBA role

  b. user SYS

  -- owner of the database data dictionary

  -- default password: change_on_install

  c. user SYSTEM

  -- owner of additional internal tables and views used by oracle tools

  -- default password: manager

3. sql*plus

sql*plus一个非常好用的工具，下面介绍几种使用：

  a. 只启动sqlplus,不连接数据库

  shell> sqlplus /nolog

  b. 先启动sqlplus,在连接数据库

  shell> sqlplus /nolog

  sql> conn[ect] username/password

  c. 在启动sqlplus的同时，连接数据库

  shell> sqlplus username/password[@connect_descriptor]

详细的使用方法，大家还是看官方文档吧，非常详细