Oracle11g 手工建立資料庫

資料庫系統版本：11g
1. 設定資料庫環境變數

[oracle@R710 ~]$ more .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_SID=orcl
export ORACLE_BASE=/ulic/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch:/sbin:$HOME/bin:/ulic/app/oracle/product/11.2/bin:/ulic/app/grid/bin:/home/oracle/ch_bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export PATH
export NLS_LANG=american_america.utf8

2.建立口令檔案
a. cd $ORACLE_HOME/dbs
b. orapwd file=orapwORCL password=oracle entries=30;

3. 修改已有的init.ora建立引數檔案，此資料庫的db_name=orcl
a.  cat init.ora | grep -v ^$ | grep -v ^#>initorcl.ora
[oracle@DC693SB3X-R710 dbs]$ more initatsdev.ora
db_name='orcl'
memory_target=1G
processes = 150
audit_file_dest='/ulic/app/oracle/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/ulic/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/ulic/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (/ulic/oradata/orcl/control01.ctl,/ulic/oradata/orcl/control02.ctl)
compatible ='11.2.0.4'

4. 建立需要的資料夾
mkdir -p /ulic/app/oracle/admin/orcl/adump
mkdir -p /ulic/app/oracle/flash_recovery_area
mkdir -p /ulic/app/oracle/oradata/orcl

5. 啟動資料庫到nomount狀態
a. sqlplus "/as sysdba"
b. startup nomount;

6. 建立資料庫的指令碼
a. vi create_db.sql
b.
CREATE DATABASE orcl
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/ulic/oradata/orcl/redo01a.log','/ulic/oradata/orcl/redo01b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/ulic/oradata/orcl/redo02a.log','/ulic/oradata/orcl/redo02b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/ulic/oradata/orcl/redo03a.log','/ulic/oradata/orcl/redo03b.log') SIZE 100M BLOCKSIZE 512
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/ulic/oradata/orcl/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/ulic/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/ulic/oradata/orcl/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/ulic/oradata/orcl/temp01.dbf'
            SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/ulic/oradata/orcl/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

7. 執行指令碼建立資料庫
a. SQL>@/home/oracle/create_db.sql

8. 執行指令碼建立資料庫字典
a. SQL>@?/rdbms/admin/catalog.sql
b. SQL>@?/rdbms/admin/catproc.sql

9. 檢視資料庫的狀態
SQL>select status from v$instance;

10. 建立spfile檔案
SQL>create spfile from pfile;

總結： 手工建庫的步驟為
a. 設定環境變數
b. 建立口令檔案
c. 建立pfile檔案
d. 建立必要的檔案目錄
e. 建立資料庫
f. 執行必要的指令碼
g. 建立spfile檔案