How I resolved ORA-39002: invalid operation --- ORA-39405 during datapump importI had a task to import some table data from a source database with database version 19.23.0.0.0 to target of database version 19.16.0.0.0. Then, I got an error this error ORA-39002: invalid operation ---ORA-39405: Oracle Data Pump does not support im...Dec 3, 2025 · 5 min readiamgo0ke.hashnode.dev
Rman-03009, ORA-19870, ORA-19599.SOLVEDAs an Oracle DBA, I encountered a challenging issue while restoring a backup using RMAN. The restore failed because of a corrupted backup piece for datafile 50, throwing errors about block corruption and channel issues. Here is a detailed step-by-ste...Jun 5, 2025 · 3 min readiamgo0ke.hashnode.dev
Installing Kafka, Zookeeper, and Debezium for MySQL: A Change Data Capture Guide1Brief Introduction Kafka, Debezium, and ZooKeeper work together to move and manage data in real time. Kafka acts like a storage hub that collects and holds events (data changes) from a source database(in our case, a mysql database). Debezium is a too...Mar 6, 2025 · 6 min readiamgo0ke.hashnode.dev
ORA-04021: timeout occured while waiting to lock object 173. SOLVED.In the first week, I started the role of Database Administrator, one of the application support personnel had an issue connecting to the oracle database via toad IDE. Let me walk you through how I resolved this with just two easy steps. The first thi...Sep 23, 2022 · 1 min readiamgo0ke.hashnode.dev
How Oracle Handles Data Requests and Starts Up (Single Instance & RAC)This is the final post in the series on Oracle Database fundamentals.If you missed the earlier parts, you can catch up using the links below. A Beginner-Friendly Guide to Oracle Database Architecture Inside the Oracle Instance: Memory Structures & Ba...Mar 14, 2022 · 4 min readiamgo0ke.hashnode.dev