oracle 12c隔几天就会自动关闭,但是服务还是在的。
log如下:<msg time='2016-05-16T04:43:47.129+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-VGD5LQ82LMG'
host_addr='fe80::9dd2:b4a6:42b3:eeb%11' pid='3588'>
<txt>Errors in file D:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_psp0_3588.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 1455
ORA-27301: OS failure message: 页面文件太小,无法完成操作。
ORA-27302: failure occurred at: ssthrddcr
</txt>
</msg>
<msg time='2016-05-16T04:43:48.104+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbsrv_targeted:4668:3656186066' type='WARNING' group='background_proc'
level='16' host_id='WIN-VGD5LQ82LMG' host_addr='fe80::9dd2:b4a6:42b3:eeb%11'
pid='3424'>
<txt>Process m001 died, see its trace file
</txt>
</msg>trace文件:Trace file D:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_psp0_3588.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 24 - type 8664, 12 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:978M/8146M, Ph+PgF:5M/32583M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 3588, image: ORACLE.EXE (PSP0)
*** 2016-05-16 04:43:47.129
*** SESSION ID:(61.1) 2016-05-16 04:43:47.129
*** CLIENT ID:() 2016-05-16 04:43:47.129
*** SERVICE NAME:(SYS$BACKGROUND) 2016-05-16 04:43:47.129
*** MODULE NAME:() 2016-05-16 04:43:47.129
*** ACTION NAME:() 2016-05-16 04:43:47.129
Process startup failed, error stack:
ORA-27300: OS system dependent operation:CreateThread failed with status: 1455
ORA-27301: OS failure message: 页面文件太小,无法完成操作。
ORA-27302: failure occurred at: ssthrddcr这是内存太小的原因造成的么????求高人。。
log如下:<msg time='2016-05-16T04:43:47.129+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-VGD5LQ82LMG'
host_addr='fe80::9dd2:b4a6:42b3:eeb%11' pid='3588'>
<txt>Errors in file D:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_psp0_3588.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 1455
ORA-27301: OS failure message: 页面文件太小,无法完成操作。
ORA-27302: failure occurred at: ssthrddcr
</txt>
</msg>
<msg time='2016-05-16T04:43:48.104+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbsrv_targeted:4668:3656186066' type='WARNING' group='background_proc'
level='16' host_id='WIN-VGD5LQ82LMG' host_addr='fe80::9dd2:b4a6:42b3:eeb%11'
pid='3424'>
<txt>Process m001 died, see its trace file
</txt>
</msg>trace文件:Trace file D:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_psp0_3588.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 24 - type 8664, 12 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:978M/8146M, Ph+PgF:5M/32583M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 3588, image: ORACLE.EXE (PSP0)
*** 2016-05-16 04:43:47.129
*** SESSION ID:(61.1) 2016-05-16 04:43:47.129
*** CLIENT ID:() 2016-05-16 04:43:47.129
*** SERVICE NAME:(SYS$BACKGROUND) 2016-05-16 04:43:47.129
*** MODULE NAME:() 2016-05-16 04:43:47.129
*** ACTION NAME:() 2016-05-16 04:43:47.129
Process startup failed, error stack:
ORA-27300: OS system dependent operation:CreateThread failed with status: 1455
ORA-27301: OS failure message: 页面文件太小,无法完成操作。
ORA-27302: failure occurred at: ssthrddcr这是内存太小的原因造成的么????求高人。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货