/dev/shm and Oracle Memory management.

It is an in-memory mounted file system (tmpfs) and is very fast, but non-persistent when Linux is rebooted.The tmpfs file system is similar to a RAMDISK, but supports resizing and memory paging. When these Automatic Memory Mangement is used in oracle, oracle will create as much as =(MEMORY_MAX_TARGET / granule size) files.For instance, when MEMORY_MAX_TARGET …

Install Ansible on CentOS 8

Ansible is an open-source IT automation tool used to automate configuration management, Step 1: Install and Enable EPEL repository [root@localhost ~]# dnf install epel-release -y CentOS Stream 8 - AppStream 2.5 MB/s | 22 MB 00:08 CentOS Stream 8 - BaseOS 6.2 MB/s | 22 MB 00:03 CentOS Stream 8 - Extras 25 kB/s | 18 kB 00:00 …

Drop Container Database including All PDBs

[oracle@testlab3 ~]$ sqlplus "/as sysdba" SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 7 13:47:47 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ …

Transparent Data Encryption (TDE) in Pluggable Databases (PDBs)

From Oracle database 12c introduced a new way to manage keystores, encryption keys and secrets using the ADMINISTER KEY MANAGEMENT command.wallet and keystore are same terminology Add the below entry in sqlnet.ora file ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /data/keystore) ) ) 2. Create Key store on CDB database and …

Restore Point at PDB level and flashback

There are many ways via we can create restore point at pdb level. Create restore point at pdb and dropping it. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO SQL> alter session set container=ORCLPDB; Session altered. SQL> create restore point flashback_test_pdb …

Restore Point at CDB level and flashback

Database (CDB) must be in archivelog mode we are at version 19.3 Before enable flashback database we need to make sure the database is in archive log mode. lets create normal restore point at CDB SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> create restore point flashback_test; Restore point created. SQL> drop restore point flashback_test; Restore …

How to Switch/Recreate Undo Tablespace at PDB Level

We are using 19.3 version for testing and database is having local undo enabled SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SELECT property_name, property_value FROM database_properties WHERE property_name = 'LOCAL_UNDO_ENABLED'; PROPERTY_NAME PROPERTY_VALUE ------------------------------ -------------------- LOCAL_UNDO_ENABLED TRUE SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB …

How to change hostname in RHEL 7

changing hostname using hostnamectl [root@testlab2 ~]# hostnamectl status Static hostname: testlab2 Icon name: computer-vm Chassis: vm Machine ID: 02792a34d11a7541a1264bf1089992dc Boot ID: 05c609ed7f8f4d64a84244723f6e1740 Virtualization: kvm Operating System: Oracle Linux Server 7.9 CPE OS Name: cpe:/o:oracle:linux:7:9:server Kernel: Linux 5.4.17-2102.202.5.el7uek.x86_64 Architecture: x86-64 To set new hostname testlab3 for the machine : # hostnamectl set-hostname testlab3 ## static # …

Migrating 11G database to 19C database using GoldenGate.

We have below details. we are going to replicate two schema "APP" and "SCOTT" Source database: 11G database at 11.2.0.4DB Name : ORCL Target Database 19C database at 19.3.0.0.0CDB Name : CDBPDB NAme : ORCLPDB Goldengate version 19.1.0.0.0. On 11G database source database. 1.create tablespace for Goldengate SQL> CREATE TABLESPACE goldengate DATAFILE '/data/19C/CDB/goldengate01.dbf' SIZE 100M …

OGG-01377 : CSN format supplied does not match the CSN format in the trail

error we are getting in ggserr.log 2021-07-29T16:56:43.385+0530 INFO OGG-03506 Oracle GoldenGate Delivery for Oracle, migrep.prm: The source database character set, as determined from the trail file, is we8mswin1252. 2021-07-29T16:56:46.536+0530 ERROR OGG-01377 Oracle GoldenGate Delivery for Oracle, migrep.prm: CSN format supplied does not match the CSN format in the trail. CSN supplied 2313362;. Expecting ORACLE format …