How I resolved ORA-39002: invalid operation --- ORA-39405 during datapump importResolve ORA-39002 and ORA-39405 errors during Oracle Data Pump import by upgrading timezone version and patching the target database5 min read·iamgo0ke.hashnode.devDec 3, 2025
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...3 min read·iamgo0ke.hashnode.devJun 5, 2025
Installing Kafka, Zookeeper, and Debezium for MySQL: A Change Data Capture Guide1Guide to set up Kafka, Zookeeper, and Debezium for MySQL data change capture and streaming in a development environment6 min read·iamgo0ke.hashnode.devMar 6, 2025
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...1 min read·iamgo0ke.hashnode.devSep 23, 2022
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...4 min read·iamgo0ke.hashnode.devMar 14, 2022