Oracle Cloud Infrastructure and SSH Keys – Jump!
This post was originally published on this siteJump! In our Trivadis Oracle Cloud Infrastructure training environments, we never use direct access to an application or database server by a public IP address. For this case, we use an Oracle Linux based bastion host which acts…
Syntax Highlighting With SQL Developer
This post was originally published on this siteIntroduction A customer asked me if it is possible show unused identifiers in SQL Developer. Since there is no PL/SQL compile warning for that, you might be tempted to say no. But you can always use PL/SQL Cop…
Useful Oracle tools – DBCOMP
This post was originally published on this siteGetting 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…
Be careful with ‘save state’ in Data Guard configuration
This post was originally published on this siteUsers 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…
Book Review: Practical Oracle SQL by Kim Berg Hansen
This post was originally published on this siteI work with SQL since decades, and I think to have some practical experience with writing SQL queries on Oracle databases. So why should I buy a book about practical Oracle SQL? If you are in a similar…
Win! Win! Win! – A signed copy of Practical Oracle SQL
This post was originally published on this siteHere’s a copy of my Practical Oracle SQL book: You want it? Join my SQL raffle and you might win it… If we had all been out to conferences like we used to, I’d have brought a book…
Oracle Critical Patch Update April 2020 – Statistiken und Grafiken
This post was originally published on this siteWie (fast) jedes Quartal, gibt es auch in diesem Quartal einige Statistiken und Grafiken zum aktuellen Oracle Critical Patch Update (CPU). Gesamtzahl der veröffentlichten Patches pro CPU (seit 2015) Anzahl Patches pro betroffenem Produkt (arithmetisches Mittel) Anzahl Datenbank-Patches…
Downgrade einer RAC-Datenbank mittels garantiertem Restore-Punkt
This post was originally published on this siteErfahrungsgemäß versucht man, nach einem Datenbank-Upgrade meistens, in jedem Fall auf der höheren Version zu bleiben und evtl. auftretende Anwendungsprobleme in der neuen Umgebung zu löschen. Aber wenn „alle Stricke reißen“ oder wenn unmittelbar während oder nach des…
Last Week in Stream Data Integration & Stream Analytics – 16.4.2020
This post was originally published on this siteThis is the 189th 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 from…
Social Media @trivadis