3.确定初始化文件 cd $ORACLE_HOME/dbs
cat init.ora |grep -v ^# |grep -v ^$>initocmdb.ora //修改里面的db_name和controlfile
vi initocmdb.ora //删除其他内存参数:db_block_buffers.shared_pool_size,增加sga_max_size和sga_target均为300Mdb_name=ocmdb
control_files = (/oracle/app/oracle/oradata/ocmdb/cfile/ora_control1,/oracle/app/oracle/oradata/ocmdb/cfile/ora_control2,/oracle/app/oracle/oradata/ocmdb/cfile/control3)–-//这个为考试指定的目录
//将sga_max_size和sga_target均为300M,不然会报错:
SQL> startup nomount pfile=’?/dbs/initocmdb.ora’;
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
4.生成密码文件: cd $ORACLE_HOME/dbs
orapwd file=orapwocmdb password=change_on_install entries=10
5.create spfile from pfile; 再 shutdown abort,再startup nomount;
##修改其他初始化参数:
alter system set undo_management=auto scope=spfile;
–后面用的create语句要求用auto管理的undo(Data Management 之 Set parameters for retaining undo)
alter system set db_create_file_dest=’/oracle/app/oracle/oradata/ocmdb/dfile’ scope=spfile;
–这个题目有要求(Create and manage database configuration files)
alter system set db_create_online_log_dest_1=’/oracle/app/oracle/oradata/ocmdb/lfile’ scope=spfile;
–这个题目有要求(Create and manage database configuration files)
alter system set job_queue_processes =5 scope=spfile;
–这个后面oem的时候要用(Enterprise Manager Grid Control 之 Create schedules)
alter system set background_dump_dest=’/oracle/app/oracle/admin/ocmdb/bdump’ scope=spfile;
alter system set core_dump_dest= ‘/oracle/app/oracle/admin/ocmdb/cdump’ scope=spfile;
alter system set user_dump_dest=’/oracle/app/oracle/admin/ocmdb/udump’ scope=spfile;
alter system set audit_file_dest=’/oracle/app/oracle/admin/ocmdb/adump’ scope=spfile;
shutdown abort; startup nomount
6.找到create database语句:
找在线文档administrator guide-Part I Basic Database Administration-2 creating an oracle database – Step 7: Issue the CREATE DATABASE Statement
修改其中的dbname,里面的数据文件的路径。
CREATE DATABASE ocmdb
USER SYS IDENTIFIED BY change_on_install
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 (‘/oracle/app/oracle/oradata/ocmdb/lfile/redo01.log’) SIZE 100M,
GROUP 2 (‘/oracle/app/oracle/oradata/ocmdb/lfile/redo02.log’) SIZE 100M,
GROUP 3 (‘/oracle/app/oracle/oradata/ocmdb/lfile/redo03.log’) SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/system01.dbf’ SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/sysaux01.dbf’ SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1 datafile ‘/oracle/app/oracle/oradata/ocmdb/dfile/tbs_1.dbf’ size 50m
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/temp01.dbf’
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE ‘/oracle/app/oracle/oradata/ocmdb/dfile/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;