Oracle 11g的数据库创建

shahand

以oracle用户运行dbca，

#su - oracle
[oracle@ractest database]$ dbca

shahand

我一般选择自定义数据库

shahand

输入数据库名称：orcl

shahand

不选择配置Enterprise manager，

并手工输入sys和system的密码，我这里配置相同的密码，也可以不同。

shahand

设置secure setting，使用默认值

shahand

secure setting稍后会继续观察该选项对应参数。。。。应该是11g的一个新特性，观察中。。。。

shahand

分别是数据文件存放方式、路径、要安装的数据库选件

shahand

在配置sga的时候发现gui界面聪明了一些，有几处变化：

多了内存分配比例的滚动条

typical分配和custom分配数值相关联

custom分配多了manual选项

看起来也算合理

shahand

下面的又都是一样的。。。。

shahand

创建完毕。

确认数据库状态：

[php]

[oracle@ractest trace]$  sysdba

SQL*Plus: Release 11.1.0.4.0 - Beta on Thu Jun 28 04:42:32 2007

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$version ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
PL/SQL Release 11.1.0.4.0 - Beta
CORE11.1.0.4.0Beta
TNS for Linux: Version 11.1.0.4.0 - Beta
NLSRTL Version 11.1.0.4.0 - Beta

SQL>


SQL> select status from v$instance ;

STATUS
------------
OPEN

SQL> select open_mode from v$database ;

OPEN_MODE
----------
READ WRITE



[root@ractest ~]# su  - oracle
[oracle@ractest ~]$ ls -l
total 48
drwxr-xr-x  60 oracle dba 4096 Jun 28 03:40 11g
drwxr-x---   3 oracle dba 4096 Jun 28 04:35 admin
drwxr-x---   4 oracle dba 4096 Jun 28 04:24 cfgtoollogs
drwxr-x---   3 oracle dba 4096 Jun 28 04:35 diag
drwxr-x---   3 oracle dba 4096 Jun 28 04:35 oradata
drwxrwx---   5 oracle dba 4096 Jun 28 03:40 oraInventory
[oracle@ractest ~]$ cd admin/
[oracle@ractest admin]$ ls
orcl
[oracle@ractest admin]$ ls -l
total 8
drwxr-x---  5 oracle dba 4096 Jun 28 04:35 orcl
[oracle@ractest admin]$ cd orcl/
[oracle@ractest orcl]$ ls
adump  dpdump  pfile
[oracle@ractest orcl]$ ls -l
total 24
drwxr-x---  2 oracle dba 4096 Jun 28 04:36 adump
drwxr-x---  2 oracle dba 4096 Jun 28 04:35 dpdump
drwxr-x---  2 oracle dba 4096 Jun 28 04:35 pfile
[oracle@ractest orcl]$ ls -l
total 24
drwxr-x---  2 oracle dba 4096 Jun 28 04:36 adump
drwxr-x---  2 oracle dba 4096 Jun 28 04:35 dpdump
drwxr-x---  2 oracle dba 4096 Jun 28 04:35 pfile
[oracle@ractest orcl]$ ps -ef|grep ora
root     11522 11342  0 02:25 pts/3    00:00:00 su - oracle
oracle   11523 11522  0 02:25 pts/3    00:00:00 -bash
oracle   19779 11523  0 04:21 pts/3    00:00:00 /bin/sh -f /home/oracle/11g/bin/dbca
.....

