最近有时间学习oracle了，把学习的过程整理出来，漫漫学习路，现在才刚刚起步。
创新互联主要从事网站设计、成都网站制作、网页设计、企业做网站、公司建网站等业务。立足成都服务丰满,十年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:18980820575
1.#su - oracle
2.启动监听
$ lsnrctl start
3.启动em
$ emctl start dbconsole
http://192.168.88.139:1158/em/
4.启动iSQL*Plus
$ isqlplusctl start
http://192.168.88.139:5560/isqlplus/
5.连接数据库
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 22 07:01:37 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
6.启动数据库
SQL> startup;
7.创建用户bob，密码admin
SQL>create user bob identified by admin;
8.把dba权限给bob
SQL>grant dba to bob;
9.取消授权
SQL>revoke dba from bob；
10.删除用户,如果用户已经有对象了（如TABLE，VIEW等)需要带cascade
SQL>drop user bob cascade;
11.删除 ORACLE表空间
SQL>drop tablespace tablespacename including contents and datafiles;
12.解锁oracle用户bob
SQL>show user;
USER is "SYS"
SQL>alter user bob account unlock;
SQL> conn bob/qazwsx;
Connected.
SQL> show user;
USER is "BOB"
