-
Automating Deadlock Resolution with DBMS_SCHEDULER
We often encounter customers reporting application is hung/ not responding. Upon checking most of the time we observe blocking sessions. Deadlocks occur when two or more sessions block each other while waiting for resources, causing a standstill in database operations. This solution automates the detection and resolution of such conflicts, significantly reducing downtime and ensuring… Continue Reading
-
Shell script to delete old archive logs in RAC databases
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 daysDAYS_OLD=5 #… Continue Reading
-
Overview on Oracle Database Licensing
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: Key Point: While the initial cost is high, there are no ongoing… Continue Reading
-
crsctl stats output showing extra cluster resource
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——————————————————————————–ora.LISTENER.lsnr ONLINE ONLINE db1 STABLE ONLINE ONLINE db2 STABLEora.net1.network ONLINE ONLINE db1 STABLE ONLINE ONLINE db2 STABLEora.ons ONLINE ONLINE db1 STABLE ONLINE ONLINE db2 STABLEora.proxy_advm OFFLINE OFFLINE db1 STABLE OFFLINE OFFLINE db2 STABLE——————————————————————————–Cluster Resources——————————————————————————–ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE db1 STABLE 2 ONLINE ONLINE db2 STABLE 3 ONLINE OFFLINE STABLEora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE db1 STABLE 2 ONLINE ONLINE db2 STABLE 3 OFFLINE OFFLINE STABLEora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE db2 STABLEora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE db1 STABLEora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE db1 STABLEora.RECO.dg(ora.asmgroup) 1 ONLINE ONLINE db1 STABLE 2 ONLINE ONLINE db2 STABLE 3 OFFLINE OFFLINE STABLEora.REDO.dg(ora.asmgroup) 1 ONLINE ONLINE db1 STABLE 2 ONLINE ONLINE db2 STABLE 3 OFFLINE OFFLINE STABLEora.asm(ora.asmgroup) 1 ONLINE ONLINE db1 Started,STABLE 2 ONLINE ONLINE db2 Started,STABLE 3 OFFLINE OFFLINE STABLEora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE db1 STABLE 2 ONLINE ONLINE db2 STABLE 3 OFFLINE OFFLINE STABLEora.cvu 1 ONLINE ONLINE db1 STABLEora.db1.vip 1 ONLINE ONLINE db1 STABLEora.db2.vip 1 ONLINE ONLINE db2 STABLEora.qosmserver 1 ONLINE ONLINE db1 STABLEora.prod.db 1 ONLINE ONLINE db1 Open,HOME=/u01/app/o racle/product/19.3.0 /dbhome_1,STABLE 2 ONLINE ONLINE db2 Open,HOME=/u01/app/o racle/product/19.3.0 /dbhome_1,STABLEora.scan1.vip 1 ONLINE ONLINE db2 STABLEora.scan2.vip 1 ONLINE ONLINE db1 STABLEora.scan3.vip 1 ONLINE ONLINE db1 STABLE——————————————————————————– However this was 2 node cluster and the output as we can see was showing 3 resources which was causing confusion. After checking MOS, as per Doc ID… Continue Reading
-
Batch script to monitor ORDS service and send mail notification it goes down
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… Continue Reading
-
How to apply oracle enterrprise manager13c Release 5 Update 22 Patch
How to apply RU Patch on Oracle Enterprise Manager 13.5 In this post I will be showing step by step guide to apply RU patch on Oracle Enterprise Manager 13.5 . I will be applying patch for April 2024(Patch no :- 36335368 ) Here I will be installing the patch on OMS server which is running on Windows. 1. Download… Continue Reading
-
Batch script to kill blocked session
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… Continue Reading
-
OEM 13c Agent status shows ‘Diagnose for Agent Blocked (Bounce Counter Mismatch)’
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… Continue Reading
-
ORA-01111: name for data file is unknown – rename to correct file
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… Continue Reading
-
How to disable audit trail in E Business suite R12.2
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… Continue Reading