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

1 even if the database is not restarted, some startup information will be typed on the log, which makes you wonder if the library is restarted irrationally, and the most important thing is that there are no other related logs, which makes you wonder if you don't want to do DBA.

1.1 prohibit parameter information from dump to Alert log

_ log_segment_dump_parameter=FALSE

1.2 prohibit patch information from dump to Alert log

_ log_segment_dump_patch=FALSE

See: 12c Alert Log Appears To Show Unexpected Instance Restart (document ID 2049516.1)

2 ORA-600 [K2GTEGET: PDBID] AND ORA-600 [KPDBSWITCHPRERESTORE: TXN]

Reading the log is an error reported by calling dbms_advisor.

[TOC00004]

-PL/SQL Stack-

-PL/SQL Call Stack-

Object line object

Handle number name

0x1c582f4f8 12825 package body SYS.DBMS_SQLTUNE_INTERNAL

0x1b5c1e8c8 7 SYS.WRI$_ADV_SQLTUNE

0x17e85ca58 602 package body SYS.PRVT_ADVISOR

0x17e85ca58 2678 package body SYS.PRVT_ADVISOR

0x1cca00190 241 package body SYS.DBMS_ADVISOR

0x1ccf8d670 937 package body SYS.DBMS_SQLTUNE

0x1b8d0af08 19 anonymous block

See:

Bug 19942889: ORA-600 [KPDBSWITCHPRERESTORE: TXN]

Bug 19971949: ORA-600 [K2GTEGET: PDBID] AND ORA-600 [KPDBSWITCHPRERESTORE: TXN]

See the documentation.

ORA-00600: Internal Error Code,arguments: [k2gteget: Pdbid] & Arguments: [kpdbSwitchPreRestore: Txn] (document ID 2090473.1)

Solution:

1 upgrade to oracle 12.2

2 patch Patch 21283337 or Oracle Database 12c Release 12.1.0.2.170117

312c multipath ORA-600 [krr_process_read_error_2]

Temporary solution: ALTER SYSTEM SET "_ use_single_log_writer" = TRUE SID='*' SCOPE=SPFILE

Oracle 12c introduces a new default feature of using multiple LGWRs which may lead to DEADLOCK / Database Hang or ORA-742 "Log read detects lost write" or ORA-600 [kcrfrgv_nextlwn_scn] during instance OPEN or ORA-600 [krr_process_read_error_2] during Recovery on IBM AIX and potentially on HPUX Itanium 64bit.

Reference:

ALERT: Bug 21915719 Database hang or may fail to OPEN in 12c IBM AIX or HPUX Itanium-ORA-742, DEADLOCK or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2] (document ID 1957710.1)

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.