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: and created a function to format all files .ora (lisp-like config files).

Example, before:

and after:

The AWK script:

I have included the function in the COE github repo. More functions to come (hopefully).


The following two tabs change content below.


Principal Product Manager at Oracle
Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

4 thoughts on “Awk to format the files .ora (listener.ora, tnsnames.ora, etc)

  1. Hi Pepe, it’s in the comments in the head of the code…

    # you can source this function in bash and use it like: # cat $TNS_ADMIN/listener.ora | tidy_dotora

  2. Hi Ludovico – thanks for the great information. I’ve got it running (mostly), but I’m not an awk expert and occasionally run into issues if there are comments in the listener.ora.
    Example lines:
    Any suggestion on tweaking the awk code to handle ‘comments’ that aren’t at the beginning of the line?
    Thanks again, best regards – Scott C.

  3. maybe 🙂
    The easiest would be to strip the comments before processing the .ora file.
    I have to review this, but I really have no time. 🙁

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.