15 输入netca命令进行侦听配置.其中参数一律默认即可.可以用ps -ef 查看该服务是否已启用.
16 输入dbca命令,进行数据库的创建,下面我列出的是一些注意事项
选择gernel purpose,在SID和全局名称中,选择你在.bash_profile中创建的SID.
在Character Sets字符集选项中选择第2项AL32UTF8.
OK,完成.
17 进入u01/Oracle/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