Adityanath's Oracle Blog

By Adityanath Dewoolkar on January 22, 2022 ( Leave a comment )

tfactl fails with error “Exception in thread “CommandLine” java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingRandomAccessFileManager$RollingRandomAccessFileManagerFactory@5c5eefef] unable to create manager”

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 […]

By Adityanath Dewoolkar on December 15, 2021 ( 2 Comments )

High “latch: shared pool” post 19C DB upgrade

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 […]

By Adityanath Dewoolkar on November 20, 2021 ( 2 Comments )

Thank so much Oracle ACE Program!!!

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

By Adityanath Dewoolkar on October 23, 2021 ( 2 Comments )

Oracle schema comparison using “dbForge Compare Bundle”

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 […]

By Adityanath Dewoolkar on August 23, 2021 ( 1 Comment )

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 […]

By Adityanath Dewoolkar on August 17, 2021 ( 9 Comments )

“ORA-28000: the account is locked” though user account is in OPEN state in ADG – Active Data Guard Environment

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 […]

By Adityanath Dewoolkar on June 27, 2021 ( 7 Comments )

Performance issues due to enq: TM – contention

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 – […]

By Adityanath Dewoolkar on April 28, 2021 ( 7 Comments )

Graphical representation of Oracle DB growth using Python

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 […]

By Adityanath Dewoolkar on April 8, 2021 ( 9 Comments )

Resolved: OEM DB target is showing down status though connection test is successful.

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 […]

By Adityanath Dewoolkar on April 1, 2021 ( 2 Comments )

Resolved: OEM notifications are sent though corresponding metrices are disabled.

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 […]

1 2 3 4 5 6 7 8 9 10 Older ›