里面只有这么一句:Instance prod has been terminated.
解决方案 »
- 关于本地net服务配置!
- SQL server中的连接函数或者连接符
- 有关sql语句急!!!
- 用PLSQL连接服务器,是不是要先在本地先开启oracle的服务?
- 关于用cmd命令导出oracle数据库的问题?
- ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
- ORA-12154: TNS:could not resolve the connect identifier specified
- oracle 起动不了log文件有问题 在线等
- 如何建立如下约束?立即给分!
- 任意时间的前15天怎么写!在线!
- oracle权限问题
- 小妹正在学习oracle10g,请高手指点一下.
Dump file E:\OraData\PROD\Trace\prodALRT.LOG
Thu Jun 10 21:07:57 2004
ORACLE V8.1.6.3.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.3.0.
System parameters with non-default values:
processes = 200
resource_limit = TRUE
shared_pool_size = 350000000
large_pool_size = 67108864
java_pool_size = 10485760
control_files = E:\OraData\PROD\control01.ctl, E:\OraData\PROD\control02.ctl, E:\OraData\PROD\control03.ctl
db_block_buffers = 65536
db_block_size = 8192
compatible = 8.1.0
log_buffer = 524288
log_checkpoint_interval = 10000000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
rollback_segments = RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14, RBS15, RBS16
max_enabled_roles = 100
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 10
instance_name = PROD
service_names = PROD
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 1024000
sort_area_retained_size = 1024000
db_name = PROD
open_cursors = 400
os_authent_prefix =
optimizer_mode = rule
job_queue_processes = 4
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = E:\OraData\PROD\Trace
user_dump_dest = E:\OraData\PROD\Trace
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Thu Jun 10 21:08:00 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jun 10 21:08:01 2004
alter database mount exclusive
Thu Jun 10 21:08:08 2004
Successful mount of redo thread 1, with mount id 4235346360.
Thu Jun 10 21:08:08 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jun 10 21:08:08 2004
alter database open
Thu Jun 10 21:08:10 2004
Thread 1 opened at log sequence 1013
Current log# 4 seq# 1013 mem# 0: E:\ORADATA\PROD\REDO001.LOG
Current log# 4 seq# 1013 mem# 1: E:\ORADATA\PROD\REDO004.LOG
Successful open of redo thread 1.
Thu Jun 10 21:08:10 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jun 10 21:08:27 2004
Completed: alter database open
Fri Jun 11 00:42:36 2004
Thread 1 advanced to log sequence 1014
Current log# 5 seq# 1014 mem# 0: E:\ORADATA\PROD\REDO002.LOG
Current log# 5 seq# 1014 mem# 1: E:\ORADATA\PROD\REDO005.LOG
Fri Jun 11 01:11:29 2004
Thread 1 advanced to log sequence 1015
Current log# 6 seq# 1015 mem# 0: E:\ORADATA\PROD\REDO003.LOG
Current log# 6 seq# 1015 mem# 1: E:\ORADATA\PROD\REDO006.LOG
Fri Jun 11 10:07:30 2004
Thread 1 advanced to log sequence 1016
Current log# 4 seq# 1016 mem# 0: E:\ORADATA\PROD\REDO001.LOG
Current log# 4 seq# 1016 mem# 1: E:\ORADATA\PROD\REDO004.LOG