<<Back to Oracle DataGuard Main Page
ORA-600 [Cursor not typechecked] Occurs In Active Standby Sites
Extract of AlterlogErrors in file //u01/diag/rdbms/ORCLDs/ORCLD/trace/ORCLD_ora_20477.trc (incident=120790) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
Incident details in: //u01/diag/rdbms/ORCLDs/ORCLD/incident/incdir_120790/ORCLD_ora_20477_i120790.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Cause:
Its a bug for more detail check out Oracle Support Doc ID 28199085.8
Bug 28199085 ORA-600 [Cursor not typechecked] Occurs In ADG Standby Sites
Solution:
In my test environment I resolved the issue by deactivating the Active data guard feature because we don't needed it. You can follow the steps in the post below
How to Disable Active Data Guard Feature in Oracle Standby
In my test environment I resolved the issue by deactivating the Active data guard feature because we don't needed it. You can follow the steps in the post below
How to Disable Active Data Guard Feature in Oracle Standby
In general if you need Active data guard feature and want to fix the issue
Apply patch for the bug fix
Apply patch for the bug fix
Fixed:
The fix for 28199085 is first included in
19.1.0
18.6.0.0.190416 (Apr 2019) Database Release Update (DB RU)
12.2.0.1.190416 (Apr 2019) Database Release Update (DB RU)
12.2.0.1.190716 (Jul 2019) DB Apr 2019 Release Update Revision(DB RUR)
12.1.0.2.190716 (Jul 2019) Database Proactive Bundle Patch
12.2.0.1.181130 (Nov 2018) Bundle Patch for Windows Platforms
12.1.0.2.190215 (Feb 2019) Bundle Patch for Windows Platforms
11.2.0.4.190716 (Jul 2019) Bundle Patch for Windows Platforms
Comments
Post a Comment