Shulou(Shulou.com)06/01 Report--

11.2.0.4 RAC TO RAC FOR ADG environment. Due to historical reasons, standby node 2 has not been started, and it has always been a startup node to provide external services. Node 1 alert reports an error, and lgwr performs kill instance operation and restarts itself.

Mon Dec 24 16:11:24 2018

Archived Log entry 262740 added for thread 2 sequence 185858 ID 0x92570693 dest 1:

Mon Dec 24 16:12:28 2018

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFCD7489FF8] [PC:0x9899B16, qcsAnalyzeBooleanExpr () + 144] [flags: 0x0, count: 1]

Errors in file / u01/app/oracle/diag/rdbms/qdb/qdb1/trace/qdb1_ora_18912.trc (incident=580470):

ORA-07445: exception encountered: core dump [qcsAnalyzeBooleanExpr () + 144] [SIGSEGV] [ADDR:0x7FFCD7489FF8] [PC:0x9899B16] [Address not mapped to object] []

Incident details in: / u01/app/oracle/diag/rdbms/qdb/qdb1/incident/incdir_580470/qdb1_ora_18912_i580470.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Based on the trc file thrown, we can trace to a SQL within a period of time.

* * 2018-12-24 16-12-12-24 16-12-12-24 12-12-24 12-12-24 12-12-24 16-12-24 12-12-24 16-12-24 12-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-24 16-12-

DbkedDefDump (): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)

-Current SQL Statement for this session (sql_id=34vxxxxxx)-

Select from MSS.T_MSS_MOBILE_LOGIN_ADDR where UUID in ('7xxxxx4xxxxxx,' 48xxxxxxx,.

The whole trc file is 190m, and the text content UUID takes up almost the whole file.

New 2: where owner = 'MSS' and segment_name =' Tunable MSSs MOBILEED LOGING ADDR'

OWNER SEGMENT_NAME SEGMENT_TYPE Total_Bytes (MB)

MSS T_MSS_MOBILE_LOGIN_ADDR TABLE PARTITION 230054

[oracle@qdb1 trace] $du-sh / u01/app/oracle/diag/rdbms/qdb/qdb1/incident/incdir_580470/qdb1_ora_18912_i580470.trc

190M / u01/app/oracle/diag/rdbms/qdb/qdb1/incident/incdir_580470/qdb1_ora_18912_i580470.trc

Then the system reported a 4021 error code.

Mon Dec 24 16:30:17 2018

System State dumped to trace file / u01/app/oracle/diag/rdbms/qdb/qdb1/trace/qdb1_ora_67693.trc

Mon Dec 24 16:32:32 2018

Errors in file / u01/app/oracle/diag/rdbms/qdb/qdb1/trace/qdb1_lgwr_39157.trc:

ORA-04021: timeout occurred while waiting to lock object

LGWR (ospid: 39157): terminating the instance due to error 4021

Restart automatically until the final kill instance

Mon Dec 24 16:32:39 2018

License high water mark = 1203

Instance terminated by LGWR, pid = 39157

USER (ospid: 6702): terminating the instance

Instance terminated by USER, pid = 6702

Mon Dec 24 16:32:48 2018

Starting ORACLE instance (normal)

Query MOS related documents, there is a document consistent with our environment

ORA-04021: timeout occurred while waiting to lock object: DR Instance terminated by LGWR (document ID 2183882.1)

Hit BUG. According to the bug description, the parameters need to be modified

SQL > show parameter cursor_sharing

NAME TYPE VALUE

Cursor_sharing string EXACT

When cursor is set to exact, if there is a slight difference between the two sql statements, the cursor will not be shared and will be hard parsed twice.

When the Oracle value is set to force, the SQL value entered by the SQL condition is automatically replaced with the binding variable. Later, when you enter the same structure SQL statement, the cursor sharing shared cursor will be performed.

According to this temporary plan, I did a small experiment. I created a t table in the main library as a test for this parameter

14:35:02 SYS@bapdb1 (bapdb1) > create table t as select * from dba_objects

Table created.

Then go to the preparation bank to carry on the concrete experiment.

Mark once, choose a day to modify the parameters.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.