Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle 12.2 RAC error ora-600 ora-07445 how to do, the article is very detailed, has a certain reference value, interested friends must read it!

The error is as follows:

Use ADRCI or Support Workbench to package the incident.

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

2017-11-22 13 140 56 14 36 095 000 + 08:00

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F358CE5F7E3] [PC:0xAB3E99F, evaudc () + 127] [flags: 0x0, count: 1]

Errors in file / oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_59052.trc (incident=122179) (PDBNAME=TSSDB):

ORA-07445: exception encountered: core dump [evaudc () + 127] [SIGSEGV] [ADDR:0x7F358CE5F7E3] [PC:0xAB3E99F] [Invalid permissions for mapped object] []

Use ADRCI or Support Workbench to package the incident.

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

2017-11-22 13 57 purl 34.132000 + 08:00

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F7C412B539A] [PC:0xAB3E99F, evaudc () + 127] [flags: 0x0, count: 1]

Errors in file / oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63258.trc (incident=122617) (PDBNAME=TSSDB):

ORA-07445: exception encountered: core dump [evaudc () + 127] [SIGSEGV] [ADDR:0x7F7C412B539A] [PC:0xAB3E99F] [Invalid permissions for mapped object] []

Use ADRCI or Support Workbench to package the incident.

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

2017-11-22 13 57 Fran 48.377000 + 08:00

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F7B710B10E2] [PC:0xAB3E99F, evaudc () + 127] [flags: 0x0, count: 1]

DDE: Problem Key 'ORA 7445 [evaudc]' was completely flood controlled (0x6)

Further messages for this problem key will be suppressed for up to 10 minutes

2017-11-22 13 5814 40.155000 + 08:00

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F096426B19D] [PC:0xAB3E99F, evaudc () + 127] [flags: 0x0, count: 1]

Errors in file / oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63564.trc (incident=121985) (PDBNAME=TSSDB):

ORA-07445: exception encountered: core dump [evaudc () + 127] [SIGSEGV] [ADDR:0x7F096426B19D] [PC:0xAB3E99F] [Invalid permissions for mapped object] []

Use ADRCI or Support Workbench to package the incident.

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

2017-11-22 13 5933.141000 + 08:00

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7FB8400F327B] [PC:0xAB3E99F, evaudc () + 127] [flags: 0x0, count: 1]

Errors in file / oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63999.trc (incident=121796) (PDBNAME=TSSDB):

ORA-07445: exception encountered: core dump [evaudc () + 127] [SIGSEGV] [ADDR:0x7FB8400F327B] [PC:0xAB3E99F] [Invalid permissions for mapped object] []

Use ADRCI or Support Workbench to package the incident.

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

Through the inspection of the above trace information, it is found that in addition to SQL auto adviser, there is another SQL statement that causes this problem. The following error occurs when the sql statement is executed on plsql or server:

ORA-03113: end-of-file session of the communication channel ID: 191 Serial number: 1

At the same time, ora-07445 reports an error.

Check the netalink and find that it should be a bug of 12C, which can be solved by modifying the following parameters:

Ora-07445: exception encountered: core dump [evaudc () + 180] Rediscovery Notes When query has all of below:1) special ordering operator in outer query (example: ORDER BY... DESC/ASCNULLS LAST) 2) query having view on which view merge takes place3) there is FI usage i.e. Order by column is fetched from Functional index Workaround alter session set "_ replace_virtual_columns" = false;oralter session set "_ simple_view_merging" = false;alter session set "complex_view_merging" = false The above is all the contents of the article "Oracle 12.2 RAC error ora-600 ora-07445". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.