oracle手工建库
Step 1: Specify an Instance Identifier (SID) (创建一个SID)
[oracle@localhost ~]$ vi .bash_profile
[oracle@localhost ~]$ source .bash_profile
[oracle@jfdb ~]$ env |grep ORA 查询一下配置
Step 2: Ensure That the Required Environment Variables Are Set
密码文件的位置:$ORACLE_HOME/dbs
密码文件的名称:orapw<ORACLE_SID>
创建密码文件
[oracle@localhost dbs]$ orapwd file=orapwyfocp password=oracle;
Step 3: Choose a Database Administrator Authentication Method
Step 4: Create the Initialization Parameter File
这里配置了几个参数:
CONTROL_FILES='/home/datafile/control01.ctl','/home/datafile/control02.ctl'
DB_NAME=yfocp
UNDO_MANAGEMENT=AUTO
Step 5: (Windows Only) Create an Instance
Step 6: Connect to the Instance
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 9 00:41:44 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/tmp/pfile.ora';
Step 7: Create a Server Parameter File
SQL> create spfile from pfile='/tmp/pfile.ora';
File created.
SQL> create spfile from pfile='/tmp/pfile.ora';
File created.
SQL> startup nomount;
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 238034944 bytes
Fixed Size 2227136 bytes
Variable Size 180356160 bytes
Database Buffers 50331648 bytes
Redo Buffers 5120000 bytes
SQL> create pfile from spfile;
File created.
Step 9: Issue the CREATE DATABASE Statement
从oracle官方文档中有实例
CREATE DATABASE yfocp
USER SYS IDENTIFIED BY a123456
USER SYSTEM IDENTIFIED BY a123456
LOGFILE GROUP 1 ('/home/datafile/redo01a.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/home/datafile/redo02a.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/home/datafile/redo03a.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 100
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/home/datafile/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/home/datafile/sysaux01.dbf' SIZE 500M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/datafile/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/home/datafile/undotbs01.dbf'
SIZE 200M ;
可以查看 trace日志:路径 /data/oracle/product/11.2.0/db_1/log/diag/rdbms/yfocp/yfocp/trace
Step 10: Create Additional Tablespaces
创建默认表空间的数据文件
SQL> create tablespace users datafile '/home/datafile/user01.dbf' size 200M;
Tablespace created.
设置默认表空间:
alter database default tablespace users;
Step 11: Run Scripts to Build Data Dictionary Views
@?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql @?/sqlplus/admin/pupbld.sql
11g与10g的官方文档上有些区别。在第三个脚本
Step 12: (Optional) Run Scripts to Install Additional Options