Arvind Toorpu

Blog Posts

  • Working with Oracle Database Flashback Recovery

    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 bounce is needed for these…

  • Audit Failed Logon Attempts in Oracle Database

    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 and log these attempts. Background…

  • Managing Old Log Files on Linux Directories: Deletion and Compression

    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 to store data pump export…

  • ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

    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 Then you need to edit…

  • Generate sql file from EXPDP/IMPDP

    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 arvind/password directory=DPUMP  dumpfile=HR_2014_08_13.dmp sqlfile=HR_2014_08_13.sql logfile=impsql_HR_2014_08_13.log

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.

Recent posts