Application integration & Middleware, Database Administration & Monitoring, Oracle Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate 30.12.2020 by Oracle Team When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons: Oracle 9.2.0.6 database is(…)
Oracle Optimizer Statistics Gathering – pending and history 29.12.2020 by Oracle Team By Franck Pachot . This was initially posted to CERN Database blog on Wednesday, 12 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Demo table I create a(…)
Oracle Building a network bonding between 2 cards on Oracle Linux 28.12.2020 by Marc Wagner I recently needed to configure bonding between 2 network cards on a customer side and I wanted trough this blog to share my findings and how I built it showing some traces. I will also do a short comparison of(…)
Oracle Password rolling change before Oracle 21c 27.12.2020 by Oracle Team By Franck Pachot . You may have read about Gradual Password Rollover usage from Mouhamadou Diaw and about some internals from Rodrigo Jorge. But it works only on 21c which is(…)
Oracle Oracle SPD status on two learning paths 19.12.2020 by Oracle Team By Franck Pachot . I have written a lot about SQL Plan Directives that appeared in 12c. They were used by default and, because of some side effects at the time of 12cR1 with legacy(…)
Oracle NTP is not working for ODA new deployment (reimage) in version 19.8? 18.12.2020 by Marc Wagner Having recently reimaged and patched several ODA in version 19.8 and 19.9, I could see an issue with NTP. During my troubleshooting I could determine the root cause and find appropriate solution. Through this blog I would like to share(…)
Oracle Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID 15.12.2020 by Oracle Team By Franck Pachot . This was initially posted to CERN Database blog on Thursday, 27 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Did you ever try to(…)
Oracle Oracle write consistency bug and multi-thread de-queuing 14.12.2020 by Oracle Team By Franck Pachot . This was initially posted on CERN Database blog where it seems to be lost. Here is a copy thanks to web.archive.org Additional notes: – I’ve tested and got the(…)
Database Administration & Monitoring, Database management, Oracle, Security Oracle 21c Security : Mandatory Profile 11.12.2020 by Oracle Team By Mouhamadou Diaw With Oracle 21c, it is now possible to enforce a password policy (length, number of digits…) for all pluggable databases or for specific pluggable databases via profiles. This is done by creating a mandatory profile in the(…)
Database Administration & Monitoring, Database management, Oracle, Security Oracle 21c Security : Gradual Database Password Rollover 10.12.2020 by Oracle Team By Mouhamadou Diaw Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of(…)