Oracle手工建立資料庫的完整步驟

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(x64)

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.

更多詳情見請繼續閱讀下一頁的精彩內容：

1 2 下一頁