-
Managing Old Log Files on Linux Directories: Deletion and Compression
Continue reading →: Managing Old Log Files on Linux Directories: Deletion and CompressionManaging Old Files in Oracle Directories: Deletion and Compression Managing Old Files in Oracle Directories: Deletion and Compression Managing disk space is a crucial task for database administrators, especially in environments where large amounts of data are exported and stored.…
-
ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
Continue reading →: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net ListenerWhen you start or stop you oracle service in Unix/Linux system and you get the prompt of ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener error. [oracle@linux1bin]$ echo $ORACLE_SID qptest [oracle@linux1 bin]$ . dbshut ORACLE_HOME_LISTNER is not…
-
Generate sql file from EXPDP/IMPDP
Continue reading →: Generate sql file from EXPDP/IMPDPIt’s straight forward to generate DDL SQL Script from any specific schema. However, it has nothing to do with expdp. expdp arvind/password schemas=hr directory=DPUMP dumpfile=HR_2014_08_13.dmp logfile=impsql_HR_2014_08_13.log while importing you need to specify .sql file name using impdp, it will generate…
-
Automating Oracle ADDM Reports via Email Using PL/SQL
Continue reading →: Automating Oracle ADDM Reports via Email Using PL/SQLLearn how to automate Oracle ADDM report generation and send it via email using PL/SQL. This guide walks through the process, including necessary configurations and a practical script example.
-
Oracle audting explained
Continue reading →: Oracle audting explainedOracle AUDIT Explained: A Comprehensive Guide Oracle Database auditing is a vital feature for tracking database activities, ensuring compliance, and identifying security issues. This guide covers enabling and disabling auditing, audit trail options, cleaning up audit logs, and…
-
DELETE OS AUDIT FILES IN ORACLE
Continue reading →: DELETE OS AUDIT FILES IN ORACLE[atoorpu@ORACLE1 adump]$ pwd/u01/app/oracle/admin/ORCL/adump[atoorpu@ORACLE1 adump]$ ls -1 /u01/app/oracle/admin/ORCL/adump | wc -l22273[atoorpu@ORACLE1 adump]$ ls -lrt *aud | wc -l11363[atoorpu@ORACLE1 adump]$ sqlplus /”As sysdba”SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 9 10:40:58 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g…
-
Extracting Tablespace DDLs in Oracle Database
Continue reading →: Extracting Tablespace DDLs in Oracle DatabaseExtracting Tablespace DDLs in Oracle Database Extracting Tablespace DDLs in Oracle Database When creating a new Oracle database similar to an existing one, you might need to replicate the tablespaces from the original database. Instead of manually recreating tablespaces, Oracle…
-
Understanding and Managing Oracle ASH Emergency Flushes
Continue reading →: Understanding and Managing Oracle ASH Emergency FlushesLearn how to diagnose and manage Oracle ASH emergency flushes effectively. This guide provides steps to monitor ASH performance, increase ASH size, and ensure database stability.
-
create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line
Continue reading →: create shared disks (vdi) on Virtualbox for ASM – vboxmanage command linevboxmanage command line For our scenario : Lets create shared disks (vdi) on Virtualbox for ASM setup. If you are getting error…
-
ORA-01113: file string needs media recovery
Continue reading →: ORA-01113: file string needs media recoveryLearn how to resolve the ORA-01113: File Needs Media Recovery error in Oracle Database. Understand its causes, follow step-by-step resolutions, and apply best practices to prevent recurrence.
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
