Very often analytical queries have a requirement to group as well as filter data based on calendar periods like a fiscal year or custom financial period. Oracle Database 26ai has introduced a number of new Calendar Functions like CALENDAR_YEAR,CALENDAR_QUARTER,FISCAL_YEAR,FISCAL_MONTH, FISCAL_YEAR_END_DATE etc which enables us to extract time-based information across different…
The new Oracle GoldenGate 26ai AI Service feature enables the integration of external AI providers directly into the data replication process. In this post we will see how we configure the GoldenGate AI Service using OCI Generative AI as the provider. The Replicat process COLMAP parameter has a new function…
In a previous post, we discussed the installation of GoldenGate 26ai on a Linux x86-64 platform. This post outlines the replication of Vector Embeddings between two Oracle 26ai databases using GoldenGate 26ai (23.26.1). Load the ONNX vector imbedding model into the database [oracle@perth onnx_models]$ sqlplus system/Oracle_4U@perth:1521/pdb1SQL*Plus: Release 23.26.1.0.0 – Production…
This note outlines the installation of GoldenGate 26ai (version 23.26.1) on a Linux x86-64 operating system. We will briefly look at some of the new features available in GoldenGate 26ai. These will be discussed in more detail in upcoming posts! Download GoldenGate 26ai software Oracle GoldenGate Downloads Install GoldenGate 26ai…
This note illustrates the installation of Oracle Database 26ai on an Oracle Linux 8.10 VirtualBox hosted environment. Download patch 38743961 which is the Database RU 23.26.1 Gold Image patch. Create the directory structure to host the Oracle 26ai database software home and unzip the p38743961_230000_Linux-x86-64.zip file in this location. [oracle@perth…
In the previous post we had seen how to create and configure a GoldenGate 23ai Data Transforms deployment. https://gavinsoorma.com.au/knowledge-base/goldengate-23ai-data-transforms/ In this post we will see how we can use the new Data Transforms 23ai type deployment to load data between two Oracle OCI Autonomous Databases. Example View the connections to…
In earlier Data Guard versions, we could only create Data Guard Broker configurations via the standard DGMGRL command-line utility. Oracle Database 23ai has extended this and we can now create as well as manage Data Guard environments using additional easy to use and flexible methods. This new feature allows for…
In Oracle Database versions prior to 23ai we had the ability to define a column as DEFAULT ON NULL, allowing it to be assigned a default value if it was explicitly assigned a null value in an INSERT statement. Oracle Database 23ai extends that earlier functionality and provides the new…
Oracle Data Guard 23ai provides a number of new VALIDATE options to check the preparedness or validity of Primary and Standby databases part of a Data Guard configuration before we perform a role change operation like a Data Guard Switchover. The VALIDATE DATABASE command performs a comprehensive set of database…
A number of new database fixed V$ views have been added in Oracle Data Guard 23ai that are very useful in monitoring an Oracle Data Guard environment. V$DG_BROKER_CONFIG view provides an overall summary of an Oracle Data Guard broker configuration. The view provides the similar information which the Data Guard…
Very often database user passwords are hard coded in application configuration files and when the application user’s database password is changed there will be an application outage due to an ORA-01017 invalid username or password error – until the new password is changed in all the application configuration files where…
In the previous post https://gavinsoorma.com.au/knowledge-base/prepare-database-for-data-guard/, we saw how we can use the PREPARE DATABASE FOR DATA GUARD command to automate many of the manual steps which are prerequisites for configuring an Oracle Data Guard environment. In this post we will look at how to create an Oracle Database 23ai physical…
This step-by-step guide describes the steps used to configure Transport Layer Security (TLS) in the database and enable TCP over SSL (TCPS) connections. #######################################################################Environment#######################################################################19c Client – rac01.localdomain12c R2 Database Server – linux01.localdomain#############################################################################Create an auto-login wallet on database server#############################################################################[oracle@linux01 oracle]$ mkdir -p /u02/app/oracle/wallet[oracle@linux01 oracle]$ orapki wallet create -wallet “/u02/app/oracle/wallet” -pwd DreamLiner787…
The PREPARE DATABASE FOR DATA GUARD command (first introduced in Oracle Database 21c) configures a database for use as a primary database in a Data Guard broker configuration and automates many steps which were previously manually performed. The PREPARE DATABASE FOR DATA GUARD command sets the following database parameters: It…
The LONG and LONG RAW data types have been deprecated since quite some time. But many a time we find in some customer databases tables still with these data types existing. The Oracle Database 23ai Data Pump TRANSFORM parameter now includes the new option LONG_TO_LOB to enable us to migrate…
Trail file management has been made so much easier in GoldenGate 23ai! We can do the following very easily in GoldenGate 23ai using the WebUI: If we want to analyze a particular trail file to maybe investigate some issue, in GoldenGate Cloud Services we had to take a manual backup…
Problem: Getting the error that the GoldenGate Service Manager “is not available” when connecting to a Deployment via the adminclient utility. If the GoldenGate Service Manager has been configured as a daemon, the Service Manager start is integrated into the server startup routines and we can check the status of…
In the earlier post (https://gavinsoorma.com.au/knowledge-base/goldengate-23ai-microservices-deployment-security-part-one/) we discussed how to create the various server, client and Root CA certificates on the source as well as the target. In this post we will see how we can use the certificates to configure security in source and target deployments and create a secure…
In this post we will see how we can configure security in GoldenGate 23ai Microservices deployments using certificates. In an earlier post (https://gavinsoorma.com.au/knowledge-base/configuring-a-secure-goldengate-21c-deployment-with-certificates-and-wallets/) we discussed configuring security in a GoldenGate 21c deployment – in GoldenGate 23ai we do not use wallets any longer as in the case of previous versions….
TLS or Transport Layer Security (earlier called SSL) is a cryptographic protocol that provides secure exchange of data sent between applications over the network. The TLS protocol provides data privacy and data integrity for routing data over the network between the Distribution Server and Receiver Server as well as the…