雖然 DBCA 圖形化工具便利,但掌握手工建庫腳本有助於理解資料庫架構、自動化部署與故障排查。本文提供 Windows/Linux 完整腳本與十步驟解析。
oradim、orapwd);init.ora 初始化參數檔;STARTUP NOMOUNT 掛載實例;CREATE DATABASE 陳述式;catalog.sql、catproc.sql 等);utlrp.sql);mkdir d:\oracle\product\10.1.0\database
mkdir e:\oracle\admin\Ora10g\bdump ...
set ORACLE_SID=ORA10G
oradim -new -sid ORA10G -startmode manual -spfile
oradim -edit -sid ORA10G -startmode auto -spfile
orapwd file=...PWDOra10g.ora password=sysPassword force=y
CONNECT SYS/change_on_install AS SYSDBA
STARTUP NOMOUNT PFILE="D:\oracle\admin\dbca\scripts\init.ora";
CREATE DATABASE dbca
MAXINSTANCES 1 MAXLOGHISTORY 1 MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100
DATAFILE 'D:\oracle\oradata\dbca\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\oradata\dbca\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1 DATAFILE 'D:\oracle\oradata\dbca\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('D:\oracle\oradata\dbca\redo01.log') SIZE 100M,
GROUP 2 ('D:\oracle\oradata\dbca\redo02.log') SIZE 100M,
GROUP 3 ('D:\oracle\oradata\dbca\redo03.log') SIZE 100M;
CREATE TABLESPACE "INDX" LOGGING DATAFILE '...' SIZE 25M AUTOEXTEND ON ... EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TOOLS" ...;
CREATE TABLESPACE "USERS" ...;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql -- 最後編譯無效物件
CREATE SPFILE='D:\oracle\database\spfiledbca.ora' FROM PFILE='D:\oracle\admin\dbca\scripts\init.ora';
SHUTDOWN IMMEDIATE;
STARTUP;
#!/bin/sh
export ORACLE_BASE=/orasys/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=ora9i
...
orapwd file=$ORACLE_HOME/dbs/orapwora9i password=change_on_install
sqlplus /nolog @CreateDB.sql
sqlplus /nolog @CreateDBFiles.sql
sqlplus /nolog @CreateDBCatalog.sql
sqlplus /nolog @postDBCreation.sql
CHARACTER SET ZHS16GBK:中文支援,含繁簡體;EXTENT MANAGEMENT LOCAL:本地管理區塊,效能優於字典管理;SEGMENT SPACE MANAGEMENT AUTO:ASSM 自動段空間管理,減少自由鏈表爭用;UNDO TABLESPACE:自動回滾段管理,取代手工回滾段。