by Maciej Tokar | Jul 18, 2016 | Oracle 11g R2, Oracle Database, Other, Patching
I was playing with the query published by Syed Jaffar Hussain to list installed patches using DBMS_QOPATCH package that I described here http://dba24.pl/2016/07/12/how-to-list-the-db-patch-details-in-sql/. Unfortunately I came across some problems and would like to...
by Maciej Tokar | Jul 13, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
I would like to gather here in this document some specific traits of the Container Databases of Oracle 12c (Multitenancy) – the traits the are not broadly known. The list will be extended when some interesting characteristic of CDBs/PDBs pops up. RMAN...
by Maciej Tokar | Jul 12, 2016 | Oracle 12c R1, Other, Scripts, SQL
Syed Jaffar Hussain has published an interesting note on how to query database with SQL for patches that have been installed. It works starting from version 12.1.0.1. Please find Syed’s original note here:...
by Maciej Tokar | Jul 12, 2016 | Other
If you need to play and test your with regular expressions here you can find nice testing tool https://regex101.com/ About the author Maciej Tokar An Oracle technology geek and crazy long distance runner, DBA24 Owner Senior Oracle DBA / Consultant /...
by Maciej Tokar | Jul 7, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
Playing lately with PDBs and CDBs I have encountered interesting problem. While doing some investigations I found out that it is possible to affect the CDB$ROOT parameters from the PDB level what shouldn’t be possible in my humble opinion. Let’s go...
