Scenario Preview:
ERRORS:
Error at application level and in sqlplus prompt:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3388
Session ID: 324 Serial number: 55071
Error in Alert.log
Fri Apr 24 09:41:23 2020
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0xCE518CE, qerixGetKey()+782] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/TESTENV/TESTENV/trace/TESTENV_ora_2543.trc (incident=615):
ORA-07445: exception encountered: core dump [qerixGetKey()+782] [SIGSEGV] [ADDR:0x10] [PC:0xCE518CE] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/TESTENV/TESTENV/incident/incdir_615/TESTENV_ora_2543_i615.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Apr 24 09:41:25 2020
Errors in file /u01/app/oracle/diag/rdbms/TESTENV/TESTENV/incident/incdir_615/TESTENV_ora_2543_i615.trc:
ORA-10173: Dynamic Sampling time-out error
ORA-07445: exception encountered: core dump [qerixGetKey()+782] [SIGSEGV] [ADDR:0x10] [PC:0xCE518CE] [Address not mapped to object] []
Fri Apr 24 09:41:25 2020
Errors in file /u01/app/oracle/diag/rdbms/TESTENV/TESTENV/incident/incdir_615/TESTENV_ora_2543_i615.trc:
ORA-10173: Dynamic Sampling time-out error
ORA-07445: exception encountered: core dump [qerixGetKey()+782] [SIGSEGV] [ADDR:0x10] [PC:0xCE518CE] [Address not mapped to object] []
Solution:
1) The recommended temporary workaround is to set one of the following
OPTIMIZER_ADAPTIVE_FEATURES=false
alter session set "_projection_pushdown"=false;
alter session set optimizer_adaptive_features=false;
2) The permanent solution is for Teamcenter customers who have downloaded
and installed Oracle 12.1.0.2 to download and install the following
patch bundle, which includes the correction for Oracle Bug 18430870.
This patch is available on the GTAC download server for each
supported Teamcenter platform in the Oracle / Product Updates / Oracle12
folder.
p22809813_121020_MSWIN-x86-64.zip
p22899531_121020_Linux-x86-64.zip
p22899531_121020_Solaris86-64.zip
Practice Solution Scenario:
NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
xxxTESTE TESTENV TESTENV READ WRITE PRIMARY NO 0
SQL> SELECT /*+ DYNAMIC_SAMPLING(t_02 4)*/ ;
SELECT /*+ DYNAMIC_SAMPLING(t_02 4)*/) ) ) ) )
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3388
Session ID: 324 Serial number: 55071
SQL>
SQL> ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES = FALSE SCOPE=BOTH;
System altered.
SQL> ALTER SYSTEM SET "_projection_pushdown"=false SCOPE=BOTH;
System altered.
SQL> @d
NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
xxxPATCH TESTENV TESTENV READ WRITE PRIMARY NO 0
SQL> SELECT /*+ DYNAMIC_SAMPLING(t_02 4)*xxxxx -------------------------------;
COLUMN_ENTRY
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
xxx
xxxxx
SQL> sho parameter OPTIMIZER_ADAPTIVE_FEATURES
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE
SQL> sho parameter _projection_pushdown
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_projection_pushdown boolean FALSE
SQL>