Friday, 6 February 2026

Install and Configure 26AI Database on Linux

Topic: Install and Configure 26AI Database on Linux

Deployment Diagram:

In this QuickStart, we learn how to:

Infrastructure details
System configuration and RPM installation
Directory and User Creation
Unzip 26AI Software Binaries and installation
Set Oracle user Bash profile
Configure listener and network service
Install database using DBCA
Validation

Step-1 Infrastructure details

OS Details	Host Name	Database Version	ORACLE_HOME
8.6 (Ootpa)	26AI.example.com	23.26.1.0.0	/u01/app/oracle/product/26.0.0/dbhome_1

Ste-2 System configuration and rpm installation

Insert below parameter to /etc/sysctl.conf

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

Create file /etc/security/limits.d/oracle-database-26ai.conf and insert the following values in it.

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

oracle hard memlock 134217728

oracle soft memlock 134217728

oracle soft data unlimited

oracle hard data unlimited

Install below RPM package

dnf install -y bc

dnf install -y binutils

dnf install -y compat-libstdc++-33

dnf install -y elfutils-libelf

dnf install -y elfutils-libelf-devel

dnf install -y fontconfig-devel

dnf install -y glibc

dnf install -y glibc-devel

dnf install -y ksh

dnf install -y libaio

dnf install -y libaio-devel

dnf install -y libXrender

dnf install -y libXrender-devel

dnf install -y libX11

dnf install -y libXau

dnf install -y libXi

dnf install -y libXtst

dnf install -y libgcc

dnf install -y librdmacm-devel

dnf install -y libnsl.i686

dnf install -y libnsl2

dnf install -y libnsl2.i686

dnf install -y libstdc++

dnf install -y libstdc++-devel

dnf install -y libxcb

dnf install -y make

dnf install -y net-tools # Clusterware

dnf install -y nfs-utils # ACFS

dnf install -y python # ACFS

dnf install -y python-configshell # ACFS

dnf install -y python-rtslib # ACFS

dnf install -y python-six # ACFS

dnf install -y targetcli # ACFS

dnf install -y smartmontools

dnf install -y sysstat

dnf install -y gcc

dnf install -y unixODBC

dnf install -y libnsl

dnf install compat-openssl10*

dnf install policycoreutils-python-utils-2.9-1*

Disable Firewall

[root@prim ~]# systemctl stop firewalld

[root@prim ~]# systemctl disable firewalld

[root@prim ~]#

Step-4 Unzip 26ai Software Binaries and Installation

[oracle@26AI ~]$ cd $ORACLE_HOME

[oracle@26AI dbhome_1]$ pwd

/u01/app/oracle/product/26.0.0/dbhome_1

[oracle@26AI dbhome_1]$ ./runInstaller

- Set up Software Only

- Single instance database installation

- Click on next

- Set the Inventory Directory and click Next

- Click on next

- Click on Next

- We can ignore the Check and click on next

- Click on install

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/26.0.0/dbhome_1/root.sh

Validation:

Step 4: Set the Oracle user Bash profile

[oracle@26AI ~]$ cat .bash_profile

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=26AI.example.com

export ORACLE_UNQNAME=26CDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/26.0.0/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export ORACLE_SID=26CDB

export PDB_NAME=pdb1

export DATA_DIR=/u02/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Step-6 Configure the listener and network service

[oracle@26AI admin]$ lsnrctl start

[oracle@26AI admin]$ lsnrctl status

[oracle@prim admin]$ vi tnsnames.ora

[oracle@prim admin]$ cat tnsnames.ora

Step 7: Install database Using DBCA

- Select Create a Database

[oracle@prim ~]$ dbca

- Click on Advance configuration

- Click on Next

- Mention Global database name, SID, Click on Create as container database.

- Click on Next

- Specify the FRA location, Click on Enable Archiving

- Specify the Archive location

- Next screen will show running listener

- Click on next

- Specify the Memory target to the database

- Click on character tab and select AL32UTF8 and AL16UTF16

- Click on Next

- Enter the Admin user password

- Select Create database and click on next

- Click on Finish

- DB creation progress

- Click on Close

Step-8 Validation

Thursday, 27 November 2025

kernel:watchdog: BUG: soft lockup - CPU#0 stuck for 22s! [sh:57366]

Error:

kernel:watchdog: BUG: soft lockup - CPU#0 stuck for 22s! [sh:57366]

Solution:

server1:~ # echo 20 > /proc/sys/kernel/watchdog_thresh

server1:~ # echo "kernel.watchdog_thresh=20" > /etc/sysctl.d/99-watchdog_thresh.conf

server1:~ # sysctl -p /etc/sysctl.d/99-watchdog_thresh.conf

RMAN-06729: no backup of the SPFILE found to restore

If the error below occurs while executing the AUXILIARY RMAN command

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 11/27/2025 14:09:10

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-06026: some targets not found - aborting restore

