oracle 11g ORA-00445:每个月数据库都会死，pl/sql登录不上

Question

每个月数据库都会无缘无故的死掉，重启数据库又正常了，下面是alert_orcl.log里面的日志，window服务器内存8G ,oracle版本11gR2，这个是什么原因导致的呢
Tue Oct 28 20:18:25 2014
Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_2628.trc (incident=65106):
ORA-00445: background process "J000" did not start after 120 seconds
Incident details in: d:\oracle\diag\rdbms\orcl\orcl\incident\incdir_65106\orcl_cjq0_2628_i65106.trc
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_2628.trc:
Tue Oct 28 20:18:28 2014
Trace dumping is performing id=[cdmp_20141028201828]
Tue Oct 28 20:20:16 2014
Thread 1 cannot allocate new log, sequence 6830
Private strand flush not complete
Current log# 1 seq# 6829 mem# 0: D:\ORACLE\ORADATA\orcl\REDO01.LOG
Thread 1 advanced to log sequence 6830 (LGWR switch)
Current log# 2 seq# 6830 mem# 0: D:\ORACLE\ORADATA\orcl\REDO02.LOG
下面是重启的参数：
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEorcl.ORA
System parameters with non-default values:
processes = 1000
sga_max_size = 3104M
memory_target = 3504M
memory_max_target = 3504M
control_files = "D:\ORACLE\ORADATA\orcl\CONTROL01.CTL"
control_files = "D:\ORACLE\FLASH_RECOVERY_AREA\orcl\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "D:\oracle\flash_recovery_area"
db_recovery_file_dest_size= 3912M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "D:\ORACLE\ADMIN\orcl\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "D:\ORACLE"
Tue Oct 28 20:50:40 2014

Answer 1

参考链接

http://blog.csdn.net/lwei_998/article/details/9296001