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

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

三创建初始化参数文件

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

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