'ORA 7445 [strcpy()+108]' was flood controlled (0x2)&nbs
(2016-06-14 10:51:31)分类: oracle |
ORACLE_HOME = /orahome/oracle/product/11.2.0
System name: SunOS
Node name:
bimsd
Release:
5.10
Version:
Generic_141444-09
Machine:
sun4u
Instance name: bims
Redo thread mounted by this instance: 1
Oracle process number: 285
Unix process pid: 27246, image: oracle@bimsd (TNS V1-V3)
*** 2016-06-14 07:14:47.859
*** SESSION ID:(385.7187) 2016-06-14 07:14:47.859
*** CLIENT ID:() 2016-06-14 07:14:47.859
*** SERVICE NAME:(SYS$USERS) 2016-06-14 07:14:47.859
*** MODULE NAME:(backup incr datafile) 2016-06-14
07:14:47.859
*** ACTION NAME:(0000020 STARTED16) 2016-06-14
07:14:47.859
Exception [type: SIGSEGV, Address not mapped to object]
[ADDR:0xC] [PC:0xFFFFFFFF7C33B52C, strcpy()+108] [flags: 0x0,
count: 1]
DDE: Problem Key 'ORA 7445 [strcpy()+108]' was flood
controlled (0x2) (incident: 39882)
ORA-07445: 出现异常错误: 核心转储 [strcpy()+108] [SIGSEGV] [ADDR:0xC]
[PC:0xFFFFFFFF7C33B52C] [Address not mapped to object] []
*** 2016-06-14 07:14:48.286
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory
'/orahome/oracle/diag/rdbms/bims/bims/cdump'
解决办法:
SQL> conn /as sysdba
已连接。
SQL> show parameter java;
NAME
TYPE
VALUE
------------------------------------ -----------
------------------------------
java_jit_enabled
boolean
TRUE
java_max_sessionspace_size
integer
0
java_pool_size
big
integer 0
java_restrict
string
none
java_soft_sessionspace_limit
integer
0
SQL> show parameter name;
NAME
TYPE
VALUE
------------------------------------ -----------
------------------------------
cell_offloadgroup_name
string
db_file_name_convert
string
db_name
string
bimsc
db_unique_name
string
bimsc
global_names
boolean
FALSE
instance_name
string
bimsc
lock_name_space
string
log_file_name_convert
string
processor_group_name
string
service_names
string
bimsc
SQL> alter system set JAVA_JIT_ENABLED= FALSE scope =
both;
系统已更改。
SQL> show parameter java;
NAME
TYPE
VALUE
------------------------------------ -----------
------------------------------
java_jit_enabled
boolean
FALSE
java_max_sessionspace_size
integer
0
java_pool_size
big
integer 0
java_restrict
string
none
java_soft_sessionspace_limit
integer
0