Oracle Database Suite
10 article(s) tagged with Oracle Database Suite
2024-04-13
DataPump Import (IMPDP) Fails With Errors ORA-2372 ORA-26093 ORA-2374
During DataPump import you received the following oerrors: ORA-02372: data for row: COLLECTION : 0X'050200'" ORA-26093: input data column size (3) exceeds the maximum input size (1) ORA-02374: conversion error loading table "MJSDEV"."COLLECTION
2024-04-13
DataPump Performance Expdp Is Very Slow 10.2.0.4 to 11.2.0.2
Linux x86-64 running standard edition 11.2.0.2 with RAC reporting slow performance on expdp for object_grants.
2024-04-13
ORA-00600: [KSLGES_3] When Mounting Database
Received following errors in alert log when trying to mount database: ORA-00600: internal error code
2024-04-13
ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS .GATHER_STATS_JOB
When attempting to run GATHER_STATS_JOB the following errors occur: ORA-20011. Usually accompanied with varying other errors such as KUP-11024
2024-04-13
RMAN Duplicate to ASM Failing With ORA-19870 ORA-19504 ORA-15012 ORA-17502 ORA-15080
RMAN duplicate to ASM is failing with these errors: ORA-15012, ORA-15080, ORA-17502, ORA-19504, ORA-19870, ORA-27041, ORA-27091.
2024-04-13
Simple Example of Sending Attachments Using UTL_SMTP
How to send an E-Mail with attachment using the PL/SQL package UTL_SMTP.
2024-04-13
SYS.DBMS_SCHEDULER .CREATE_JOB Encounters ORA-00904: ORA-06512: at "SYS.DBMS_ISCHED" ORA-06512: at "
Error when attempting to create a job via DBMS_SCHEDULER
2024-04-13
Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors
The errors are usually caused by OS system call error or OS configuration issue.
2024-04-13
How to Diagnose High CPU Utilization of ORACLE.EXE in Windows Environment
On windows Oracle processes are represented as "Threads" of the Oracle process so if one session is using a lot of CPU this is simply displayed as "Oracle using CPU".
2024-04-13
Bug 13011409 - ORA-600 [kglLock-bad-byd] can occur
The fix for 13011409 is first included in: • 12.1.0.1 (Base Release) • 11.2.0.4 (Server Patch Set) • 11.2.0.3.5 Database Patch Set Update • 11.2.0.3 Bundle Patch 12 for Exadata Database • 11.2.0.3 Patch 10 on Windows Platforms