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 […]
Dear Readers, Yeahh!! It gives me immense pleasure to announce that my blog has been listed in Top 100 Oracle Blogs And Websites For Oracle DBAs To Follow in 2020. Rank #70 🙂 Special thanks to Feedspot for getting this listed. See below. Top 100 Oracle Blogs And Websites For Oracle […]
Dear Readers, In my previous posts, I discussed about tablespace/FRA/RMAN backup/Patchset level monitoring using python. But none of these blog posts explained about connecting to multiple Oracle database using same program. Many of my blog followers requested me to write a code which connects to multiple databases & executes some […]
In my previous posts, I discussed about tablespace/FRA/RMAN backup monitoring using python. Here comes my new python code to display current DB patch set level for a Oracle DB. Note: This code is ready to use & only works on Oracle DB with versions 18+ Prerequisites: python binaries with version […]
