手动创建数据库

1、建立参数文件
*.compatible='9.2.0.0.0'
*.control_files='c:\oracle\control01.ctl'
*.core_dump_dest='C:\oracle\cdump'
*.background_dump_dest='C:\oracle\bdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='trc'
*.java_pool_size=0
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.user_dump_dest='C:\oracle\udump'
2、创建上述参数中相关的目录
mkdir -p /../../bdump
3、设置环境变量oracle_sid
set oracle_sid=trc
4、创建实例
oradim -new -sid trc
5、创建口令文件
orapwd file=c:\windows\oracle9i\database\pwdtrc.ora password=pwd entries=5
6、启动数据库到nomount状态
sqlplus "/ as sysdba"
startup nomount pfile=c:\oracle\init.ora
7、执行建库脚本
Create database trc
datafile 'c:\oracle\system01.dbf' size 300M extent management local
--sysaux datafile 'c:\oracle\sysaux01.dbf' size 120M
default temporary tablespace temp tempfile 'c:\oracle\temp01.dbf' size 20M
undo tablespace "UNDOTBS1" datafile 'c:\oracle\undotbs01.dbf' size 200M
logfile group 1 ('c:\oracle\redo01.log') size 10240K,
        group 2 ('c:\oracle\redo02.log') size 10240K,
        group 3 ('c:\oracle\redo03.log') size 10240K;
8、创建数据字典，创建PLSQL包，exp必须表
以下3个脚本sys执行
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
下脚本使用system执行
alter user system identified by system;
conn system/system
@?/sqlplus\admin\pupbld.sql