ORACLE9I的两个脚本！！！

yllmm80512

initoradb.ora文件：


db_name = oradb
instance_name = oradb
control_files = ('/opt/oracle/oradata/oradb/ora_control1.ctl', '/opt/oracle/oradata/oradb/ora_control2.ctl')

db_block_size = 8192

pga_aggregate_target = 50M
db_cache_size = 100M
shared_pool_size = 50M

processes = 200
sessions = 500
open_cursors = 500
db_writer_processes = 2

db_file_multiblock_read_count = 16

log_checkpoint_interval = 0
log_checkpoint_timeout = 0
log_buffer = 524288
log_archive_start = true
log_archive_dest_1 = "location=/opt/oracle/oradata/oradb/arch"
log_archive_format = %T_%S.dbf

background_dump_dest = /opt/oracle/admin/oradb/bdump
core_dump_dest = /opt/oracle/admin/oradb/cdump
user_dump_dest = /opt/oracle/admin/oradb/udump

undo_management = auto
undo_tablespace = tbsundo

parallel_automatic_tuning = true
#parallel_threads_per_cpu = 2

compatible = 9.0.0
optimizer_features_enable = 9.0.0

#db_domain =
#remote_login_passwordfile = exclusive


createdb.sh文件：

sqlplus /nolog <<EOF
connect / as sysdba
startup nomount pfile=${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora

create database ${ORACLE_SID}
user sys identified by sys
user system identified by system
logfile group 1 ('${ORACLE_BASE}/oradata/${ORACLE_SID}/redo01.log') size 10M,
group 2 ('${ORACLE_BASE}/oradata/${ORACLE_SID}/redo02.log') size 10M,
group 3 ('${ORACLE_BASE}/oradata/${ORACLE_SID}/redo03.log') size 10M
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 254
maxinstances 1
archivelog
character set ZHS32GB18030
national character set AL16UTF16
datafile '${ORACLE_BASE}/oradata/${ORACLE_SID}/system01.dbf' size 300M
default temporary tablespace tbstemp tempfile '${ORACLE_BASE}/oradata/${ORACLE_SID}/temp01.dbf' size 500M
undo tablespace tbsundo datafile '${ORACLE_BASE}/oradata/${ORACLE_SID}/undo01.dbf' size 500M;

connect sys/sys as sysdba
@${ORACLE_HOME}/rdbms/admin/catalog.sql
@${ORACLE_HOME}/rdbms/admin/catproc.sql
create spfile from pfile='${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/init${ORACLE_SID}.ora';

connect system/system
@${ORACLE_HOME}/sqlplus/admin/pupbld.sql

exit
EOF

yllmm80512

大家顶啊！！