Home

Create Oracle Control file manually

When to create control files ? Create control files in situations when : 1. You have lost all your control files. 2. When you want to rename your database name (db_name); Note :although we can use utility called DBNEWID to change the DBNAME. DBNEWID can be used to change :…
Continue reading →: Create Oracle Control file manually
Oracle Database files to be excluded in Anti-virus or any third party tools scan

Oracle Database Files to Exclude from Antivirus and Third-Party Scans Oracle Database Files to Exclude from Antivirus and Third-Party Scans Properly managing antivirus and third-party scans is critical for maintaining the stability and performance of your Oracle Database. Failing to exclude essential database files from scans can lead to file…
Continue reading →: Oracle Database files to be excluded in Anti-virus or any third party tools scan
QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

Finding Archive gap between PRIMARY and STANDBY A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We can simple ship the logs which are missing in the standby…
Continue reading →: QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database
Working with Oracle Database Flashback Recovery

Configuring Flashback Recovery in Oracle Database Flashback Database is a powerful feature in Oracle that allows you to rewind your database to a previous state without requiring traditional point-in-time recovery. Starting from Oracle 11g R2, enabling Flashback Database no longer requires a database restart. For earlier versions, a database…
Continue reading →: Working with Oracle Database Flashback Recovery
Audit Failed Logon Attempts in Oracle Database

Audit Failed Logon Attempts in Oracle Database. Failed logon attempts can cause account locks, resulting in disruptions for users and increased workload for DBAs. Identifying the source of failed logon attempts is crucial for troubleshooting and preventing further issues. Oracle’s audit functionality provides an efficient way to track…
Continue reading →: Audit Failed Logon Attempts in Oracle Database
Managing Old Log Files on Linux Directories: Deletion and Compression

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…
Continue reading →: Managing Old Log Files on Linux Directories: Deletion and Compression
ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

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…
Continue reading →: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
Generate sql file from EXPDP/IMPDP

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…
Continue reading →: Generate sql file from EXPDP/IMPDP
Automating Oracle ADDM Reports via Email Using PL/SQL

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.
Continue reading →: Automating Oracle ADDM Reports via Email Using PL/SQL
Oracle audting explained

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…
Continue reading →: Oracle audting explained