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 […]
Finally received my first Oracle ACE program gift after waiting for almost a year 🙂 & I wear it with pride!!!! Thank you so much @oracleace & @jen_s_nicholson !!! @Oracle @AIOUG #oracledatabase #oracledba #oraclecloud #oracleace #oracledatabaseworld #thankyou #oracle
Dear Readers, Recently I was working on one of the projects wherein a requirement was to compare two DB schemas (Both structure and data) & synchronize it. Requirement was as follows: Current application version is 1.0. It is using schema S_APPS in Oracle database as a backend. New upgrade pack […]
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, Trust you are doing well & safe!!! In this post we are going to discuss about weird issue I faced for a user account in Active Data Guard (ADG) environment. A user was receiving “ORA-28000: the account is locked” while connecting to ADG environment from SQL Developer. When […]
Dear Readers, Recently one of my clients facing weird issue, wherein some of application jobs were timing out. He raised a incident with us to check everything is fine from DB end. After checking active database sessions, I found some of update queries were having wait event “enq: TM – […]
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 […]
Adityanath's Oracle Blog 