ORALCE不定期死机起不来
各位大大,服务器上的ORACLE不定期的死机并且起不来,每次都必须重启服务器才可以,希望各位大大帮帮忙,小弟在此谢过了!服务器是WIN SERVER2003的,8G内存。日志如下:
Thu Jun 30 20:37:51 2011
Errors in file d:\oracle\product\10.2.0\db_1\rdbms\trace\orcl_ora_3472.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C94BD02] [ADDR:0x8B0C558B] [UNABLE_TO_READ] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C94BD02] [ADDR:0x8B0C558B] [UNABLE_TO_READ] []
OR报了大量的ORA-07445,然后在服务器事件查看器中看到
服务 OracleServiceORCL 意外停止。配置如下信息:
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 400
sessions = 445
sga_max_size = 1073741824
__shared_pool_size = 167772160
shared_pool_size = 159383552
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 889192448
db_cache_size = 838860800
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = d:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
shared_servers = 0
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 500
pga_aggregate_target = 203423744各位大大帮忙看看,非常感谢!
各位大大,服务器上的ORACLE不定期的死机并且起不来,每次都必须重启服务器才可以,希望各位大大帮帮忙,小弟在此谢过了!服务器是WIN SERVER2003的,8G内存。日志如下:
Thu Jun 30 20:37:51 2011
Errors in file d:\oracle\product\10.2.0\db_1\rdbms\trace\orcl_ora_3472.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C94BD02] [ADDR:0x8B0C558B] [UNABLE_TO_READ] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C94BD02] [ADDR:0x8B0C558B] [UNABLE_TO_READ] []
OR报了大量的ORA-07445,然后在服务器事件查看器中看到
服务 OracleServiceORCL 意外停止。配置如下信息:
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 400
sessions = 445
sga_max_size = 1073741824
__shared_pool_size = 167772160
shared_pool_size = 159383552
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 889192448
db_cache_size = 838860800
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = d:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
shared_servers = 0
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 500
pga_aggregate_target = 203423744各位大大帮忙看看,非常感谢!
解决方案 »
- sql语句求助!如何动态创建表?如何order by 2000个字段?如何group by 1999个字段?
- 关于触发器的问题
- 用户之间索引 如何赋予权限啊?
- 任何更改oracle的库服务名SID
- 出现错误提示:ORA-04031: 无法分配 8192 字节的共享内存 ("large pool","unknown object","sga heap","multiblock rea")
- 关于group by用法的请教!拜托了!
- 大哥大姐帮个忙吧!!!
- 建表后为什么看不见
- 关于oracle对中文字段的排序的问题!
- 请问如何将Access数据库转化为Oracle?(oracle版本是8.1.7)
- oracle服务以外终止,高人帮忙看看是什么问题?
- 那位兄弟姐妹帮忙下 Oacle 数据库怎么建立数据库建库的脚本的是什么!?
一次处理ORA-07445的历险记
ORA-07445导致实例崩溃的解决