db_name = "test"
instance_name = test
service_names = test
db_files = 1024
control_files = ("D:\Oracle\oradata\test\control01.ctl", "D:\Oracle\oradata\test\control02.ctl", "D:\Oracle\oradata\test\control03.ctl")
open_cursors = 200
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 4096
shared_pool_size = 52428800
large_pool_size = 78643200
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 115
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = true
oracle_trace_collection_name = ""
background_dump_dest = D:\Oracle\admin\test\bdump
user_dump_dest = D:\Oracle\admin\test\udump
db_block_size = 16384
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
mts_dispatchers = "(protocol=TCP)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536# log_archive_start = true
# log_archive_dest_1 = "location=D:\Oracle\oradata\oradb\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
instance_name = test
service_names = test
db_files = 1024
control_files = ("D:\Oracle\oradata\test\control01.ctl", "D:\Oracle\oradata\test\control02.ctl", "D:\Oracle\oradata\test\control03.ctl")
open_cursors = 200
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 4096
shared_pool_size = 52428800
large_pool_size = 78643200
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 115
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = true
oracle_trace_collection_name = ""
background_dump_dest = D:\Oracle\admin\test\bdump
user_dump_dest = D:\Oracle\admin\test\udump
db_block_size = 16384
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
mts_dispatchers = "(protocol=TCP)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536# log_archive_start = true
# log_archive_dest_1 = "location=D:\Oracle\oradata\oradb\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
解决方案 »
- 关于oracle子查询简单语句帮忙下,老是死掉,查询一张表
- 数据库 表/索引的定义放在哪个系统表,我想导出整个schema 的DML?
- 重新安装ora9i出现问题 急!!!!
- 请教一个拼动态sql的问题
- 请问那里有Oracle的LogMiner下载
- 请大家指教rownum的具体用法
- win2000server下装oracle9.2到51%(oracle JVM)就停掉了,没有提示,等了大概2个小时还没有进展,这是为什么???????????在线
- 如何使用dbms_sql?
- 请教几个SQL问题~急,在线等~~请高手指教
- @@@关于在ORACLE中更新的问题
- 求报表思路
- redhat7.2下安装oracle817和是一种合适的搭配吗?
# Copyright (c) 1991, 2001 by Oracle Corporation
##############################################################################
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
###########################################
# 其他
###########################################
compatible=9.0.0
db_name=girl
###########################################
# 分布式, 复制和快照
###########################################
db_domain=net
remote_login_passwordfile=SHARED
###########################################
# 排序, 散列联接, 位图索引
###########################################
sort_area_size=524288
###########################################
# 文件配置
###########################################
control_files=("I:\oracle\oradata\girl\CONTROL01.CTL", "I:\oracle\oradata\girl\CONTROL02.CTL", "I:\oracle\oradata\girl\CONTROL03.CTL")
###########################################
# 池
###########################################
java_pool_size=33554432
large_pool_size=1048576
shared_pool_size=33554432
###########################################
# 游标和库高速缓存
###########################################
open_cursors=300
###########################################
# 系统管理的撤销和回退段
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS
###########################################
# 网络注册
###########################################
instance_name=girl
###########################################
# 诊断和统计
###########################################
background_dump_dest=I:\oracle\admin\girl\bdump
core_dump_dest=I:\oracle\admin\girl\cdump
timed_statistics=TRUE
user_dump_dest=I:\oracle\admin\girl\udump
###########################################
# 进程和会话
###########################################
processes=150
###########################################
# 重做日志和恢复
###########################################
fast_start_mttr_target=300
###########################################
# 高速缓存和 I/O
###########################################
db_block_size=4096
db_cache_size=33554432
db_name=create_name
db_create_file_dest=f:\file
db_create_online_log_dest_1=f:\log
db_create_online_log_dest_2=f:\log
INITTEST.ORA
##############################################################
######### THIS IS A initialize FILE OF DATABASE TEST #########
######### WROTE BY LEON AT 2005-05-06 #########
##############################################################
DB_NAME=TEST
INSTANCE_NAME=TEST
CONTROL_FILES=("D:\oracle\oradata\TEST\CONTROL01.CTL", "D:\oracle\oradata\TEST\CONTROL02.CTL", "D:\oracle\oradata\TEST\CONTROL03.CTL")
BACKGROUND_DUMP_DEST=D:\oracle\admin\TEST\Bdump
USER_DUMP_DEST=D:\oracle\admin\TEST\udump
DB_BLOCK_SIZE=2048
DB_CACHE_SIZE=6M
SHARED_POOL_SIZE=10485760
LOG_BUFFER=32768
UNDO_TABLESPACE=UNDO_TESTDB_TBS1TESTDB.SQL
SPOOL D:\ORACLE\ADMIN\TEST\CREATE\CREATEDB.LOG
CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHISTORY 1000
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 100
LOGFILE
GROUP 1('D:\ORACLE\ORADATA\REDO1A.LOG') SIZE 1M,
GROUP 2('D:\ORACLE\ORADATA\REDO2A.LOG') SIZE 1M
DATAFILE 'D:\ORACLE\ORADATA\SYSTEM01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 10M
UNDO TABLESPACE UNDO_TESTDB_TBS1
DATAFILE 'D:\ORACLE\ORADATA\UNDO_TEST01.DBF' SIZE 10M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'D:\ORACLE\ORADATA\TEMP.DBF' SIZE 10M
CHARACTER SET ZHS16GBK;
SPOOL OFF
请大家看看有什么问题?
Dump file d:\oracle\admin\test\bdump\test_pmon_268.trc
Sat May 08 11:04:53 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: testRedo thread mounted by this instance: 1Oracle process number: 2Windows thread id: 268, image: ORACLE.EXE
*** 2004-05-08 11:04:53.000
*** SESSION ID:(1.1) 2004-05-08 11:04:53.000
error 1519 detected in background process
ORA-01519: error while processing file '' near line Dump file d:\oracle\admin\test\udump\test_ora_1500.trc
Sat May 08 11:04:52 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: testRedo thread mounted by this instance: 1Oracle process number: 8Windows thread id: 1500, image: ORACLE.EXE
*** SESSION ID:(7.1) 2004-05-08 11:04:52.000
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???
Offending statement at line 5161
CREATE UNDO TABLESPACE UNDO_TESTDB_TBS1 DATAFILE 'D:\ORACLE\ORADATA\UNDO_TEST01.DBF' SIZE 10M
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???CREATE DATABASE TEST
*
ERROR位于第一行
ORA-01092:ORACLE例程终止 强行断开连接
请问我错在哪里? 应当如何该?