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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29362142/viewspace-2135956/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29362142/viewspace-2135956/