scripts of create database

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;