Dear Readers, Trust you all are doing well. In this post I would be discussing about an issue, we observed during RAT replay test after upgrading our database on 19c. There was considerable increase in wait time for the event “latch: shared pool” post DB was upgraded to 19c, which […]
Applying OJVM July 2021 patch(32876380) on GI HOME fails with “ArchiveAction: Destination File “$GI_HOME/lib/lib*****.a” does not exists or is not writeable” & “ApplySession::apply failed: mv: 0653-401 Cannot rename $GI_HOME/lib/lib*****.so”
Dear Readers, In this post, I am going to write about the issue I faced while patching GI HOME with July 2021 OJVM patch(32876380) post applying July 2021 GI RU patch(32904851). I had a requirement to apply patch 32900083 (GI RU & OJVM Combo July 2021) on GI HOME, which […]
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: 184.108.40.206OEM Agent version: 220.127.116.11 PFA screenshots […]
Does a delete on a table with where condition requires select privileges along with delete on a table???
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, 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 […]
Dear Readers, I am very happy to announce that I posted my first ever article on KT EXPERTS. This article focuses on new DB parameters that have been introduced in Oracle 18C along with its significance. Oracle 18C New Initialization Parameters Hope u will find this post very useful. 🙂 Stay […]