已提前最小化安装centos7.5和oracle 11g r2裸数据库软件，记录下手工建库过程，方便了解dbca建库原理。
1.环境变量设置
#设置环境变量
cat >> /home/oracle/.bash_profile <<eof
export oracle_base=/u01/app/oracle
export oracle_home=/u01/app/oracle/product/11.2.0/db_1
export oracle_sid=std1
export path=$oracle_home/bin:/sbin:/usr/sbin:$path
eof
source /home/oracle/.bash_profile
#设置命令别名
cat >> /home/oracle/.bashrc <<eof
alias dbn=’cd $oracle_home/network/admin’
alias dbs=’cd $oracle_home/dbs’
alias sql=’sqlplus / as sysdba’
eof
source /home/oracle/.bashrc
#设置sqlplus环境
cat >> $oracle_home/sqlplus/admin/glogin.sql <<eof
define _editor=’vi’
set sqlprompt “_user’@’_connect_identifier> ”
set time on
set timing on
set pagesize 40
set linesize 120
eof
2.创建所需目录
mkdir -p $oracle_base/admin/std1/adump && mkdir -p $oracle_base/oradata/std1 && mkdir -p $oracle_base/flash_recovery_area
3.生成密码文件
dbn
orapwd file=orapwstd1 password=oracle entries=3
4.创建pfile参数文件
cat init.ora | grep -v ^# | grep -v ^$ > initstd1.ora
%s/orcl/std1/g
%s/orcl/std1/g
%s#<oracle_base>#$oracle_base/g
%s#ora_control1#/u01/app/oracle/oradata/std1/ora_control1.ctl#g
%s#ora_control2#/u01/app/oracle/oradata/std1/ora_control2.ctl#g
db_name=’std1′
memory_target=1g
processes = 150
audit_file_dest=’$oracle_base/admin/std1/adump’
audit_trail =’db’
db_block_size=8192
db_domain=”
db_recovery_file_dest=’$oracle_base/flash_recovery_area’
db_recovery_file_dest_size=2g
diagnostic_dest=’$oracle_base’
dispatchers='(protocol=tcp) (service=std1xdb)’
open_cursors=300
remote_login_passwordfile=’exclusive’
undo_tablespace=’undotbs1′
control_files = (/u01/app/oracle/oradata/std1/ora_control1.ctl,/u01/app/oracle/oradata/std1/ora_control2.ctl)
compatible =’11.2.0′
5.生成spfile参数文件
mount -o remount,size=4g /dev/shm
sqlplus / as sysdba
startup nomount
create spfile from pfile;
6.执行创建数据库语句
vi crtdb.sql
create database std1
user sys identified by oracle
user system identified by oracle
logfile group 1 (‘/u01/app/oracle/oradata/std1/redo01a.log’,’/u01/app/oracle/oradata/std1/redo01b.log’) size 100m blocksize 512,
group 2 (‘/u01/app/oracle/oradata/std1/redo02a.log’,’/u01/app/oracle/oradata/std1/redo02b.log’) size 100m blocksize 512
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 100
character set us7ascii
national character set al16utf16
extent management local
datafile ‘/u01/app/oracle/oradata/std1/system01.dbf’ size 325m reuse
sysaux datafile ‘/u01/app/oracle/oradata/std1/sysaux01.dbf’ size 325m reuse
default tablespace users
datafile ‘/u01/app/oracle/oradata/std1/users01.dbf’
size 500m reuse autoextend on maxsize unlimited
default temporary tablespace tempts1
tempfile ‘/u01/app/oracle/oradata/std1/temp01.dbf’
size 20m reuse
undo tablespace undotbs1
datafile ‘/u01/app/oracle/oradata/std1/undotbs01.dbf’ size 200m reuse autoextend on maxsize unlimited;
@crtdb.sql
7.生成数据字典
vi crtdic.sql
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
exit
@crtdic.sql
8.检查一哈
select * from v$version;