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 […]
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 […]
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: […]
Dear Readers, I have published one more article on KT EXPERTS. This article explains how to export AUD$ & other AUDIT tables using DATAPUMP. Exporting the AUDIT tables/AUD$ Using Oracle Data Pump EXPDP Hope u will find this post very useful. 🙂 Cheers Regards, Adityanath
Dear Readers, I am planning to convert most of the scripts I currently use for Oracle DB monitoring, into python in near future. But why am I fascinated with Python?? Its very easy to understand. Its open source & most important its platform independent. So here comes python code to […]
Dear Readers, Yesterday one of my friend pinged with the requirement of generating muliple AWR reports for every 1 hour using single command. This particular database has SNAP_INTERVAL set to every 15 minutes. He had already referred one of my old post given below, which helps us generating muliple AWR […]
Dear Readers, I recently completed Python programming course which was authorized by “University of Michigan” offered through Coursera. It was really good course & worth the time I invested in. So here comes my first python program, which can be useful for Oracle DBA’s like me to get consolidated report […]
Dear Readers, My first YouTube Video on “OEM Metrics Extension || What || Why || How” Hope u will find this post very useful. Cheers Regards, Adityanath
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 […]
Dear Readers, I have published two more articles on KT EXPERTS. This articles focuses on new DB features that have been introduced in Oracle 18C along with its significance. Oracle 18C new feature: Cancel SQL instead of killing session Oracle 18C new feature: Schema Only Account Hope u will find […]
Adityanath's Oracle Blog 