+ + + received an alert email this afternoon and an ORA-07445 error was detected in the alter log
+++alter Log Information
Fri Jan 10 16:21:41 2014
Exception [TYPE:SIGSEGV, Address not mapped to object] [addr:0x170] [PC:0X244A0CE, Qctosop () +1504] [flags:0x0, Count:1]
Errors in File/tol/app/oracle/admin/rac/diag/rdbms/dg_114/rac/trace/rac_ora_22041.trc (incident=220018):
Ora-07445:exception Encountered:core Dump [Qctosop () +1504] [SIGSEGV] [addr:0x170] [PC:0X244A0CE] [Address not mapped to Object] []
Incident details in:/tol/app/oracle/admin/rac/diag/rdbms/dg_114/rac/incident/incdir_220018/rac_ora_22041_ I220018.trc
Fri Jan 10 16:21:46 2014
Trace dumping is performing id=[cdmp_20140110162146]
Fri Jan 10 16:21:48 2014
+++trace Information:
Dump continued from file:/tol/app/oracle/admin/rac/diag/rdbms/dg_114/rac/trace/rac_ora_22041.trc
Ora-07445:exception Encountered:core Dump [Qctosop () +1504] [SIGSEGV] [addr:0x170] [PC:0X244A0CE] [Address not mapped to Obj
ECT] []
========= Dump for incident 220018 (ORA 7445 [Qctosop () +1504]) ========
-----Beginning of customized Incident Dump (s)-----
Exception [TYPE:SIGSEGV, Address not mapped to object] [addr:0x170] [PC:0X244A0CE, Qctosop () +1504] [flags:0x0, Count:1]
Registers:
%rax:0x0000000000000000%rbx:0x0000000000000000%rcx:0x000000000000001a
%rdx:0x0000000000000000%rdi:0x000000087132eff0%rsi:0x000000087132eed8
%RSP:0X00007FFF4CE761C0%rbp:0x00007fff4ce76260%r8:0x0000000000000001
%r9:0x0000000000000007%r10:0x000000000000001a%r11:0x0000000000000fa0
%r12:0x0000000000000002%r13:0x00002b32a9d64480%r14:0x0000000000000000
%r15:0x000000000000001a%RIP:0X000000000244A0CE%efl:0x0000000000010246
> (0X244A0CE) mov 0x170 (%RDX),%rax
(0x244a0d5) Test%rax,%rax
(0x244a0d8) JE 0x244a115
(0X244A0DA) mov%r10d,-0x50 (%RBP)
(0X244A0DE) mov%r14,-0x88 (%RBP)
2014-01-10 16:21:42.253
Dbkeddefdump (): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
-----current SQL Statement to this session (SQL_ID=29Q07J31DBQFP)-----
SELECT * FROM (select row_.*, RowNum rownum_ from (SELECT * from kyds_user where batch = ' and status! = 0 and name Li
Ke '%q ' | | Utl_inaddr.get_host_address ((select Chr (126) | | Chr (39) | | global_name| | Chr (39) | | Chr (126) from Global_name where Rownu
m=1)) and ' 1 ' = ' 1% ' and area like ' 2% ' ORDER by createtime Desc] Row_ where rownum <=) where rownum_ > 0
-----Call Stack Trace-----
Calling call entry argument values in hex
Location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
+ + + As you can see, this error is caused by this SQL
SELECT * FROM (select row_.*, RowNum rownum_ from (SELECT * from kyds_user where batch = ' and status! = 0 and name Li
Ke '%q ' | | Utl_inaddr.get_host_address ((select Chr (126) | | Chr (39) | | global_name| | Chr (39) | | Chr (126) from Global_name where Rownu
m=1)) and ' 1 ' = ' 1% ' and area like ' 2% ' ORDER by createtime Desc] Row_ where rownum <=) where rownum_ > 0
+ + + Check to see which user kyds_user this table is,
Sql> Select Object_name,object_type,owner from dba_objects where object_name= ' kyds_user ';
object_name
--------------------------------------------------------------------------------
Object_type OWNER
------------------- ------------------------------
Kyds_user
TABLE SUBJECT
+ + + log in with subject, perform a manual Check
Sql> Conn Subject/xxxxxxxx
Connected.
Sql> SELECT *
2 from (SELECT row_.*, ROWNUM rownum_
3 From (SELECT *
4 from Kyds_user
5 WHERE Batch = ' 2013 '
and Status! = 0
and name like '%q ' | | Utl_inaddr.get_host_address ((select CHR (126) | | CHR (39) | | global_name| | CHR (39) | | CHR (126) from Global_name where Rownum=1))
8 and ' 1 ' = ' 1% '
9 and area like ' 2% '
ORDER by Createtime DESC)
Row_ where ROWNUM <= 20)
where rownum_ > 0;
SELECT *
*
ERROR at line 1:
Ora-03113:end-of-file on communication channel
Process id:4671
Session id:962 Serial number:50676
+ + + can see manual execution also error, check the ALTER log information: the following
Fri Jan 10 16:28:27 2014
Archived Log Entry 428185 added for thread 1 sequence 161134 ID 0x8e79ab49 dest 1:
Fri Jan 10 16:38:24 2014
Exception [TYPE:SIGSEGV, Address not mapped to object] [addr:0x170] [PC:0X244A0CE, Qctosop () +1504] [flags:0x0, Count:1]
Errors in File/tol/app/oracle/admin/rac/diag/rdbms/dg_114/rac/trace/rac_ora_4671.trc (incident=221602):
Ora-07445:exception Encountered:core Dump [Qctosop () +1504] [SIGSEGV] [addr:0x170] [PC:0X244A0CE] [Address not mapped to Object] []
Incident details in:/tol/app/oracle/admin/rac/diag/rdbms/dg_114/rac/incident/incdir_221602/rac_ora_4671_ I221602.trc
Fri Jan 10 16:38:26 2014
Trace dumping is performing id=[cdmp_20140110163826]
Fri Jan 10 16:38:27 2014
Sweep [inc][221602]: Completed
Sweep [inc2][221602]: Completed
+ + + the same mistake
+ + + Single execution subquery also error
Sql> SELECT *
2 from Kyds_user
3 WHERE Batch = ' 2013 '
4 and Status! = 0
5 and name like '%q ' | | Utl_inaddr.get_host_address ((select CHR (126) | | CHR (39) | | global_name| | CHR (39) | | CHR (126) from Global_name where Rownum=1))
6 and ' 1 ' = ' 1% '
7 and area like ' 2% '
8 ORDER by Createtime DESC;
*
ERROR at line 2:
Ora-03113:end-of-file on communication channel
Process id:9431
Session id:1021 Serial number:44925
Sql> SELECT row_.*, ROWNUM rownum_
2 From (SELECT *
3 from Kyds_user
4 WHERE Batch = ' 2013 '
5 and Status! = 0
6 and name like '%q ' | | Utl_inaddr.get_host_address ((select CHR (126) | | CHR (39) | | global_name| | CHR (39) | | CHR (126) from Global_name where Rownum=1))
7 and ' 1 ' = ' 1% '
8 and area like ' 2% '
9 ORDER by Createtime DESC)
Ten row_ where rownum <= 20;
From (SELECT *
*
ERROR at line 2:
Ora-03113:end-of-file on communication channel
Process id:9431
Session id:1021 Serial number:44925
+ + + just started thinking is a bug, query some information, found not much like the bug
+ + + double-check to find out that there is a problem with the SQL development write
+ + + changed SQL, execute again, OK
Sql> SELECT *
2 from (SELECT row_.*, ROWNUM rownum_
3 From (SELECT name
4 from Kyds_user
5 WHERE Batch = ' 2013 '
6 and Status! = 0
and name like ' "%q" | | Utl_inaddr.get_host_address ((select CHR (126) | | CHR (39) | | global_name| | CHR (39) | | CHR (126) from Global_name where Rownum=1) '
8 and ' 1 ' = ' 1% '
9 and area like ' 2% '
ORDER by Createtime DESC)
Row_ where rownum <= 20)
where rownum_ > 0;
No rows selected
Sql> SELECT *
2 from (SELECT row_.*, ROWNUM rownum_
3 From (SELECT name
4 from Kyds_user
5 WHERE Batch = ' 2013 '
6 and Status! = 0
7 and name like ' "%q" | | Utl_inaddr.get_host_address ((select CHR (126) | | CHR (39) | | global_name| | CHR (39) | | CHR (126) from Global_name where Rownum=1) '
8--and ' 1 ' = ' 1% '
9 and area like ' 2% '
ORDER by Createtime DESC)
Row_ where rownum <= 20)
where rownum_ > 0;
No rows selected
