ocm考试之section0手动建库
#Section0手动建库(1)确定实例名
export ORACLE_SID=test
(2)建立密码文件
orapwd file=orapwtest password=oracle
(3)建立pfile
cat init.ora|grep -v ^ #|grep -v $ > inittest.ora
vi inittest.ora
db_name=test
sga_target=350m
controlfiles=(xxx,xxx)
undo_management=auto
processes=150
db_block_size=8192
log_buffer=50000000
undo_tablespace=undotbs
background_dump_dest
croe_dump_dest
user_dump_dest
(4)建立spfile并启动实例
sqlplus / as sysdba
create spfile from pfile;
startup nomount
(5)建库语句
create database test
user sys identified by oracle
user system identified by oracle
logfile group 1 ('/u01/oradata/test/redo01.log') size 100m,
group 2 ('/u01/oradata/test/redo02.log') size 100m,
group 3 ('/u01/oradata/test/redo03.log') size 100m
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 100
maxinstances 1
character set us7ascii
national character set al16utf16
datafile '/u01/oradata/test/system01.dbf' size 325m reuse
extent management local
sysaux datafile '/u01/oradata/test/sysaux01.dbf' size 325 reuse
default temporary tablespace tempts1
tempfile '/u01/oradata/test/temp01.dbf' size 20m reuse
undo tablespace undotbs
datafile '/u01/oradata/test/undotbs01.dbf' size 200m reuse autoentend on;
(6)运行脚本
sqlplus / as sysdba
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb
sqlplus system/oracle
@?/rdbms/admin/pupbld.sql
#section0注意事项
(1)按题目要求设置"字符集"
(2)有5块磁盘，建库建在指定位置
(3)算好冷备时间，使数据库处于open状态
(4)没有明确要求备份时，可以不备份
(5)将两台机器的主机名和IP写入/etc/hosts
参考联机文档
administrator's guid -> creating a oracle database -> manually creating a oracle database
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]