手動建立資料庫步驟

1.確定oracle的ORACLE_SID名稱;

2.確定資料庫使用的字符集;

3.設定引數檔案parameter initsid.ora;

4.根據引數檔案中建立所需要的資料夾;

5.建立口令檔案 orapwd file=orapwsid password=oracle entries=10 force=y

5.設定create database command 指令碼;

CREATE DATABASE "shirley"

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

DATAFILE '/usr/local/src/oradata/shirley/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local

sysaux datafile '/usr/local/src/oradata/shirley/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited

default temporary tablespace TEMP tempfile '/usr/local/src/oradata/shirley/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited

undo tablespace UNDOTBS1 datafile '/usr/local/src/oradata/shirley/undotbs01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited

logfile GROUP 1 ('/usr/local/src/oradata/shirley/redo1.dbf') size 10m,

GROUP 2 ('/usr/local/src/oradata/shirley/redo2.dbf') size 10m,

GROUP 3 ('/usr/local/src/oradata/shirley/redo3.dbf') size 10m

6.設定表空間及索引空間;

7.執行data dictionary等sql語句

7.1 @$ORACLE_HOME/rdbms/admin/catalog.sql;

7.2 @$ORACLE_HOME/rdbms/admin/catproc.sql;

7.3 @$ORACLE_HOME/sqlplus/admin/pupbld.sql;

[@more@]

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