Subscribe Now
Trending News
12 Aug 2022
ACED, Maximum Availability Architecture, Oracle, Oracle Data Guard, Oracle Database, Oracle Database 19c, Trivadis Blog...

How to get the Data Guard broker configuration from a SQL query? 

Everybody knows that you can get the Data Guard configuration in dgmgrl with the command: show configuration; but few know that this information is actually available in x$drc: SQL> desc x$drc Name Null? Type ————— ——– ————— ADDR RAW(8) INDX NUMBER INST_ID NUMBER CON_ID NUMBER…

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…