手工建立oracle資料庫

cnhtm發表於2010-02-08
原文網址 : http://blog.itpub.net/22049049/viewspace-1031219/
Oracle資料庫

下面過程演示手工建立資料庫例項的過程：
（b14231 第75-80頁）

1、設定oracle資料庫的sid

ora_test@oracle[/home/oracle]> export ORACLE_SID=cnhtm
[@more@]

2、確定資料庫的認證方式

如果需要在其他客戶端以sysdba方式連線這個例項，按如下方法建立口令檔案

ora_test@oracle[/home/oracle]> orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y

3、編輯引數檔案

建立引數檔案，檔名為 $ORACLE_HOME/dbs/init$ORACLE_SID.ora，其內容如下

ora_test@oracle[/home/oracle]> cat $ORACLE_HOME/dbs/init$ORACLE_SID.ora
control_files = (+DATA/cnhtm/controlfile/control01.dbf,
+DATA/cnhtm/controlfile/control02.dbf,
+DATA/cnhtm/controlfile/control03.dbf)
db_name = cnhtm
log_archive_dest_1 = "LOCATION=+DATA/cnhtm/arch"
log_archive_dest_state_1 = enable
db_block_size = 8192
pga_aggregate_target = 100M
processes = 1000
sessions = 1200
open_cursors = 1024
undo_management = AUTO
shared_servers = 3
#下面這一行的undo表空間名要與步驟7的UNDO TABLESPACE語句中的undo表空間名一致，否則建庫失敗，
#在警告日誌中報ORA-30012: undo tablespace 'undotbs1' does not exist or of wrong type
undo_tablespace = undotbs1
compatible = 10.2.0
sga_target = 200M
nls_language = AMERICAN
nls_territory = AMERICA

4、連線資料庫例項

ora_test@oracle[/home/oracle]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 9 11:19:08 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

5、建立spfile

idle> create spfile from pfile;

File created.

6、啟動資料庫例項到nomount狀態

idle> startup nomount
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1218532 bytes
Variable Size 109053980 bytes
Database Buffers 92274688 bytes
Redo Buffers 7168000 bytes

7、執行create database語句

idle> CREATE DATABASE cnhtm
2 USER SYS IDENTIFIED BY oracle
3 USER SYSTEM IDENTIFIED BY oracle
4 LOGFILE
5 GROUP 1 ('+DATA/cnhtm/onlinelog/redo01.log') SIZE 100M,
6 GROUP 2 ('+DATA/cnhtm/onlinelog/redo02.log') SIZE 100M,
7 GROUP 3 ('+DATA/cnhtm/onlinelog/redo03.log') SIZE 100M
8 MAXLOGFILES 5
9 MAXLOGMEMBERS 5
10 MAXLOGHISTORY 1
11 MAXDATAFILES 100
12 MAXINSTANCES 1
13 CHARACTER SET ZHS16GBK
14 NATIONAL CHARACTER SET AL16UTF16
15 DATAFILE
16 '+DATA/cnhtm/datafile/system01.dbf' SIZE 325M REUSE
17 EXTENT MANAGEMENT LOCAL
18 SYSAUX DATAFILE '+DATA/cnhtm/datafile/sysaux01.dbf'
19 SIZE 325M REUSE
20 DEFAULT TABLESPACE tbs_1
--下面紅色的這三行是需要加上的,否則會建庫失敗，alert log中報ORA-02236: invalid file name
21 DATAFILE '+DATA/cnhtm/datafile/tbs_101.dbf'
22 SIZE 100M REUSE
23 AUTOEXTEND ON MAXSIZE UNLIMITED
24 DEFAULT TEMPORARY TABLESPACE tempts1
25 TEMPFILE '+DATA/cnhtm/tempfile/temp01.dbf'
26 SIZE 20M REUSE
--下面這一行的undo表空間名要與步驟3的undo_tablespace一致，否則建庫失敗，
--在警告日誌中報ORA-30012: undo tablespace 'undotbs1' does not exist or of wrong type
27 UNDO TABLESPACE undotbs1
28 DATAFILE '+DATA/cnhtm/datafile/undotbs01.dbf'
29 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Database created.

8、建立額外的表空間

idle> CREATE TABLESPACE users LOGGING
2 DATAFILE '+data/cnhtm/datafile/users01.dbf'
3 SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
4
Tablespace created.

idle>
idle> CREATE TABLESPACE indx LOGGING
2 DATAFILE '+data/cnhtm/datafile/indx01.dbf'
3 SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
4 EXTENT MANAGEMENT LOCAL;

Tablespace created.

9、建立資料字典檢視

idle> @?/rdbms/admin/catalog.sql
idle> @?/rdbms/admin/catproc.sql

--end--

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22049049/viewspace-1031219/，如需轉載，請註明出處，否則將追究法律責任。

相關文章