OCM-手动建库

create database script
1.编辑初始化参数文件
db_name=PROD （只要这个一个参数也能起来库）
instance_name=PROD
sga_target=400M
pga_aggreagte_target=100M
undo_management=auto
undo_tablespace=undotbs
undo_retention=900
2.create password file
orapwd file=$ORACLE_BASE/dbs/orapwPROD password=oracle entries=5 force=y
3 . exp ort ORACLE_SID=PROD
sqlplus / as sysdba
startup mount
create database PROD ....
===========================================================================================================================
Example:
create database orcl
maxinstances 1
maxloghistory 1 
maxlogfiles 5
maxmembers 5 
maxdatafiles 50 
logfile group 1 
{'/u01/app/oracle/oradata/orcl/redo01a.log','/u01/app/oracle/oradata/orcl/redo01b.log'}
size 100M,
group 2 
{'/u01/app/oracle/oradata/orcl/redo02a.log','/u01/app/oracle/oradata/orcl/redo02b.log'}
size 100m
datafile 'u01/app/oracle/oradata/orcl/system01.dbf' size 200M autoextend on extent management
local
sysaux datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' size 40M autoextend on 
[smallfile(默认就是smallfile)] undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/orcl
/undotbs01,dbf' size 150M autoextend on 
[smallfile(默认就是smallfile)] default temporary temp tempfile '/u01/app/oracle/oradata/orcl
/temp01.dbf' size 20M autoextend on 
character set utf8
national character set utf8 
user sys identified by oracle 
user system identified by oracle

=========================================================================================


Post tasks after manual creat database creation 
@？/rdbms/admin/catalog.sql
@？/rdbms/admin/catblock.sql
@？/rdbms/admin/catproc.sql
@？/rdbms/admin/catoctk.sql
@？/rdbms/admin/owminst.sql
@？/rdbms/admin/pupbld.sql
execute utl_recomp.recomp_serial();

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29362142/viewspace-2135957/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29362142/viewspace-2135957/