一、pfile
[oracle@10g dbs]$vi inithis.ora
his.__db_cache_size=138412032
his.__java_pool_size=50331648
his.__large_pool_size=4194304
his.__shared_pool_size=163577856
his.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/his/adump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/app/oracle/oradata/his/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='his'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=hisXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=120586240
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=361758720
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.diagnostic_dest=/oracle/app/oracle
*.job_queue_processes=50
创建相关文件夹
mkdir -p /oracle/admin/his/adump
二、密码文件
orapwd file=orapwdhis password=oracle entries=30
三、创建数据库脚本createdb.sql
startup nomount
CREATE DATABASE HIS
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/his/redo01a.log','/oracle/app/oracle/oradata/his/redo01b.log') SIZE 50M BLOCKSIZE 512,
GROUP 2 ('/oracle/app/oracle/oradata/his/redo02a.log','/oracle/app/oracle/oradata/his/redo02b.log') SIZE 50M BLOCKSIZE 512,
GROUP 3 ('/oracle/app/oracle/oradata/his/redo03a.log','/oracle/app/oracle/oradata/his/redo03b.log') SIZE 50M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/oracle/app/oracle/oradata/his/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/oracle/app/oracle/oradata/his/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/oracle/app/oracle/oradata/his/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/app/oracle/oradata/his/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/oracle/app/oracle/oradata/his/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
@createdb.sql
四、添加数据字典
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
五、创建spfile
create spfile from pfile;
shutdown immediate
startup
