Home

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 Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP,…
Continue reading →: DELETE OS AUDIT FILES IN ORACLE
Extracting Tablespace DDLs in Oracle Database

Extracting 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 provides a simple way to extract the Data Definition Language…
Continue reading →: Extracting Tablespace DDLs in Oracle Database
Understanding and Managing Oracle ASH Emergency Flushes

Learn 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.
Continue reading →: Understanding and Managing Oracle ASH Emergency Flushes
create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line

vboxmanage command line For our scenario : Lets create shared disks (vdi) on Virtualbox for ASM setup. If you are getting error like below make sure you have virtual-box set in your…
Continue reading →: create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line
ORA-01113: file string needs media recovery

Learn 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.
Continue reading →: ORA-01113: file string needs media recovery
Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

Learn how to configure email notifications for Oracle Scheduler jobs. This guide covers SMTP server setup, defining default senders, creating jobs, and setting up job notifications for proactive monitoring.
Continue reading →: Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide
Trigger to backup the data before delete or update on a table – Oracle

Lets create a table : CREATE TABLE “ABC” ( “EMPNO” NUMBER(4,0), “ENAME” VARCHAR2(10 BYTE), “JOB” VARCHAR2(9 BYTE), “MGR” NUMBER(4,0), “HIREDATE” DATE, “SAL” NUMBER(7,2), “COMM” NUMBER(7,2), “DEPTNO” NUMBER(2,0) ) TABLESPACE “USERS” ;Now we will insert some data into it :Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,’SMITH’,’CLERK’,7902,to_date(’17-DEC-80′,’DD-MON-RR’),800,null,20);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,’ALLEN’,’SALESMAN’,7698,to_date(’20-FEB-81′,’DD-MON-RR’),1600,300,30);Insert into ABC…
Continue reading →: Trigger to backup the data before delete or update on a table – Oracle
Generating Random Data in Oracle Tables for Testing

Learn how to use Oracle’s DBMS_RANDOM package to generate random test data for your tables. This guide covers random strings, numbers, and dates with PL/SQL examples.
Continue reading →: Generating Random Data in Oracle Tables for Testing
How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle

Learn how to troubleshoot and resolve the Oracle TNS-03505: Failed to Resolve Name error. This article covers common causes, step-by-step troubleshooting, and best practices for ensuring a successful Oracle connection.
Continue reading →: How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle
Fixing ORA-31633: Unable to Create Master Table During Data Pump Import

Learn how to resolve the ORA-31633: Unable to Create Master Table error in Oracle Data Pump Import. This guide covers troubleshooting steps, necessary privileges, and best practices to ensure a successful import.
Continue reading →: Fixing ORA-31633: Unable to Create Master Table During Data Pump Import