这个错误是这样的:ORA-01092: ORACLE instance terminated. Disconnection forced!!!LGWR: terminating instance due to error 204
Instance terminated by LGWR, pid = 4请问这个错误应该怎么解决?
如果需要我可以把整个日志文件贴出来?请高手相助
Instance terminated by LGWR, pid = 4请问这个错误应该怎么解决?
如果需要我可以把整个日志文件贴出来?请高手相助
解决方案 »
- ora-01092:oracle instance terminated disconnection forced
- oracle:Connection time out
- 如何处理节假日问题
- 怎么去优化oracle组合查询???
- vb开发基于oracle的应用,为了读出clob字段..一到dbms_lob.read函数就不对了;
- 怎么修改Oracle 10g里面的这几个job相关的参数
- 新手提问
- 如何从一个Oracle 9i的数据文件夹恢复该数据库?
- ORACLE 9I中建表的脚本都 执行了,我的表去哪里能看到啊,在(oem)中
- oracle8i刚刚在rh下装完,怎么更改不了sys和system的密码?
- 想来日本工作的话,请联系
- 找错误
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 = 37168435
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\oracle\oradata\orcl\control01.ctl, D:\oracle\oradata\orcl\control02.ctl, D:\oracle\oradata\orcl\control03.ctl
db_block_buffers = 13611
db_block_size = 8192
compatible = 8.1.0
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 = 500
instance_name = orcl
service_names = orcl
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = orcl
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\orcl\bdump
user_dump_dest = D:\oracle\admin\orcl\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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Nov 04 11:03:04 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 04 11:03:09 2005
alter database mount exclusive
Fri Nov 04 11:03:18 2005
Successful mount of redo thread 1, with mount id 1101271413.
Fri Nov 04 11:03:18 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Nov 04 11:03:18 2005
alter database open
Fri Nov 04 11:03:19 2005
Rolling back half complete log switch of thread 1
LGWR: terminating instance due to error 204
Fri Nov 04 11:03:31 2005
Instance terminated by LGWR, pid = 1808
Action Supply the missing keyword.
仔细检查哪个参数被你配置错了
我也遇到过这样的问题,解决方法是重新启动,然后在startup就OK了,我也搞不清楚是为什么
和java_pool_size也没有关系,因为此项目不用java方便的东西。
可以没有原始配置文件。
因为调试程序需要对数据库的数据进行恢复,所以先把几个表删掉了,然后重新import,但是我import的时候里面有个表CT_SYS_CTL的表,而此前没有把此表删掉,所以在导入的过程中
出现了一些错误的信息。然后我关闭导入文件,再次连接数据库的时候就失败了。总是提示01092的错误,服务器不能启动。
错误?可以startup nomount或是startup mount吗?
如果可以做到以上,建议恢复一下数据库看看