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. export 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博客

OCM-手动建库

最新文章