水煮oracle28----oracle手工建庫步驟

（1）設定環境變數
（2）建立pfile檔案
   最少推薦引數：db_name/control_files/memory_target
（3）建立spfile
CREATE SPFILE FROM PFILE;
（4）啟動instance
startup nomount

（5）資料庫建立指令碼
CREATE DATABASE "oracle"
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/oracle/redo01.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/oracle/redo02.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/oracle/redo03.log') SIZE 100M BLOCKSIZE 512
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET ZHS16GBK
   NATIONAL CHARACTER SET UTF8
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u01/app/oracle/oradata/oracle/system01.dbf' SIZE 325M REUSE
   SYSAUX
   DATAFILE '/u01/app/oracle/oradata/oracle/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
   DATAFILE '/u01/app/oracle/oradata/oracle/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
   TEMPFILE '/u01/app/oracle/oradata/oracle/temp01.dbf' SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
   DATAFILE '/u01/app/oracle/oradata/oracle/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
（6）執行資料字典和pl/sql package指令碼
 sys： @?/rdbms/admin/catalog.sql
            @?/rdbms/admin/catproc.sql
system:
            @?/rdbms/admin/pupbld.sql

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