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 …
Category: Databases
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 …
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 …
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 …
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 …
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 …
A Quick how-to RMAN backup to OCI Object Storage
This is a quick how-to article on setting up RMAN to backup to Object Storage on OCI. This is applicable when you build your on Oracle database on an …
Migrating databases using Dataguard, some pitfalls and observations
My customer needed to migrate to a new set of datacenters, and while other services were able to “lift and shift”, the Oracle RAC database servers had to be …
Migrating an old (10.2.0.4) database to Oracle Cloud with minimal downtime
April 9, 2020
Oracle Cloud, AMIS, Architecture, Cloud, Database, Databases, DBA Oracle, Tools
2 Comments
Unlike most of our posts this post will contain almost no code or examples. But it hopefully will help somebody who ends up to be in the same situation …
Performance of relational database drivers. R2DBC vs JDBC
R2DBC provides non-blocking reactive APIs to relational database programmers in Java. It is an open specification, similar to JDBC. JDBC however uses a thread per connection while R2DBC can handle …
Calling an Oracle DB stored procedure from Spring Boot using Apache Camel
There are different ways to create data services. The choice for a specific technology to use, depends on several factors inside the organisation which wishes to realize these services. …
What is Apache Drill and how to setup your Proof-of-Concept
March 11, 2019
Data Analytics, Big Data, Data Warehousing & BI, Database, Databases, Microsoft Azure, NoSQL
2 Comments
Apache Drill is a schema-free SQL query engine. Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, …
InfluxDB V2.0 – Stack Implementation Proof of Concept
February 25, 2019
Internet Of Things, Cloud, Database, Databases, Frontend technology, Microsoft Azure
2 Comments
 "InfluxDB V2.0 – Stack Implementation Proof of Concept")
This blogpost will give you detailed instructions and information regarding the InfluxDB stack. Since February 2019 InfluxDB now consists not only the database itself, but also Telegraf, Chronograf and …
Enterprise Manager Convert to Cluster Database (RAC) fails without showing errors at Pre Configuration phase
Oracle Enterprise Manager Cloud Control 13c provides a wizard to convert a single-instance database to an Oracle RAC database. This requires the Oracle Database Lifecycle Management Pack for Enterprise …
Enterprise Manager DataGuard Add Standby Database fails without showing errors at Destination Preparation phase
Oracle Enterprise Manager Cloud Control 13c provides the Add Standby Database wizard to create a broker configuration that includes a primary database and one or more standby database. This …
How a double entry for LAST_ARCHIVE_TIMESTAMP can stop your audit purge in 12c
In the last nine month we were busy migrating our 11g databases to 12c rel. 2. Due to time constrictions we decided early in the project to migrate 1:1. …
InfluxDB for time series data
In this small blog post I will talk about when to use a time series database and why to use InfluxDB for this. But first of all I need …
Querying connected data in Graph databases with Neo4j
TL;DR; · Graph databases are ideal for query use cases with data with complex relationships and layers of connections · Its query language is fast, efficient and allows for …
How to deploy InfluxDB in Azure using a VM service with dedicated storage
October 12, 2018
Database, Cloud, Containers, Databases, Docker, IT, Microsoft Azure, NoSQL
2 Comments
InfluxDB isn’t natively supported on Azure. This blog post will teach you how to deploy InfluxDB (or any other database) in a VM with a managed disk on …
Crash recovery of Oracle databases using Commvault
Some time ago I published an article about creating a RMAN backup using Commvault. See: https://technology.amis.nl/2018/03/01/creating-rman-backups-using-commvault/ . In this article I describe how to execute a crash recovery using Commvault. …
Upgrade of Oracle Restart/SIHA from 11.2 to 12.2 fails with CRS-2415
We are in the process of upgrading our Oracle Clusters and SIHA/Restart systems to Oracle 12.2.0.1 The upgrade of the Grid-Infra home on a Oracle SIHA/Restart system from 11.2.0.4 …
How to fix Dataguard FAL server issues
One of my clients had an issue with their Dataguard setup, after having to move tables and rebuild indexes the transport to their standby databases failed. The standby databases …
Upgrade OEM 12.1.0.5 OMS to OEM13.2
Despite the potential of Oracle Management Cloud, I’m a fan of Oracle Enterprise Manager, with its small imperfections. So when noticing a 12c Oracle Enterprise Manager on Linux, and …
Oracle Open World 2017; day 1 observations
Just a quick note about day 1 at Oracle Open World. This Sunday traditionally is filled with presentations of usergroups, customers and product management, and at the end of …
ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
June 12, 2017
Oracle, Databases, DBA Oracle, ODA, Oracle 12, Performance and tuning, PL/SQL
No Comments
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …
Golden Gate 12c and DIY Sequence Replication with PL/SQL
May 5, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
2 Comments
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target …
Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to the query and the generated filename the Dump_Delimited function …
DIY Parallelization with Oracle DBMS_DATAPUMP
February 23, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
5 Comments
![DIY Parallelization with Oracle DBMS_DATAPUMP]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "DIY Parallelization with Oracle DBMS_DATAPUMP")
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 …
How About Oracle Database 12c Threaded_Execution
February 5, 2017
AMIS, Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12
No Comments
THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most …
Oracle 12c STIG Password Generator in PL/SQL
January 24, 2017
AMIS, Cyber Security, Database, Databases, DBA Oracle, DevOps, Engineered Systems, ExaData, ODA, Oracle, Oracle 12, PL/SQL, SQL
1 Comment
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to …
Serial database backups using Oracle Enterprise Manager
For several years now, I’ve been a fan of backups controlled by Enterprise Manager (of Grid Control, or Cloud Control, call it what you want). It is relatively easy …
One of the many nice new features in 12c database: code based access control
September 5, 2016
Cyber Security, Databases, Deployment, Oracle, Oracle 12, PL/SQL, Software Development, SQL
1 Comment
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it. So here’s the story.. For one of our customers …
Node.js and Oracle NoSQL Database
Oracle NoSQL Database is an interesting option to consider when you want a schemaless, fast, scale-able database which can provide relaxed (eventual) consistency. Oracle provides a Node.js driver for …
Oracle Database Appliance X6-2S and X6-2M, filling the gap
Oracle introduced the ODA X6-2S and ODA X6-2M. And no, they are not the successor of the quite popular ODA X5-2, which we installed and configured quite a number …
Oracle Database 11g: Virtual columns
Views in the Oracle database have several uses. You can use them to provide a view of data in different tables as a single object to query. You can …