Trivadis LAB: Simple Vagrant Setup of Windows AD Server
This post was originally published on this siteOne of my biggest problems when I started to look into Kerberos Authentication, Oracle Centrally Managed Users as well Oracle Enterprise User Security was the availability of an Active Directory to setup test cases. It is usually not…
Last Week in Stream Data Integration & Stream Analytics – 1.9.2020
This post was originally published on this siteThis is the 201st edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
AWR Flush Levels
This post was originally published on this siteFrom version 12.1.0.2 onward, for taking AWR snapshots, you have the choice between four AWR flush levels: BESTFIT, LITE, TYPICAL and ALL. If you check the Oracle Database documentation, you won’t find much information about the difference between…
Formatting SQL Code Blocks in Markdown Files
This post was originally published on this siteIntroduction Everything Changes. Our Trivadis SQL & PL/SQL Coding Guidelines are no exceptions. We plan to change rule #1 of our coding styles. From “Keywords are written uppercase, names are written in lowercase.” to “Keywords and names are…
Last Week in Stream Data Integration & Stream Analytics – 24.8.2020
This post was originally published on this siteThis is the 200th edition of my blog series blog series around Stream Data Integration and Stream Analytics! Hurray, today is the 200th edition of my blog series When I started my series years ago I was not…
Last Week in Stream Data Integration & Stream Analytics – 17.8.2020
This post was originally published on this siteThis is the 199th 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…
Always Free Autonomous JSON Database?
This post was originally published on this siteIntroduction Oracle just released the Autonomous JSON Database (AJD). This is a special version of the Autonomous Transaction Processing (ATP) database focussing on managing JSON documents via Simple Oracle Document Access (SODA) and SQL. Beda Hammerschmidt shows in…
Data Guard, Easy Connect and the Observer for multiple configurations
This post was originally published on this siteEZConnect One of the challenges of automation in bin Oracle Environments is dealing with tnsnames.ora files. These files might grow big and are sometimes hard to distribute/maintain properly. The worst is when manual modifications are needed: manual operations,…
Script to check Data Guard status from SQL
This post was originally published on this siteIn a previous blog post I have explained how to get the basic configuration from x$drc and display something like: OBJECT_ID DATABASE INTENDED_STATE CONNECT_STRING ENABLED ROLE RECEIVE_FROM SHIP_TO FSFOVALIDITY STATUS ——— ————– —————– —————————- ——- ——– ———— ————–…
Social Media @trivadis