oracle   20177 19780  2 04:35 pts/3    00:00:01 /home/oracle/11g/bin/sqlplus -S      
oracle   20190     1  0 04:35 ?        00:00:00 ora_pmon_orcl
oracle   20192     1  0 04:35 ?        00:00:00 ora_vktm_orcl
oracle   20194     1  0 04:35 ?        00:00:00 ora_diag_orcl
oracle   20196     1  0 04:35 ?        00:00:00 ora_dbrm_orcl
oracle   20198     1  0 04:35 ?        00:00:00 ora_psp0_orcl
oracle   20202     1  0 04:35 ?        00:00:00 ora_dia0_orcl
oracle   20204     1  0 04:35 ?        00:00:00 ora_mman_orcl
oracle   20206     1  0 04:35 ?        00:00:00 ora_dbw0_orcl
oracle   20208     1  3 04:35 ?        00:00:03 ora_lgwr_orcl
oracle   20210     1  0 04:35 ?        00:00:00 ora_ckpt_orcl
oracle   20212     1  0 04:35 ?        00:00:00 ora_smon_orcl
oracle   20214     1  0 04:35 ?        00:00:00 ora_reco_orcl
oracle   20216     1  0 04:35 ?        00:00:00 ora_cjq0_orcl
oracle   20218     1  0 04:35 ?        00:00:00 ora_mmon_orcl
oracle   20220     1  0 04:35 ?        00:00:00 ora_mmnl_orcl
oracle   20230     1  0 04:35 ?        00:00:00 ora_smco_orcl
oracle   20232     1  0 04:36 ?        00:00:00 ora_fbar_orcl
oracle   20234     1  0 04:36 ?        00:00:00 ora_qmnc_orcl
oracle   20241     1 85 04:36 ?        00:00:40 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   20243     1  0 04:36 ?        00:00:00 ora_w000_orcl
oracle   20246     1  0 04:36 ?        00:00:00 ora_q000_orcl
root     20280 20248  0 04:36 pts/2    00:00:00 su - oracle
oracle   20281 20280  0 04:36 pts/2    00:00:00 -bash
oracle   20314 20281  0 04:36 pts/2    00:00:00 ps -ef
oracle   20315 20281  0 04:36 pts/2    00:00:00 grep ora
[oracle@ractest orcl]$ export ORACLE_SID=orcl
[oracle@ractest orcl]$ sysdba

SQL*Plus: Release 11.1.0.4.0 - Beta on Thu Jun 28 04:36:57 2007

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options

SQL> show parameter backgr

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump     string partial
background_dump_dest     string /home/oracle/diag/rdbms/orcl/o
rcl/trace
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options
[oracle@ractest orcl]$ cd /home/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@ractest trace]$ ls -l
total 128
-rw-r-----  1 oracle dba 8823 Jun 28 04:37 alert_orcl.log
-rw-r-----  1 oracle dba  785 Jun 28 04:35 orcl_dia0_20202.trc
-rw-r-----  1 oracle dba  116 Jun 28 04:35 orcl_dia0_20202.trm
-rw-r-----  1 oracle dba  785 Jun 28 04:35 orcl_diag_20194.trc
-rw-r-----  1 oracle dba  116 Jun 28 04:35 orcl_diag_20194.trm
-rw-r-----  1 oracle dba  850 Jun 28 04:35 orcl_lgwr_20208.trc
-rw-r-----  1 oracle dba  116 Jun 28 04:35 orcl_lgwr_20208.trm
-rw-r-----  1 oracle dba  794 Jun 28 04:35 orcl_ora_20187.trc
-rw-r-----  1 oracle dba  151 Jun 28 04:35 orcl_ora_20187.trm
-rw-r-----  1 oracle dba  969 Jun 28 04:36 orcl_ora_20222.trc
-rw-r-----  1 oracle dba  188 Jun 28 04:36 orcl_ora_20222.trm
-rw-r-----  1 oracle dba  805 Jun 28 04:35 orcl_pmon_20190.trc
-rw-r-----  1 oracle dba  152 Jun 28 04:35 orcl_pmon_20190.trm
-rw-r-----  1 oracle dba  802 Jun 28 04:36 orcl_qmnc_20234.trc
-rw-r-----  1 oracle dba  116 Jun 28 04:36 orcl_qmnc_20234.trm
[oracle@ractest trace]$ tail -f alert_orcl.log
CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/home/oracle/oradata/orcl/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO
Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/home/oracle/oradata/orcl/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Thu Jun 28 04:36:19 2007
Thread 1 advanced to log sequence 2
  Current log# 2 seq# 2 mem# 0: /home/oracle/oradata/orcl/redo02.log
Thu Jun 28 04:37:00 2007
Thread 1 advanced to log sequence 3
  Current log# 3 seq# 3 mem# 0: /home/oracle/oradata/orcl/redo03.log
Thu Jun 28 04:37:34 2007
Thread 1 advanced to log sequence 4
  Current log# 1 seq# 4 mem# 0: /home/oracle/oradata/orcl/redo01.log
Thu Jun 28 04:38:09 2007
Thread 1 advanced to log sequence 5
  Current log# 2 seq# 5 mem# 0: /home/oracle/oradata/orcl/redo02.log


[/php]