Oracle手工创建数据库的完整步骤

Oracle手工创建数据库的完整步骤 一 建立存放数据库文件的目录和日志相关的文件目录 分别在$ORACLE_BASE\oradata 和 $ORACLE_BAS

Oracle手工创建数据库的完整步骤

一 建立存放数据库文件的目录和日志相关的文件目录

分别在$ORACLE_BASE\oradata 和 $ORACLE_BASE\admin目录下建立NEWDB目录

使用命令查看目录结构

[oracle@wang NEWDB]$ pwd

/u01/app/admin/NEWDB

[oracle@wang NEWDB]$ pwd

/u01/app/oradata/NEWDB

二 确定ORACLE实例名

[oracle@wang NEWDB]$ export ORACLE_SID=NEWDB

--------------------------------------分割线 --------------------------------------

Oracle 11g使用DBCA以非交互(静默)方式创建数据库

Oralce 10g 使用DBCA创建数据库

手动创建数据库的整体流程 Oracle 11g

CentOS 5.2 x86 安装Oracle 11g R2 笔记

在CentOS 6.4下安装Oracle 11gR2(x)

Oracle 11gR2 在VMWare虚拟机中安装步骤

--------------------------------------分割线 --------------------------------------

三 创建初始化参数文件

1 创建参数文件

vi $ORACLE_BASE/dbs/initNEWDB.ora

control_files = (/u01/app/oradata/NEWDB/control01.dbf,

/u01/app/oradata/NEWDB/control02.dbf,

/u01/app/oradata/NEWDB/control03.dbf)

db_name = NEWDB

db_domain = NEWDB.oracle.com

log_archive_dest_1 = "LOCATION=/u01/app/admin/NEWDB/arch"

log_archive_dest_state_1 = enable

db_block_size = 8192

pga_aggregate_target = 90M

processes = 100

sessions = 120

open_cursors = 200

undo_management = AUTO

undo_tablespace = undotbs

compatible = 10.2.0

sga_target = 270M

nls_language = AMERICAN

nls_territory = AMERICA

db_recovery_file_dest = /u01/app/admin/NEWDB/flashback

db_recovery_file_dest_size = 1G

audit_dump_dest = /u01/app/admin/NEWDB/adump

core_dump_dest = /u01/app/admin/NEWDB/cdump

background_dump_dest = /u01/app/admin/NEWDB/bdump

2 创建spfile参数文件

[oracle@wang dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 23 14:37:08 2014

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

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

四 创建数据库

1 startup nomount;

2 编写创建数据库脚本

vi temp

CREATE DATABASE NEWDB

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oradata/NEWDB/redo01.log') SIZE 50M,

GROUP 2 ('/u01/app/oradata/NEWDB//redo02.log') SIZE 50M,

GROUP 3 ('/u01/app/oradata/NEWDB/redo03.log') SIZE 50M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/u01/app/oradata/NEWDB/system01.dbf' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oradata/NEWDB//sysaux01.dbf' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oradata/NEWDB/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/u01/app/oradata/NEWDB/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

3执行脚本

SQL> CREATE DATABASE NEWDB

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oradata/NEWDB/redo01.log') SIZE 50M,

GROUP 2 ('/u01/app/oradata/NEWDB//redo02.log') SIZE 50M,

GROUP 3 ('/u01/app/oradata/NEWDB/redo03.log') SIZE 50M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/u01/app/oradata/NEWDB/system01.dbf' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oradata/NEWDB//sysaux01.dbf' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oradata/NEWDB/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/u01/app/oradata/NEWDB/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Database created.

更多详情见请继续阅读下一页的精彩内容：