oracle 创建数据库 create database,手动创建数据库（使用CREATE DATABASE语句）

Normal

0

7.8 pt

0

2

false

false

false

EN-US

ZH-CN

X-NONE实验目的：学会用CREATE DATABASE语句手动创建数据库

实验结果：创建一个数据库，该数据库至少包含2个Control files，3个Log groups，5个Tablespaces (SYSTEM, SYSAUX, Default, Default temporary, Undo)

实验参考：Chapter 2 of “Administrator's Guide”

范例：

1,确定实例名和数据库名，并编辑init$ORACLE_SID.ora

1)确定ORACLE_SID,创建一目录用于存放数据库文件。

$ export ORACLE_SID=mydb

$ cd /oracle/db11g/oradata/

$ mkdir mydb

2)创建并编辑initmydb.ora文件(文件目录为$ORACLE_HOME/dbs)

$

cd $ORACLE_HOME/dbs

$

vi initmydb.ora

db_name=mydb

instance_name=mydb

control_files='/oracle/db11g/oradata/mydb/control01.ctl',

'/oracle/db11g/oradata/mydb/control02.ctl'

2,创建并启动实例

$

sqlplus / as sysdba

SQL>

startup nomount

3.创建数据库

1)手动创建数据库(注：SYSAUS至少为240M)

SQL> create

database mydb

logfile group 1 ('/oracle/db11g/oradata/mydb/redo01.log') size 100m,

group 2

('/oracle/db11g/oradata/mydb/redo02.log') size 100m,

group 3

('/oracle/db11g/oradata/mydb/redo03.log') size 100m

maxlogfiles 6

maxlogmembers 5

maxdatafiles 100

maxloghistory 1

maxinstances 3

character set us7ascii

national character set al16utf16

datafile '/oracle/db11g/oradata/mydb/system01.dbf'

size 150m reuse autoextend on maxsize unlimited

extent management local

sysaux datafile '/oracle/db11g/oradata/mydb/sysaux01.dbf'

size 250m reuse autoextend on maxsize unlimited

default tablespace tbs_1

datafile '/oracle/db11g/oradata/mydb/perm01.dbf'

size 20m reuse autoextend on maxsize unlimited

default temporary tablespace tempts1

tempfile '/oracle/db11g/oradata/mydb/temp01.dbf'

size 20m reuse autoextend on maxsize unlimited

undo tablespace undotbs

datafile

'/oracle/db11g/oradata/mydb/undotbs01.dbf'

size 100m reuse

autoextend on maxsize unlimited;

2)添加两个表空间

SQL> CREATE

TABLESPACE users LOGGING

DATAFILE

'/oracle/db11g/oradata/mydb/users01.dbf'

SIZE 25M REUSE

AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED

EXTENT

MANAGEMENT LOCAL;

SQL> CREATE

TABLESPACE indx LOGGING

DATAFILE '/oracle/db11g/oradata/mydb/indx01.dbf'

SIZE 25M REUSE

AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED

EXTENT

MANAGEMENT LOCAL;

4.运行脚本

SQL>

conn as sysdba

SQL>

@/oracle/db11g/11.2/rdbms/admin/catalog.sql

SQL>

@/oracle/db11g/11.2/rdbms/admin/catproc.sql

Normal

0

7.8 pt

0

2

false

false

false

EN-US

ZH-CN

X-NONE

5.验证

SQL>

show parameter db_name;

NAMETYPEVALUE

------------------------------------

----------- ------------------------------

db_namestringmydb

参考资料：Chapter 3 of "Administrator's Guide"