17 进入u01http://oracle.chinaitlab.com/oradata目录,查看一下会出现一些数据库文件 .

　　ps -ef查看会增加更多的Oracle相关服务

　　18 在图形界面中选择LogOut退出至字符界面

　　19 创建一个实例进行最后测试

　　注意:在数据库操作中都是用Oracle用户执行命令.

　　输入

　　[Oracle@computer ~]$ sqlplus /nolog

　　SQL*Plus: Release 11.1.0.6.0 – Production on Tue Dec 11 15:32:23 2007

　　Copyright (c) 1982, 2007, Oracle. All rights reserved.

　　SQL> conn / as sysdba

　　Connected.

　　SQL> create table testbl ( id integer , name char(10));

　　Table created.

　　SQL> insert into testbl values ( 0 , ’wilson’ );

　　1 row created.

　　SQL> commit;

　　Commit complete.

　　SQL> select * from testbl;

　　ID NAME

　　———- ———-

　　0 wilson

　　SQL> shutdown immediate

　　Database closed.

　　Database dismounted.
　
　　Oracle instance shut down.

　　SQL> !ps -ef

　　exit

　　全部完成,推荐大家一定要看看小布教师的视频讲座.

　　[Oracle@computer ~]$ sqlplus

　　SQL*Plus: Release 11.1.0.6.0 – Production on Tue Dec 11 15:00:41 2007

　　Copyright (c) 1982, 2007, Oracle. All rights reserved.

　　Enter user-name: sys as sysdba

　　Enter password:
　
　　Connected to:

　　Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

　　With the Partitioning, OLAP, Data Mining and Real Application Testing options
　
　　SQL> exit

　　Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

　　With the Partitioning, OLAP, Data Mining and Real Application Testing options