Linux: OSWatcher
OSWatcher is one of the best utilities provided by Oracle (Free of cost) and runs on almost all Operating Systems (Unix based only) To Install OSW Step 1. Download OSWatcher (Doc...
Wednesday, January 23, 2019
RSS Feeds
You can use below URL's to enable RSS Feeds for my blog. Atom 1.0 : http://o-dba.blogspot.com/feeds/posts/default https://o-dba.blogspot.com/feeds/posts/default RSS 2.0: http://o-dba.blogspot.com/feeds/posts/default?alt=rss https://o-dba.blogspot.com/feeds/posts/default?alt=rss If you wish to know how to subscribe to...
Thursday, January 17, 2019
Oracle Database - (Scripts) Log Switches per Hour (by Instance)
This blog talks about Log Switches Script It will list the count of logswitches done every hour by the instances (Standalone or RAC) Standalone select to_date(to_char(first_time,'DD-MON-YY HH24'),'DD-MON-YY HH24'),count(*) from v$log_history...
Oracle Database - Scripts - SID to PID and PID to SID
In this blog I am going to cover a simple script which converts the SID you mentioned to OS PID . SID to PID set lines 500 pages 500 column...
Wednesday, January 16, 2019
Oracle Database - 18c - RAC (DB) 18c Patching (Apply OJVM 18.4.0.0.0)
This blog is now in continuation with my previous blog of Patching DB to 18.4.0.0.0 The requirements for this patch are that RU 18.4.0.0.0 should be present on DB and...
Oracle Database - 18c - RAC (DB) 18c Patching (Apply RU 18.4.0.0.0)
This is in continuation with my previous blog on patching of RAC - GI and in this blog we will patch RAC - DB. [As oracle on All nodes] #...
Tuesday, January 15, 2019
Oracle Database - 18c - RAC (GI) 18c Patching (Apply RU 18.4.0.0.0)
In this blog I am going to cover Patching of Oracle RAC 18c (fresh installation) Download Patches 1. Patch 6880880: OPatch 12.2.0.1.14 for DB 12.2 releases (JUL 2018) (or higher) 2....
Oracle Database 18c: RAC Patching: NODE_STATUS::rac18c03:EFAIL
In this blog I am going to talk about issue I faced during patching of a RAC cluster - GI HOME I have a 3 node cluster which I was...
Performance - Sar - How to Plot Excel Chart (Complete Month)
In this blog I am going to talk about how to excel plot a chart using sar data in an easy 2 step process. Step 1 - Extract Required Sar...
