SQL in your browser — DuckDB Web Shell for purely local data analytics
I am excited about a number of things. First and foremost is DuckDB Web Shell — a web assembly implementation of DuckDB that you can run in your browser. …
Category: Database
Refreshable PDB out of sync ORA-00308
When checking the status of the backups of the databases on a baremetal ODA (X8-2-HA) we noticed an error in the RMAN logfiles: This ODA was recently patched to …
Gitpod Workspace for Oracle Database Free 23ai–click and run, free and in 7 minutes
I am an enthusiastic user of Gitpod – a platform for ephemeral cloudbased workspaces. Click on a URL and a workspace is started for you (and for me). From …
Oracle Database 23c–some intriguing new features–dbms_pipe, Prometheus, pre-authenticated request URL, reset database session, Vector Search
This article is really just a quick draft to remind myself of some really interesting new Oracle Database features that I want to further investigate. Very succinctly: Pre Authenticated …
How to enable Oracle Database Azure AD authentication
As of Oracle database release update 19.18 a new authentication method was made available utilizing Azure AD (Entry ID as its named by Microsoft recently) Oauth tokens. Using this …
A first look at the Autonomous Database container image
September 29, 2023
Oracle Cloud, Cloud, Containers, Database, Databases, Platform Technology, Podman, Serverless, Technology
No Comments
Yesterday Oracle released their latest Autonomous database offering in a container image to try (most of) the Automous database technology without requiring access to the Oracle Cloud (OCI). This …
Automated and Rapid Creation of Non-Production Oracle Databases for Test and Development
The production database is the holy grail of any organisation or at least any microservice or business application. The data and the current structures and definitions of the database …
First steps in rotating secrets in AWS Secrets Manager
Introduction AWS Secrets Manager was released in 2018. It is a nice replacement for secret strings in the SSM Parameter Store. With Secrets Manager it is possible to automate …
Oracle Database 23c as Graph Database–SQL Property Graph for network style querying
I bet you are used to relational data structures that you query using SQL. And so do I. And there is nothing in terms of data that a good …
Live Handson Environment for Modern Oracle Database Programming
My fellow Oracle ACE Directors and former AMIS-colleagues Patrick Barel and Alex Nuijten have co-authored an impressive book: The book discusses many of the wonders of SQL and PL/SQL …
Oracle Database 23c–Fine Grained Locking–Lock Free Reservations
This should surprise if not baffle you. Session 1 inserts a record and commits it. Session 1 performs an update on this record. And does not yet commit its …
Get going with Oracle Database 23c Free
A new major Oracle Database release is a special occasion. I joined Oracle in May 1994 just after the Oracle7 release (December 1993) although I worked with Oracle6 for …
Unified Auditing not possible for Oracle Database XE (Express Edition)
I recently tried to get Unified Auditing going for Oracle Database XE. I could not really find instructions – not even through ChatGPT – and finally reached out to …
Oracle Database 23c–new feature highlights (release February 2023?)
Based on the fascinating Twitter thread by Philipp Salvisberg covering the presentation by Gerald Venzl at DOAG 2022 I would like to mention a few of the features that …
Migrating Oracle Enterprise Edition database To Standard Edition using Transportable Tablespaces
Introduction Oracle database Standard Edition (SE) has the main features of a RDBMS database and cost significantly less than Oracle Enterprise Edition (EE). Migrating a database from Oracle Enterprise …
Delay in establishing RAC Database connections after upgrading from Oracle 11g.
After upgrading to Oracle 12c, 19c, database connections take a long time (10 sec or more), before the connections are established. The connection time was less than 0.5 sec …
Pseudo Change Timestamp–Finding recently changed table rows using Flashback Version Query to provide a surrogate last_changed column
My challenge: replicate changes from database A to database B, once per day. The tables involved are pretty big (100M records). I really would not want to process them …
Quick start with free managed PostgreSQL database on ElephantSQL
This article shows you can quickly get started with a free, managed PostgreSQL database with a table full of country data (using ElephantSQL). ElephantSQL is a hosted, managed PostgreSQL …
Steampipe–analyze data from cloud, file, platform, IaC using SQL queries
In our daily work we are dealing with data from many sources. Data in CSV files, from Cloud APIs, in mail servers, configuration files, Terraform plans, in logging systems, …
Brief: What is Oracle Wallet?
An Oracle Wallet is an encrypted file that contains database credentials – username and password – for connecting to an Oracle Database. This avoids writing hard code user passwords …
Connecting Go application to Oracle Database–On Prem and Autonomous , with and without Oracle Client libraries
I have been struggling a bit with this one: how to connect from a Go application to an Oracle Database – both a locally running database as well as …
Oracle Database 21c XE, setting up a demo environment using Vagrant and Oracle VirtualBox (part 4)
I wanted to set up a demo environment with Apache Kafka (an open-source distributed event streaming platform) and an Oracle Database, all within containers. For my purpose I opted …
Oracle Database 21c XE, setting up a demo environment using Vagrant and Oracle VirtualBox (part 3)
I wanted to set up a demo environment with Apache Kafka (an open-source distributed event streaming platform) and an Oracle Database, all within containers. For my purpose I opted …
Oracle Database 21c XE, setting up a demo environment using Vagrant and Oracle VirtualBox (part 2)
I wanted to set up a demo environment with Apache Kafka (an open-source distributed event streaming platform) and an Oracle Database, all within containers. For my purpose I opted …
Simple queries against Oracle Cloud NoSQL Database
I have been struggling in my first simple steps with querying data in a NoSQL Database table on Oracle Cloud. Creating the table is easy enough – either in …
Oracle Database 21c XE, setting up a demo environment using Vagrant and Oracle VirtualBox (part 1)
I wanted to set up a demo environment with Apache Kafka (an open-source distributed event streaming platform) and an Oracle Database, all within containers. For my purpose I opted …
“You have to give a little… scripting for 12c+”
or Publishing a cleanup script for Oracle 12c+ At the moment I’m just for fun collecting Linux scripts from my direct colleagues. And while I was busy to think …
Preparation for migrating data to Oracle Virtual Private Database
August 10, 2021
AMIS, Database, Databases, DBA Oracle, Oracle, Oracle 12, SQL, sqlplus, Technology
No Comments
preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business …
Executing JavaScript from PL/SQL in Oracle Database 21c with Multi Language Engine
Oracle Database Release 7 – end of 1993 – introduced PL/SQL as language for Stored Procedures, Functions and Triggers. This was just before I joined Oracle Corporation, in May …
How to build [a CI/CD pipeline for] an Oracle Database application–kicking off a six part series
Build is an overloaded term in the world of software engineering. Building software used to be mainly a fancy way of saying “programming”. Now after the construction of the …
How to unit test a SQL query?
A simple challenge: I am working on a SQL query. Not a trivial query. I am trying various approaches. I believe I may have found a solution that works. …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)
March 5, 2021
Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, DevOps, PL/SQL, Software Development
No Comments
What’s in a name? A title is important and I hope that it describes well what I do want to share with you in this series of articles. It …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (6)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
1 Comment
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)”, I did show you the database structure. This time I …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)”, I gave you an introduction. This time I will elaborate …
First code and cli free steps with Oracle Database 21c in Oracle Cloud
Oracle Database 21c has been released – for now only in the cloud. Starting to explore – that is what we call playing with it – it easy and …
How to dynamically Schedule EM Blackouts after PatchTuesday
November 7, 2020
Enterprise Manager, AMIS, DBA Oracle, PL/SQL, Platform Technology, Tools
No Comments
In the organization I’m currently working for, the OS-patch schedule depends on PatchTuesday (PT) just as Microsoft, Adobe or Oracle are using. And PatchTuesday is, as you all know, …
AWS Shop example: SNS duplicate messages
Introduction Our shop example is now in production, wohoo!!! When you are using our example program in production, you might see that some sales are updated multiple times in …