unixware7基本问题集锦( 三 ) _云知道

always_anti_join=HASH
log_buffer = 524288
#audit_trail = db
#timed_statistics = true
max_dump_file_size = 10240
job_queue_processes=5
BACKGROUND_DUMP_DEST=/leinew/oradata/bdump
core_dump_dest=/leinew/oradata/cdump
standby_archive_dest=/leinew/oradata/orastandby
oracle_trace_facility_path=/leinew/oradata/oratracefdf
oracle_trace_collection_path=/leinew/oradata/oratracecdf
audit_file_dest=/leinew/oradata/auditfile
user_dump_dest=/leinew/oradata/udump
#LOG_ARCHIVE_MAX_PROCESSES=2
#log_archive_start=true
#log_archive_dest_1="LOCATION=/leinew/oradata/archivelog"
#log_archive_format ="T%TS%S.ARC"
#UTL_FILE_DIR=/leinew/oradata/utlfile/
#UTL_FILE_DIR=/leinew/export/zhdoc/public/infdbf/inf/
#UTL_FILE_DIR=/leinew/export/zhdoc/public/infdbf/tide/
#UTL_FILE_DIR=/leinew/export/zhdoc/public/infdbf/life/
UTL_FILE_DIR= *
resource_limit=true
sort_area_size=4194304
open_cursors=512
#pre_page_sga=yes
NLS_DATE_FORMAT="YYYY-MM-DD"
dbwr_io_slaves=2
large_pool_size=10485760
dml_locks=2000
#cursor_space_for_time=true
#session_cached_cursors=50
rollback_segments = (rbs01,rbs02,rbs03,rbs04,rbs05)
global_names = TRUE
db_domain =wgora.com.cn
control_files = (/leinew/oradata/control1.ctl,/app/oracle/control2.ctl)
mts_service=wgdb
mts_dispatchers="(address=(protocol=tcp)(host=61.129.74.15)(port=5000))(dispatc
hers=1)(pool=on)(tick=1)(connections=1000)(sessions=4000)"
mts_max_dispatchers=5
mts_max_servers=100
mts_servers=5
compatible = 8.1.0手工创建数据库
首先建立几个目录/leinew/oradata (pfile、bdump、cdump、udump、archivelog、orastandby、logs、oratracecdf、oratracefdf、utlfile)
1、建立数据库系统表空间
create database wgoradb
datafile "/leinew/ oradata/system01.dbf" size 500M
logfile group 1(/leinew/ oradata /redo_01a.log",
"/leinew/ oradata /redo_01b.log") size 50M,
group 2("/leinew/ oradata /redo_02a.log",
"/leinew/ oradata /redo_02b.log") size 50M,
group 3("/leinew/ oradata /redo_03a.log",
"/leinew/ oradata /redo_03b.log") size 50M,
group 4("/leinew/ oradata /redo_04a.log",
"/leinew/ oradata /redo_04b.log") size 50M
character set us7ascii
national character set us7ascii;create rollback segment rbs_temp
tablespace system
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs_temp online;
2、运行脚本
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/catexp.sql;
3、建立回滚表空间
create tablespace rbs01_ts
datafile "/leinew/oradata/rbs01_ts.dbf" size 200M
default storage(pctincrease 0);
create rollback segment rbs01
tablespace rbs01_ts
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs01 online;
create rollback segment rbs02
tablespace rbs01_ts
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs02 online;
create rollback segment rbs03
tablespace rbs01_ts
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs03 online;
create rollback segment rbs04
tablespace rbs01_ts
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs04 online;
create rollback segment rbs05
tablespace rbs01_ts
storage(initial 100k next 100k minextents 2 optimal 500k);
alter rollback segment rbs05 online;
4、建立各个表空间
create tablespace temp01_ts
datafile "/leinew/oradata/temp01_ts.dbf" size 200M
default storage(pctincrease 0);
create tablespace tools01_ts
datafile "/leinew/oradata/tools01_ts.dbf" size 100M
default storage(pctincrease 0);
create tablespace data01_ts
datafile "/leinew/oradata/data01_ts.dbf" size 500M
default storage(pctincrease 0);
create tablespace index01_ts
datafile "/leinew/oradata/index01_ts.dbf" size 300M

unixware7基本问题集锦( 三 )

推荐阅读

翡翠原石的形成过程是什么翡翠原石的形成过程简述

买新能源汽车好吗

啤酒可以泡脚吗

新暖壶用之前怎么清洗《新暖壶使用前怎么处理》

ceers是什么牌子沙发

老桩多肉植物怎么养夏天怎么养多肉老桩

vivo钱包怎么卸载

洗衣液能不能带上高铁

一个青和一个黄是什么成语

一火车拦在本溪城区近1小时！致交通拥堵，路人翻火车穿行！铁路部门回应

我的好闺蜜500字作文

酒店行业工资,在酒店上班是一种怎样的体验

肯定句和陈述句的区别

核酸捅喉咙怎么考

反思如何提高成功率,如何踢好临门一脚

泰迪狗不打疫苗会怎么样