Dear Readers, Hope you are doing well & enjoying my recent articles!!! Recently I faced strange issue with one of my Database instance target on OEM. It was showing down status, though connection test was successful with no errors: Target DB version: 19.8OMS version: 12.1.0.5OEM Agent version: 12.1.0.5 PFA screenshots […]
Today I came across interesting issue, where OEM was sending mail notification for one of the metrics though I had disabled it from GUI. This is known issue in many of the OEM versions. I found it interesting as none of MOS notes given clear instructions on how to make […]
Dear Reader, Recently I was upgrading OEM from 13.3 to 13.4. Running em13400_<OS>_ppc64.bin was failing with below error: my-emserver1:./em13400_aix_ppc64.binERROR: Temporary directory /tmp does not have enough free space. At least 12289 MB of free space are required.Please input another directory or [Exit]: /nfs/db_config/oem/tmpcaution: excluded filename not matched: sfx.iniERROR: Cannot find […]
Dear Readers, Trust you are doing well. Today I am writing about an interesting issue which we faced today. The application team did complain about one of the job failure with error “ORA-01031: insufficient privileges” while running delete statement on one of the table: Ofcourse first check I did was […]
Dear Readers, Happy new year 2021!!! This is my first day of learning PostgreSQL and I faced issue while installing version 13.1 on windows. After almost spending 3 hours of troubleshooting I was able to identify the issue & fix it. In this post will explain basic steps to install […]
Dear Readers, Hope you are doing well & safe. Today I will be writing on one of the issue I faced today while applying “GI Release Update 19.9.0.0.201020″(31750108) patch on GI Home of one of servers. I used opatchauto utility to apply this patch. Following command was run for the […]
Dear Readers, In my previous posts, I discussed about tablespace/FRA/RMAN backup/Patchset level monitoring/DB inventory using python. Here comes my new python code for generating DR/Standby synchronization status report from the list of databases provided in the DB list. Note: This code is ready to use. You may need to make […]
Dear Readers, Recently one of BU person in my project requested us to send scheduled report for RMAN Backup completion for one of critical databases. As this requirement was from Business, I thought of having it simple & less techie. After exploring few options, I thought of using OEM reporting […]
Dear Readers, It happened many times, when I need to search a document MOS/Metalink Oracle support, which I referred in past but unable to find now. So thought of writing a Master Note which will have all MOS/Oracle Metalink documents you should have it handy when working on Exadata. Hope […]
Dear Readers, I thought of writing a post to include all ASM related scripts/commands. Its good to have everything you need in single place 🙂 1. Check file-type specific usage details all databases on the server. This is useful when we need to quickly check who occupied major space in […]
