oracle 手工建库

手工建库

环境：centos 6.5 + oracle 11g
[TOC]

1.设置当前$ORACLE_ SID=实例名

Export $ORACLE_SID=wk

2.为实例创建密码文件

orapwd file=$ORACLE_HOME/dbs/orapwwk password=123456 entries=10

3.创建初始化参数文件pfile

[oracle@localhost oracle]$ grep -v ^# 11g/dbs/init.ora >11g/dbs/initwk.ora 
Vim $ORACLE_HOME/dbs/initwk.ora
 [oracle@localhost ~]$ cat /u01/app/oracle/11g/dbs/initwk.ora
diagnostic_dest='/u01/oracle'
db_name='wk'
memory_target=500M
processes = 150
audit_file_dest='/u01/oracle/admin/WK/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/oracle'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (/u01/app/oracle/oradata/wk/control01.ctl,/u01/app/oracle/oradata/wk/control02.ctl)
compatible ='11.2.0'

4.创建实例数据存储目录

[oracle@localhost oracle]$ mkdir -pv admin/wk/adump
[oracle@localhost oracle]$ mkdir -pv flash_recovery_area
Mkdir -p $ORACLE_BASE/oradata/wk/disk{1,2,3,4,5}
[oracle@localhost ~]$ ls $ORACLE_BASE/oradata/wk
disk1  disk2  disk3  disk4  disk5

5.创建spfile文件，并将数据库启动到nomount状态

注：确保当前的ORACLE_SID=wk 
Sqlplus / as sysdba
SQL> create spfile from pfile
SQL> startup nomount

6.利用脚本创建数据库

创建脚本createdb.sql
[oracle@localhost ~]$ cat createdb.sql
CREATE DATABASE wk
USER SYS IDENTIFIED BY 111111
USER SYSTEM IDENTIFIED BY 111111
    LOGFILE GROUP 1 ('/u01/app/oracle/oradata/wk/disk1/redo01a.log','/u01/app/oracle/oradata/wk/disk2/redo01b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/wk/disk2/redo02a.log','/u01/app/oracle/oradata/wk/disk3/redo02b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/wk/disk3/redo03a.log','/u01/app/oracle/oradata/wk/disk4/redo03b.log') SIZE 100M BLOCKSIZE 512
     MAXLOGFILES 5
     MAXLOGMEMBERS 5
     MAXLOGHISTORY 1
     MAXDATAFILES 100
     CHARACTER SET AL32UTF8
     EXTENT MANAGEMENT LOCAL
     DATAFILE '/u01/app/oracle/oradata/wk/disk5/system01.dbf' SIZE 325M REUSE
     SYSAUX DATAFILE '/u01/app/oracle/oradata/wk/disk4/sysaux01.dbf' SIZE 325M REUSE
     default tablespace users
     datafile '/u01/app/oracle/oradata/wk/disk1/users01.dbf' size 100m
     DEFAULT TEMPORARY TABLESPACE temp
        TEMPFILE '/u01/app/oracle/oradata/wk/disk5/temp01.dbf'
        SIZE 20M REUSE
     UNDO TABLESPACE undotbs1
        DATAFILE '/u01/app/oracle/oradata/wk/disk3/undotbs01.dbf'
        SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

7.执行oracle自带的相关脚本→创建相关数据字典视图 （sysdba角色权限运行）

SQL>@?/rdbms/admin/catalog.sql          
SQL>@?/rdbms/admin/catproc.sql

至此，数据库创建完毕