RMAN-06729: no backup of the SPFILE found to restore

Solution: To resolve this error, execute the RMAN connect command from the Standby Database

[oracle@dg-node02 DB19c]$ rman TARGET sys/*******@db19c_stby AUXILIARY sys/*****@db19c

Tuesday, 9 September 2025

Oracle to MySQL Unidirectional Replication

Topic: Oracle to MySQL Unidirectional Replication

Oracle Goldengate facilitates heterogeneous data replication, including replication from an Oracle source database to a MySQL target database. This process involves capturing changes from the Oracle database and applying them to the MySQL database in real time

Deployment diagram:

Infrastructure Details:

Oracle DB Details
OS version	Red Hat Enterprise Linux release 7.6 (Maipo)
DB Version	19.3.0.0.0
GG Version	19.1.0.0.210228
Host Name	DB19C.example.com

Oracle DB Details
OS version	Red Hat Enterprise Linux release 7.6 (Maipo)
PG Version	8.0.43-commercial
GG Version	19.1.0.0.0
Port number	3306
Cluster location	/var/lib/mysql
Host Name	Node01.example.com

In this QuickStart, we learn:

· Prerequisite Steps

- Validate the Oracle GG setup is already there

- Create a schema for replication (Oracle)

- Create a schema and database for replication (Mysql)

- Install the Oracle GoldenGate for MySQL

· Configure the Oracle GG replication to MySQL

- Configure the manager process for both sides (Oracle and MySQL)

- Configure the extract process on the Oracle Side

- Configure replication process on the MySQL side

Validation

INFORMATION: We already configured the GG setup in Oracle. Here, we will configure the MySQL GG setup and replication

Step-1: Prerequisite Steps

- Validate the Oracle GG setup is already there

- Details of schema use for replication (Oracle)

- Details of database use for replication (MySQL)

- Install the Oracle GoldenGate for MySQL

-bash-4.2$ unzip -q GG_19.1.0.0.0_MySQL_Linux_x86-64.zip

-bash-4.2$ tar -xvf ggs_Linux_x64_MySQL_64bit.tar -C /u01/app/gg/product/19c

Step-2: Configure the Oracle GG replication to MySQL

- Configure the manager process (oracle)

- Configure the manager process (MySQL)

- Configure credentialstore (Oracle)

GGSCI (DB19C.example.com) 4> add credentialstore

GGSCI (DB19C.example.com) 5> Alter credentialstore add user C##GGUSER@pdb alias orcldb domain admin

Password:

Credential store altered.

GGSCI (DB19C.example.com) 5> Alter credentialstore add user C##GGUSER@DBA19C alias DBA19C domain admin

Password:

Credential store altered.

GGSCI (DB19C.example.com) 6> Info credentialstore domain admin

- Configure credentialstore (MySQL)

GGSCI (Node01.example.com) 6> add credentialstore

Credential store created.

GGSCI (Node01.example.com) 7> ALTER CREDENTIALSTORE ADD USER hr ALIAS hr

Password:

Credential store altered.

GGSCI (Node01.example.com) 8> info credentialstore

- In heterogeneous data replication, we must generate a source definitions file and copy it onto the MySQL DB server (target Server)

[oracle@DB19C OGG-19.1.0.0]$ ./defgen paramfile /u02/app/gg/product/OGG-19.1.0.0/dirprm/defgen.prm

[oracle@DB19C dirdef]$ scp GGTEST.def mysql@Node01.example.com:/u01/app/gg/product/19c/dirdef

- configure a checkpoint in MySQL (Target side)

GGSCI (Node01.example.com) 2> add checkpointtable hr.ggschkpt

Information: You need to configure a checkpoint table in GoldenGate to ensure data integrity and fault tolerance for the Replicat process. A checkpoint table prevents data loss or duplication in the event of an unexpected shutdown by saving transaction recovery points directly within the target database, rather than relying solely on less-reliable checkpoint files. (checkpoint table must be configured on the target side)

- Configure the extract and Extract Pump process on the Oracle Side

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 13>add extract EHRINT01, integrated tranlog, begin now

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 14>add exttrail /u02/app/gg/product/OGG-19.1.0.0/dirdat/ET, extract EHRINT01, megabytes 100

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 15>REGISTER EXTRACT EHRINT01 DATABASE CONTAINER (PDB);

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 2> view param EHRINT01

EXTRACT EHRINT01

USERIDALIAS DBA19C DOMAIN admin

EXTTRAIL /u02/app/gg/product/OGG-19.1.0.0/dirdat/ET

SOURCECATALOG PDB

TABLE hr.test;

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 3>

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 3> Add extract EHRDP01, EXTTRAILSOURCE /u02/app/gg/product/OGG-19.1.0.0/dirdat/ET

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 3> Add rmttrail /u02/app/gg/product/OGG-19.1.0.0/dirdat/ET, extract EHRDP01

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 5> view param EHRDP01

EXTRACT EHRDP01

USERIDALIAS DBA19C DOMAIN admin

RMTHOST Node01.example.com, MGRPORT 7809

RMTTRAIL /u01/app/gg/product/19c/dirdat/om

SOURCECATALOG PDB

TABLE hr.test;

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 6> start EHRINT01

Sending START request to MANAGER ...

EXTRACT EHRINT01 starting

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 7> start EHRDP01

Sending START request to MANAGER ...

EXTRACT EHRDP01 starting

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 8> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EHRINT01 00:00:00 22:00:29

EXTRACT RUNNING EHRDP01 00:00:00 22:00:34

GGSCI (DB19C.example.com as C##GGUSER@DBa19c/CDB$ROOT) 9>

- Configure replication process on the MySQL side

GGSCI (Node01.example.com) 13>add replicat myrep1, exttrail /u01/app/gg/product/19c/dirdat/ET

GGSCI (Node01.example.com) 15> view param myrep1

REPLICAT myrep1

TARGETDB hr, USERID hr, PASSWORD ***

SOURCEDEFS /u01/app/gg/product/19c/dirdef/GGTEST.def

MAP pdb.hr.test TARGET hr.test;

GGSCI (Node01.example.com) 16>

GGSCI (Node01.example.com) 16> start myrep1

GGSCI (Node01.example.com) 19> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING myrep1 00:00:00 00:00:07

GGSCI (Node01.example.com) 20>

Step-3: Validation

- Insert data into table (Oracle side)

- Validate transaction from GG

[oracle@DB19C OGG-19.1.0.0]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO

Linux, x64, 64bit (optimized), Oracle 19c on May 25 2019 06:46:13

Operating system character set identified as UTF-8.

GGSCI (DB19C.example.com) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EHRINT01 00:00:00 00:00:08

EXTRACT RUNNING EHRDP01 00:00:00 00:00:06

GGSCI (DB19C.example.com) 2>

GGSCI (DB19C.example.com) 2> stats EHRINT01

Sending STATS request to EXTRACT EHRINT01 ...

Start of Statistics at 2025-08-31 15:35:21.

Output to /u02/app/gg/product/OGG-19.1.0.0/dirdat/om:

Extracting from PDB.HR.TEST to PDB.HR.TEST:

*** Total statistics since 2025-08-31 15:34:06 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Daily statistics since 2025-08-31 15:34:06 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Hourly statistics since 2025-08-31 15:34:06 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Latest statistics since 2025-08-31 15:34:06 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

End of Statistics.

GGSCI (DB19C.example.com) 3> stats EHRDP01

Sending STATS request to EXTRACT EHRDP01 ...

Start of Statistics at 2025-08-31 15:35:35.

Output to /u01/app/gg/product/19c/dirdat/om:

Extracting from PDB.HR.TEST to PDB.HR.TEST:

*** Total statistics since 2025-08-31 15:34:07 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Daily statistics since 2025-08-31 15:34:07 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Hourly statistics since 2025-08-31 15:34:07 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Latest statistics since 2025-08-31 15:34:07 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

End of Statistics.

GGSCI (DB19C.example.com) 4>

- Validate from target side (MySQL)

- Validate from the GG process

GGSCI (Node01.example.com) 18> start myrep1

REPLICAT OMREP1 is already running.

GGSCI (Node01.example.com) 19> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING myrep1 00:00:00 00:00:07

GGSCI (Node01.example.com) 20>

GGSCI (Node01.example.com) 20> stats myrep1

Sending STATS request to REPLICAT myrep1 ...

Start of Statistics at 2025-08-31 15:39:31.

Replicating from PDB.HR.TEST to hr.test:

*** Total statistics since 2025-08-31 15:34:09 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Daily statistics since 2025-08-31 15:34:09 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Hourly statistics since 2025-08-31 15:34:09 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

*** Latest statistics since 2025-08-31 15:34:09 ***

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

End of Statistics.

GGSCI (Node01.example.com) 21>

Certification Details:

Oracle Certified Professional, MySQL 8.0 Database Administrator MySQL Implementation Certified Associate MySQL HeatWave Implementation Certified Associate Rel 1 Oracle Cloud Infrastructure 2025 Certified Multicloud Architect Professional Snowpro Core Certified Oracle GoldenGate 12c Certified Implementation Specialist Oracle Cloud Infrastructure Foundations 2021 Oracle Autonomous Database Cloud 2021 Specialist Oracle Cloud Database Migration and Integration 2021 Certified Specialist Oracle Cloud Infrastructure Foundations 2020 Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate Oracle Cloud Infrastructure 2019 Architect professional Oracle Cloud Infrastructure 2019 Architect Associate Oracle Autonomous Database Cloud 2019 Specialist Oracle 12c OCP Oracle 11g OCP Oracle 10g OCP oracle 9i pl/sql OCA