Dear Readers, Trust you are doing well!!! In this post, I will discussing about an interesting issue I faced recently on newly installed 19c 4 node RAC cluster, wherein DB startup using command “srvctl startup database” was taking significant time. Each DB startup took around 15-20 minutes, sometimes more than […]
Dear Readers, Trust you are doing well!! Today I am going to write about issue I recently faced during running TFA for collecting SRDC regarding the performance issue I was working on. These TFA files were requested by Oracle global support for investigation purpose. I used below command for collecting […]
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 […]
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 & 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, 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 […]
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 […]
Today while applying “Patch 30501910: GI RELEASE UPDATE 19.6.0.0.0” on recently upgrade GRID home from 12.2 to 19.6, I received error related ACFS ==> CLSRSC-196: ACFS driver install actions failed. Command used for patching ==> opatchauto apply -oh /u01/app/19.6.0.0/grid /u05/ADI/patch/30501910 Detailed error is as given below: Execution of [SIHAStartupAction] patch […]
Adityanath's Oracle Blog 