Awk to format the files .ora (listener.ora, tnsnames.ora, etc)
Tired of formatting the tnsnames.ora to make it more readable, I have taken the nice awk examples from Jeremy Schneider: https://ardentperf.com/2008/11/28/parsing-listenerora-with-awk-and-sed/ and created a function to format all files .ora (lisp-like config files). Example, before: $ cat tnsnames.ora LUDOCDB1_SITE2 = (DESCRIPTION = (ADDRESS = (PROTOCOL…
Parallel Oracle Catalog/Catproc creation with catpcat.sql
With Oracle 19c, Oracle has released a new script, annotated for parallel execution, to create the CATALOG and CATPROC in parallel at instance creation. I have a customer who is in the process of migrating massively to Multitenant using many CDBs, so I decided to…
Oracle Home Management – part 7: Putting all together
Last part of the blog series… let’s see how to put everything together and have a single script that creates and provisions Oracle Home golden images: Review of the points The scripts will: let create a golden image based on the current Oracle Home save…
Oracle Home Management – part 6: Simple Golden Image Blueprint
As I explained in the previous blog posts, from a manageability perspective, you should not change the patch level of a deployed Oracle Home, but rather install and patch a new Oracle Home. With the same principle, Oracle Homes deployed on different hosts should have…