Oracle 10g手工建庫

一、  準備相關目錄

ORACLE_BASE=/u01/app/oracle 

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 

mkdir -p $ORACLE_BASE/admin/wailon/{a,b,c,d,u}dump
mkdir -p /u01/app/oradata/wailon

二、  設定ORACLE使用者環境變數.bash_profile 

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

ORACLE_SID=wailon 

export ORACLE_BASE ORACLE_HOME ORACLE_SID 

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export PATH 
$source .bash_profile

三、  建立密碼檔案

cd $ORACLE_HOME/dbs

orapwd file=orapwwailon password=oracle entries=10

四、  建立pfile引數檔案 
cat init.ora | grep -v ^# | grep -v ^$  >> initwailon.ora
vi initwailon.ora
---------------------------------------------------------------------------------------

compatible=10.2.0

db_name=wailon

sga_target=500m

audit_file_dest='/u01/app/oracle/admin/wailon/adump'

background_dump_dest='/u01/app/oracle/admin/wailon/bdump'

core_dump_dest='/u01/app/oracle/admin/wailon/cdump'

user_dump_dest='/u01/app/oracle/admin/wailon/udump'

control_files='/u01/app/oradata/wailon/control01.ctl', '/u01/app/oradata/wailon/control02.ctl'

db_recovery_file_dest='/u01/app/flash_recovery_area'

db_recovery_file_dest_size=2g

undo_tablespace=undotbs01

undo_management=auto 

五、  啟動資料庫到NOMOUNT狀態
sqlplus / as sysdba
startup nomount; 

六、  建立資料庫 

create database wailon
user sys identified by oracle
user system identified by oracle
maxinstances 8

maxlogfiles 32

maxlogmembers 3

maxloghistory 1

maxdatafiles 100
datafile '/u01/app/oradata/wailon/system01.dbf' size 500m autoextend on 

extent management local

sysaux datafile '/u01/app/oradata/wailon/sysaux01.dbf' size 500m

default tablespace user01 datafile '/u01/app/oradata/wailon/user01.dbf' size 100m

undo tablespace undotbs01 datafile '/u01/app/oradata/wailon/untotbs01.dbf' size 100m

default temporary tablespace temp01 tempfile '/u01/app/oradata/wailon/temp01.dbf' size 100m

logfile

group 1 '/u01/app/oradata/wailon/redo01.log' size 50m,

group 2 '/u01/app/oradata/wailon/redo02.log' size 50m,

group 3 '/u01/app/oradata/wailon/redo03.log' size 50m

character set zhs16gbk

national character set al16utf16; 

七、  建立SPFILE

create spfile from pfile;

shutdown immediate;

startup;

八、  建立資料字典
sqlplus / as sysdba
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql  

--建立使用者安全稽核表
SQL> connect system/oracle

SQL> @?/sqlplus/admin/pupbld.sql 

--建立SCOTT使用者

SQL> @?/rdbms/admin/utlsampl

 至此，一個庫成功建立。手工建庫有助進一步熟悉ORACLE體系結構。

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