系统数据库配置

操作系统：windows server 2003 r2 x64 sp2
数据库：oracle 10.2.0.4


操作系统密码：gdrmyy
数据库sys/system的密码：bsoft


数据库配置：

全局实例名：bsrun

表空间创建：

create tablespace portal_his
datafile 'F:\oracle\product\10.2.0\oradata\bruce\portal_his.dbf' size 2048M
autoextend on maxsize unlimited segment space management auto;（三组20G数据文件）

create tablespace portal
datafile 'F:\oracle\product\10.2.0\oradata\bruce\portal.dbf' size 2048M
autoextend on maxsize unlimited segment space management auto;

create tablespace portal_emr
datafile 'F:\oracle\product\10.2.0\oradata\bruce\portal_emr.dbf' size 1024M
autoextend on maxsize unlimited segment space management auto;（三组20G数据文件）

用户创建：

create user portal_his identified by bsoft
default tablespace portal_his
temporary tablespace temp;

create user portal identified by bsoft
default tablespace portal
temporary tablespace temp;

create user portal_emr identified by bsoft
default tablespace portal_emr
temporary tablespace temp;

用户授权：

grant connect,resource,dba to portal_his,portal,portal_emr;

数据库修改参数：

alter system set sga_max_size=4096M scope=spfile;
alter system set sga_target=4096M scope=spfile;
alter system set pga_aggregate_target = 2048M scope=spfile;
alter system set cpu_count=14 scope=spfile;
alter system set dml_locks=200000 scope=spfile;


alter system set max_dispatchers=20 scope=spfile;
alter system set max_shared_servers = 20 scope=spfile;
alter system set sessions = 1500 scope=spfile;
alter system set processes=1200 scope=spfile;
alter system set shared_servers=20 scope=spfile;
alter system set dispatchers='(protocol=tcp)(disp=20)' scope=spfile;