Oracle 12C ORA-07445 12.1.0.2.0

Mon June 14:06:23 2018 Exception [TYPE:SIGSEGV, Si_kernel (general_protection)] [addr:0x0] [Pc:0xc9ccf40, RWSSTD () +32] [ flags:0x0, Count:1] Errors in file/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/trace/salesstdydb_p000_ 161906.TRC (incident=600440) (pdbname=salespdb): ORA-07445::? RWSSTD () +32] [SIGSEGV] [addr:0x0] [pc:0 XC9CCF40] [Si_kernel (General_protection)] [] Incident details in:/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb /INCIDENT/INCDIR_600440/SALESSTDYDB_P000_161906_I600440.TRC use Adrci or support Workbench to the incident. See Note 411.1 at My Oracle support for error and packaging details. Mon June 14:07:12 2018 dumping diagnostic data in directory=[cdmp_20180611140712], requested by (Instance=1, osid=161906 (P000)), summary=[incident=600440]. Mon June 11 14:07:14 2018

Vi/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/trace/salesstdydb_p000_161906.trc

Exception [TYPE:SIGSEGV, Si_kernel (general_protection)] [addr:0x0] [Pc:0xc9ccf40, RWSSTD () +32] [flags:0x0, Count:1] in Cident 600440 created, dump file:/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/incident/incdir_600440/ SALESSTDYDB_P000_161906_I600440.TRC Ora-07445:3??? Òì3￡′í?ó: O? D?XA′￠[RWSSTD () +32] [SIGSEGV] [addr:0x0] [Pc:0xc9ccf40] [Si_kernel (General_protection)] []

Ssexhd:crashing the process ... Shadow_core_dump = PARTIAL ksdbgcra:writing Core file to directory '/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb /cdump '

~ ~

https://support.oracle.com/epmos/faces/documentdisplay?_afrloop=179713001088071&parent=document& sourceid=728311.1&id=14610432.8&_afrwindowmode=0&_adf.ctrl-state=gp38sku8n_586

Description

This bug was only relevant when using Connect by/hierarchical Queries

Rediscovery Notes If a CONNECT by query with subqueries in WHERE predicates fail during  workaround

 

Please Note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does is confirm that is encountering this problem. For questions the This bug is consult Oracle support.

Sql> col name for A30
Sql> Col description for A50

SELECT name,description from SYS. V$parameter WHERE name like ' \_% ' ESCAPE ' \ ';

NAME DESCRIPTION
------------------------------ --------------------------------------------------
_undo_autotune Enable auto tuning of Undo_retention
_optimizer_use_feedback Optimizer Use Feedback

Oracle 12C ORA-07445 12.1.0.2.0