Adityanath's Oracle Blog

My thoughts on Oracle

  • About Me
By Adityanath Dewoolkar on December 12, 2020 • ( Leave a comment )

Applying GI Release Update 19.9.0.0.201020 (31750108) stuck with error “Unable to lock Central Inventory”

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

By Adityanath Dewoolkar on October 10, 2020 • ( 3 Comments )

Creating Oracle DR/Standby synchronization report using Python scripting

Dear Readers, In my previous posts, I discussed about tablespace/FRA/RMAN backup/Patchset level monitoring/DB inventory using python. Here comes my new python code for generating DR/Standby synchronization status report from the list of databases provided in the DB list. Note: This code is ready to use. You may need to make […]

By Adityanath Dewoolkar on September 17, 2020 • ( 10 Comments )

Using Information Publisher Reports in Oracle Enterprise Manager for RMAN backup reporting.

Dear Readers, Recently one of BU person in my project requested us to send scheduled report for RMAN Backup completion for one of critical databases. As this requirement was from Business, I thought of having it simple & less techie. After exploring few options, I thought of using OEM reporting […]

By Adityanath Dewoolkar on August 21, 2020 • ( 5 Comments )

All MOS/Oracle Metalink documents you should have it handy when working on Exadata

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

By Adityanath Dewoolkar on August 15, 2020 • ( 3 Comments )

Useful ASM commands/scripts for DBA’s

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

By Adityanath Dewoolkar on August 7, 2020 • ( 2 Comments )

My blog is now listed in Top 100 Oracle Blogs And Websites For Oracle DBAs To Follow in 2020.

Dear Readers, Yeahh!! It gives me immense pleasure to announce that my blog has been listed in Top 100 Oracle Blogs And Websites For Oracle DBAs To Follow in 2020. Rank #70 🙂 Special thanks to Feedspot for getting this listed. See below. Top 100 Oracle Blogs And Websites For Oracle […]

By Adityanath Dewoolkar on July 27, 2020 • ( 6 Comments )

Creating Oracle DB inventory using Python scripting

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

By Adityanath Dewoolkar on July 18, 2020 • ( 1 Comment )

Display current DB patch set info for Oracle DB using Python scripting

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

By Adityanath Dewoolkar on July 5, 2020 • ( 9 Comments )

RMAN backup details using Python scripting

Dear Readers, In my previous posts, I discussed about tablespace/FRA monitoring using python. Here comes my new python code to report RMAN backup job details from last 7 days in Oracle DB. Note: This code is ready to use. But you can definitely refer it & modify wherever as per […]

By Adityanath Dewoolkar on June 16, 2020 • ( 8 Comments )

Oracle FRA/Flash Recovery Area monitoring using Python scripting

Dear Readers, In my previous post, I discussed about tablespace monitoring using python. Here comes my new python code to check FRA/Flash recovery area usage details in Oracle DB. Note: This code is ready to use. But you can definitely refer it & modify wherever as per your need. Prerequisites: […]

1 2 3 4 5 6 7 8 Older ›

About ME

Blog Stats

  • 295,923 hits

Join 312 other followers

Categories

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Website Powered by WordPress.com. |
Cancel