scripts of create database

时间：2010-05-30 来源：rushmeplz

1.create init.ora log_archive_dest_1='LOCATION=/arch/'
log_archive_format=%t_%s_%r.dbf

db_block_size=8192
db_file_multiblock_read_count=16

open_cursors=300

db_domain=""
db_name=gc

background_dump_dest=/oracle/admin/gc/bdump
core_dump_dest=/oracle/admin/gc/cdump
user_dump_dest=/oracle/admin/gc/udump

control_files=("/oracle/oradata/gc/control01.ctl", "/oracle/oradata/gc/control02.ctl", "/oracle/oradata/gc/control03.ctl")

job_queue_processes=10

compatible=10.2.0.3.0

processes=150

sga_target=205520896

audit_file_dest=/oracle/admin/gc/adump
remote_login_passwordfile=EXCLUSIVE

pga_aggregate_target=68157440

undo_management=AUTO
undo_tablespace=UNDOTBS1 create spfile='/oracle/programs/dbs/spfilegc.ora' from pfile='/oracle/programs/dbs/init.ora' SQL> startup nomount; 2.createdb.sql CREATE DATABASE gc
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/oracle/oradata/gc/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oracle/oradata/gc/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle/oradata/gc/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oracle/oradata/gc/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oracle/oradata/gc/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/oradata/gc/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/oradata/gc/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY ABCabc123 USER SYSTEM IDENTIFIED BY ABCabc123; 3.postcreate orapwd file=/oracle/programs/dbs/orapwgc password=ABCabc123 force=y @/oracle/programs/rdbms/admin/catalog.sql;
@/oracle/programs/rdbms/admin/catblock.sql;
@/oracle/programs/rdbms/admin/catproc.sql;
@/oracle/programs/rdbms/admin/catoctk.sql;
@/oracle/programs/rdbms/admin/owminst.plb; @/oracle/programs/sqlplus/admin/pupbld.sql; @/oracle/programs/sqlplus/admin/help/hlpbld.sql helpus.sql; alter database archivelog; alter database default tablespace users;

相关阅读更多 +