将oracle这个orasid的服务重启就ok了。??????
你的Oracle库crash了?检查alert.log
你的Oracle库crash了?检查alert.log
解决方案 »
- sql执行一句停顿
- 表的连接方法
- select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; 为何出错
- 求一条SQL文,多记录合并
- 如何提高速度
- 我的问题没一个回答,是不是因为很难??
- 有人懂TOAD吗?
- 各位好,小弟初学Oracle,请各位指点哪有相关电子书下载,多谢!
- Error while registering Oracle JDBC Diagnosability MBean.
- oracle 存储问题
- 【求助】请问Oracle创建表时指定的default可以为序列吗?
- 如何实现主键id 的自增---oracle菜鸟~~急
只有我重起服务的日志。
如下:
Tue May 30 13:20:35 2006
ORACLE V8.1.7.0.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.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 372056678
large_pool_size = 15728640
java_pool_size = 32768
control_files = F:\oracle\oradata\SPL01\CONTROL\control01.ctl, F:\oracle\oradata\SPL01\CONTROL\control02.ctl, F:\oracle\oradata\SPL01\CONTROL\control03.ctl
db_block_buffers = 136185
db_block_size = 8192
compatible = 8.1.0
log_archive_start = TRUE
log_archive_dest_1 = location=F:\oracle\oradata\SPL01\archive
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 10
instance_name = SPL01
service_names = SPL01
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = SPL01
open_cursors = 300
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = c:\oracle\admin\SPL01\bdump
user_dump_dest = c:\oracle\admin\SPL01\udump
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
Tue May 30 13:20:37 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
Tue May 30 13:20:38 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue May 30 13:20:38 2006
alter database mount exclusive
但是在这两个月中,每日都是如此的问题。我试了,将export不运行,那么就没有问题。