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


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.