教你怎么在Linux系统中安装Oracle 11G

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