手工建立一個資料庫的步驟參考

轉自樓總文章

[@more@]下面介紹一下如何手工建立一個資料庫的步驟:

1,準備一個引數檔案(init.ora), 應當主要包括以下引數.

compatible=10.2.0.1.0
remote_login_passwordfile=NONE
pga_aggregate_target=33554432
db_domain=""
db_name=LFXDB
control_files=()
java_pool_size=0
large_pool_size=0
shared_pool_size=80m
open_cursors=300
undo_management=AUTO
undo_tablespace=UNDOTBS1
background_dump_dest=
core_dump_dest=
user_dump_dest=
processes=45
sessions=55
db_block_size=8192
db_cache_size=50331648
db_file_multiblock_read_count=8

2,預建好資料檔案目錄, 及各種trace檔案的目錄(BACKGROUND_DUMP_DEST, CORE_DUMP_DEST, USER_DUMP_DEST).

3,在Windows上首先要註冊一個服務, 並啟動這個服務, 在Linux/Unix上則不需要這一步. Windows上註冊服務的命令如下:

ORADIM -NEW -SID
ORADIM -STARTUP -SID

4,連線到空的資料庫(sqlplus "/ as sysdba"), 執行建立資料庫的命令.

CREATE DATABASE
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '......system01.dbf'
SIZE 512M REUSE EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '......sysaux01.dbf'
SIZE 256M REUSE EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE
TEMP TEMPFILE '......temp01.dbf'
SIZE 256M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '......undotbs01.dbf' SIZE 256M REUSE
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('......redo01.log') SIZE 51200K,
GROUP 2 ('......redo02.log') SIZE 51200K,
GROUP 3 ('......redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY "&&sysPassword"
USER SYSTEM IDENTIFIED BY "&&systemPassword";

5,執行以下角本建立資料字典.

@?/sqlplus/admin/rdbms/admin/catalog.sql;
@?/sqlplus/admin/rdbms/admin/catblock.sql;
@?/sqlplus/admin/rdbms/admin/catproc.sql;
@?/sqlplus/admin/rdbms/admin/catoctk.sql;
connect "SYSTEM"/"&&systemPassword"
@?/sqlplus/admin/pupbld.sql;

6, 增加SQL*Plus的幫助資訊.

connect "SYSTEM"/"&&systemPassword"
@?/sqlplus/admin/help/hlpbld.sql helpus.sql;

手工建立資料庫的步驟就完成了, 接下來可以建立其他的表空間了.