Preplugin Backups and the Missing Piece
This post was originally published on this siteSubheading 1: Preplugin Backups for non-CDB to PDB Conversions and the RMAN-06054 Subheading 2: PrePlugin Backups and the need for “Trick 17” The following is coming from a customer project. Imagine you have a huge non-CDB database, assume…
Midsummer Midsomer SQL Winner
This post was originally published on this siteIn June I launched the Midsummer Midsomer Murder SQL Challenge and Book Competition. I promised to announce a winner within a week of the deadline – that was yesterday, so I’m afraid I’m one day late, sorry about…
Last Week in Stream Data Integration & Stream Analytics – 29.6.2020
This post was originally published on this site This is the 194th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations…
Getting the most out of Oracle Database Express Edition (XE) 18c
This post was originally published on this siteExpress Edition is a nice starter database which comes for free and does not need a license. Well, you do not get support for it either. There where XE databases in 10g and in 11g, but in this…
How to get the Data Guard broker configuration from a SQL query?
This post was originally published on this siteEverybody 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…
Awk to format the files .ora (listener.ora, tnsnames.ora, etc)
This post was originally published on this siteTired 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…
Names Matter
This post was originally published on this siteThis is one of my favorite quotes: There are only two hard things in Computer Science: cache invalidation and naming things. — Phil Karlton IT is my daily live. And this quote is so true. Lately I’ve been…
Azure Tip 7: Bulk Deleting and Purging Azure Resource Groups
This post was originally published on this siteDuring the delivery of my Azure training sessions, I often end up with a lot of resource groups. Deleting many resource groups at once would be a good tool. Here are 3 solutions: Delete multiple resource groups with…
Last Week in Stream Data Integration & Stream Analytics – 17.6.2020
This post was originally published on this site This is the 193rd edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations…
Social Media @trivadis