Today, I will be sharing one handy shell script that can be used to delete old archive logs. Considering the archive logs are already backed up and not required for any recovery purpose. In the following example i will be deleting archive that are 5 days old. vi archive_del.sh #!/bin/bash   # Set the number of days DAYS_OLD=5   # Function to delete archive logs older than specified days for a given ORACLE_SID delete_old_archivelogs() {   ORACLE_SID=$1   export ORACLE_SID     echo "Deleting archive logs older than $DAYS_OLD days for database $ORACLE_SID ..read more

  Overview on Oracle Database Licensing 1. Perpetual Licenses Description: Perpetual licenses are a one-time purchase that allows indefinite use of the software. This type of license is ideal for organizations looking for a long-term solution without the need for recurring payments. Best For: Companies with stable, long-term database needs. Organizations with the budget to make a significant initial investment. Key Point: While the initial cost is high, there are no ongoing fees, making it cost-effective over time. However, maintenance and support fees may still apply. Considerations ..read more

For one of our customer, crsctl stat output was showing extra cluster resource. -bash-5.2$ crsctl stat res -t -------------------------------------------------------------------------------- Name           Target  State        Server                   State details -------------------------------------------------------------------------------- Local Resources ..read more

  Hi Everyone,   Recently I came across an issue where ords service on windows was getting stopped due to some reason. It was hard to monitor as they had no mechanism to monitor this.   To mitigate the problem, I wrote a batch script which will monitor ords service’s uptime on windows . The script will send a mail once notifying service has gone down.   Save the following script in .bat format and schedule it as per your requirement in task scheduler.   @echo off setlocal enabledelayedexpansion set my_date=%date% set my_time=%TIME% set my_hours=%my_time:~0,2% set m ..read more

An oracle database administrator often face a situation where a deadlock is observed in database. A deadlock occurs when two or more sessions are waiting for data locked by each other, resulting in all the sessions being blocked. As a DBA, the only way you can resolve a lock by killing either the blocking session or blocked session. To automate this process, I have prepared a batch script for windows which will kill the session after 10 mins of getting locked. Step 1. Lets prepare the sql first which will find out the session that are locked more than 10mins SET LINESIZE 1000 SET PAGESIZE ..read more

  Problem description:- Recently for a customer we had performed a DR Drill  .  The customer had OEM agent installed in all oracle database server . Now after the drill was successful there was a requirement to restore one of the server from VM snapshot backup which was taken before the drill. Now after restoration of that vm , the OEM agent for that target was showing status as 'Diagnose for Agent Blocked (Bounce Counter Mismatch)' Solution:- To resolve this problem , we did the following. Logged into target DB server where agent status was showing as follows E:\Agent1 ..read more

  Recently I asked one of my junior colleague to add a datafile in a tablespace. The database had a physical standby database running. When she added the datafile , the parameter “standby_file_management” in standby database server was set to manual. So after addition of the datafile the file was created like “UNNAMED00006” And since then the  dataguard synchronization was broken. In alert log the event of datafile addition was showing like this 2024-04-05T05:48:11.121082-07:00 File #6 added to control file as 'UNNAMED00006' because the parameter STANDBY_FILE_MANAGEMENT is set to ..read more

  How to disable audit trail in E Business suite R12.2 There could a situation where you want to stop auditing, then you must set the audit group state to either “Disable-prepare for archive” or “Disable-Interrupt Audit” and run the “AuditTrail Update Tables” report. 1. Disable Prepare for Archive Copies the current value of all rows in the audited table into the shadow table and then disables the auditing triggers. There is no longer any recording of any changes. The shadow table should be archived at this point. 2. Disable Interrupt Audit Modifies the triggers to store one "final" row i ..read more

Recently I came across a requirement from a customer where they wanted to enable audit trail on EBS Application. Today I will show how to enable it.   Step 1. As an example, I will be enabling auditing on table AP_CHECKS_ALL     Navigate to Responsibility: System Administrator     Navigation:   Profile > System     Query Profile: 'AuditTrail:Activate'. Click FIND     Set it to 'Yes' at Site level. Step 2. We will be enabling Audit Installations for username. In this case it will be AP.  Navigate ..read more

  In this post I will describe the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit. The installation require a minimum of 2g swap memory and secure Linux set to permissive. ·       Download Software Oracle Database 19c (19.3) Software (64-bit) Add hosts entry in hosts file [oracle@ocisoumya-2 PDB1]$ cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 10.0.0.14 ..read more