Subscribe Now

* You will receive the latest news and updates on your favorite celebrities!

Trending News

25 Sep 2021
ACED, Oracle, Oracle Database, Oracle Upgrade, Install and Configuration, Trivadis Blog

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…