Posts

Showing posts from 2020

Grafana and Oracle database - Part 1 - Introduction

Image
As you may very well know, Grafana is an open source dash-boarding tool that displays graphs and dashboards that are light-weight and elegant and way more cooler as compared to Enterprise Manager (OEM) . For the uninitiated, here's a comparison of the dashboards in OEM vs Grafana. OEM Dashboards: Grafana Dashboard: For Server Performance: For Database Metrics: However, how does one make use of Grafana instead of OEM? A short, quick and concise guide to doing it is here . Basically, it utilises the power of the Telegraf agent (an open source monitoring agent) and to some extent, InfluxDB (a time series database wherein data is always stored along with time. This is how the data flows:          Next (Part 2A: Influx DB Installation) >  

Clone database home (clone.pl) deprecated in Oracle 19c

Back to blogging, at last. Well, this time it's about clone.pl. Background about clone.pl The easiest way to install a patched and up-to-date Oracle home is to physically copy it from a source server (that is already patched and up-to-date) and use clone.pl on the target server so that the binaries are linked to the target server's OS binaries (like gcc, libstdc++ etc.,), registered with the Oracle Inventory etc. The alternative to clone.pl is to: Install Oracle binaries using GUI or command line Apply the latest patchset (PSU/CPU patches) As you can see now, clone.pl is really useful in order to cut down time to build a database in a new server. More about clone.pl here and here (12c), here (18c). However, in Oracle 19c, Oracle has officially said - " Starting from oracle database 19c ,the clone.pl script is deprecated  and can be removed in a future release. Hence, Oracle recommends that you use the software-only installation option, available in the database installe