How to generate DDLs of existing lockdown profiles
In my last blog post I mentioned that I’ll write a new one on how to generate DDLs to recreate existing lockdown profiles – the time has come :). When I had to do it for the first time, I thought it would be as…
Lockdown profiles definition – NUL character
Playing more with lockdown profiles, I have discovered another interesting bit. For some entries and some columns of CDB/DBA_LOCKDOWN_PROFILES views (which are based on LOCKDOWN_PROF$ table), there is unnecessary NUL (ASCII code 0) character added at the end. In our environment it was the case…
Lockdown profiles definition inconsistencies
While working recently on lockdown profiles in 12.2 database with January 2020 Release Update installed, together with my colleague Loïc Fave, we have discovered some inconsistencies in how the information about already defined lockdown profiles is stored and used to enforce the rules. Loïc has…
‘ORA-19909: datafile 1 belongs to an orphan incarnation’ during duplicate for standby
Some time ago my colleague Pavel Tolstorukov asked me for help with failing DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE. The problem appeared during the recovery phase. The exact error looked like below: We worked on this together and were able to identify the…
Oracle 19c solves ORA-00026 when killing PDB sessions
Oracle Multitenant was a big architectural change for Oracle Database. I guess it was not so easy to introduce it to such a complex system. Unsurprisingly, there were some side effects introduced, but Oracle works hard to correct them. One example is ORA-00026: missing or…
Useful Oracle tools – DBCOMP
Getting lost writes (e.g. ORA-00752: recovery detected a lost write of a data block) is one of the worst DBA’s nightmares. There are a lot of very important questions popping up. Apart from the obvious ones on how to solve the problems reported (hopefully without…
Be careful with ‘save state’ in Data Guard configuration
Users are complaining that from time to time they are connecting to standby database which is opened read-only, instead to primary opened also for writing. What can be the root cause? Previous usage of below command: It keeps not only information about the state of…
Side effect of ExaWatcher workaround for LSOF check
While analysing the problem with ExaWatcher not being able to start, I found quite nasty side effect of a workaround implemented in recent versions of this useful tool. In fact, you will hit it only on Exadata X7 where you had previously implemented another workaround…
Learn and certify for free: Oracle Cloud Infrastructure and Oracle Autonomous Database
If you ever hesitated to jump into learning about Oracle Cloud Infrastructure or Oracle Autonomous Database the time is now! Oracle Cloud Free Tier together with Always Free Services is already available since last year. This is very useful, as it allows to familiarize with…
Useful Oracle tools – purgeLogs
Recently I’ve came across a nice tool provided by Oracle named purgeLogs, so I would like to shortly blog about it for reference (also for me). As the name suggests it is meant to be used for cleaning up log and trace files. Unfortunately, it…