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 writing this post related to recent issue which we faced on one of the critical database post switchover to standby site. When I was checking AWR comparison reports to do some sanity checks, I found write IO statistics were increased […]
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, 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, Recently while working with one of my clients, I came across a requirement of creating graphical representation of DB growth in last few months. Ofcourse this is possible using excel graphs, I thought of achieving this using python programming. So I am writing this post on creating graphical […]
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, 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 […]
Adityanath's Oracle Blog 