启动数据库的步骤

李玲

1.登陆到 oracle
  su - oracle

2.启动 监听
 
  $ lsnrctl start

3. 启动数据库
  $ sqlplus /nolog
  sql>conn / as sysdba
  sql>startup

4.解锁hr用户
  sql> alter user hr identified by hr account unlock;

5.登陆到 hr用户

  sql>conn hr/hr

6.查看有哪些表
  sql>select table_name from user_tables;

7.查看表结构
  sql> desc departments

8.看具体内容
  sql>select * from departments;