如何手工建立數(shù)據(jù)庫
2024-07-21 02:33:51
供稿：網(wǎng)友
假設(shè)建立db_name=zhang 的數(shù)據(jù)庫,首先預(yù)備
1 建立好文件目錄. 包括admin oradata udump bdump等目錄
2 預(yù)備密碼文件使用orapwd
3 預(yù)備初始化文件init.ora 修改其中的初始化參數(shù) 主要包括控制文件路徑,db_name instance_name等
以下參數(shù)需要設(shè)置好
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
instance_name=zhang
compatible=9.2.0.0.0
log_archive_dest_1='LOCATION=M:zhangbinoradataarchives'
log_archive_format=%t_%s.dbf
log_archive_start=true
db_domain=""
db_name=zhang
control_files=("M:zhangbinoradataCONTROL01.CTL", "M:zhangbinoradataCONTROL02.CTL", "M:zhangbinoradataCONTROL03.CTL")
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=M:zhangbinadminbdump
core_dump_dest=M:zhangbinadmincdump
timed_statistics=TRUE
user_dump_dest=M:zhangbinadminudump
4 建立Oracle服務(wù).windows下使用Oradim linux只需要設(shè)置好ORACLE_SID
5 登陸sqlplus執(zhí)行create database 腳本
set oracle_sid=zhang
sqlplus
connect sys/pass as sysdba
startup nomount pfile=pfilelocation
然后執(zhí)行創(chuàng)建數(shù)據(jù)庫的腳本（注重UNDO表空間名字要和初始化參數(shù)中一致）
CREATE DATABASE zhang
MAXLOGFILES 5
MAXDATAFILES 200
maxinstances 1
DATAFILE 'M:zhangbinoradatasystem01.dbf' SIZE 325M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'M:zhangbinoradataundotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET zhs16gbk
logfile 'M:zhangbinoradataredo01.log' size 10M reuse,
'M:zhangbinoradataredo02.log' size 10M reuse,
'M:zhangbinoradataredo03.log' size 10M reuse;
6 執(zhí)行以下腳步
@D:OracleOra81Rdbmsadmincatalog.sql;
@D:OracleOra81RdbmsadmincatPRoc.sql;
@D:OracleOra81Rdbmsadmincaths.sql;
connect system/manager
@D:OracleOra81sqlplusadminpupbld.sql
數(shù)據(jù)庫open以后你可以創(chuàng)建Temp，User等表空間了，也可以將這些信息寫到創(chuàng)建數(shù)據(jù)庫的腳本里面。
