Real-Time Cascade Standby Container Databases without Oracle Managed Files
OK, the title might not be the best… I just would like to add more detail to content you can already find in other blogs (E.g. this nice one from Philippe Fierens http://pfierens.blogspot.com/2020/04/19c-data-guard-series-part-iii-adding.html). I have this Cascade Standby configuration: DGMGRL> connect / Connected to „TOOLCDB1_SITE1″…
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…
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…
Kerberos Troubleshooting – A few approaches
It is way too long ago since my last blog post. These were or are busy weeks for me. Any way, I finally found some time to start writing a blog post about a special setup for kerberos authentication of Oracle databases. It is about…
Multitenant Pills: Partial PDB cloning (and cleanup)
When consolidating to multitenant, there are several consolidation patterns. Big, complex databases usually have special requirements for which it might be a good choice to go to single-tenant (a single PDB in one CDB) Small, relatively easy databases are the best candidate for consolidation to…
Multitenant Pills – Change DBID for an existing PDB
When you plug the same PDB many times you have to specify “AS COPY” in the syntax: CREATE PLUGGABLE DATABASE ludo AS CLONE USING ‚/u01/app/oradata/ludo/ludo.xml‘; Otherwise, you will get an error similar to: ERROR at line 1: ORA-65122: Pluggable database GUID conflicts with the GUID…
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…
Configure Oracle EUSM to use LDAPS
With the introduction of Oracle 18c, eusm is officially designated as an Enterprise User Security Utility. It is now officially documented of the Enterprise User Security Administrator’s Guide. Before we had to be content with the somewhat sparse MOS note 1085065.1 EUSM, Command Line Tool…
DBMS_CLOUD Package – A Reference Guide
The Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. Therefore, while I was testing all the subroutines the…
Oracle 18c new Security Features
Today I had the opportunity to give a presentation on Oracle 18c new Security Features at the SOUG day in Baden. It was a great opportunity to discuss the security enhancements in the latest Oracle database release. This release introduces some new security features that…
Social Media @trivadis