Blog Posts

Managing Old Log Files on Linux Directories: Deletion and Compression

August 17, 2021

Managing 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 database environments often utilize directory paths such as /u01/app/oracle/dpump to store data pump export…
ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

April 13, 2021

When 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 SET, unable to auto-stop Oracle Net Listener Usage: -bash ORACLE_HOME Then you need to edit…
Generate sql file from EXPDP/IMPDP

January 28, 2021

It’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 DDL SQL Script for any specific schema. [oracle@qpdbdev202 dpump]$ impdp arvind/password directory=DPUMP dumpfile=HR_2014_08_13.dmp sqlfile=HR_2014_08_13.sql logfile=impsql_HR_2014_08_13.log
Automating Oracle ADDM Reports via Email Using PL/SQL

March 2, 2020

Learn 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

November 18, 2019

Oracle 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 more. Configuration Options: Enable database auditing with extended information: ALTER SYSTEM SET AUDIT_TRAIL=DB, EXTENDED SCOPE=SPFILE;…