Loading....

Oracle 21c New Feature – Prepare Database for Data Guard

The Data Guard Broker PREPARE DATABASE FOR DATA GUARD command configures a database to be used as a Primary Database in a Data Guard Broker configuration. It enables and sets a number of database parameters like LOG_BUFFER, DG_BROKER_START, STANDBY_FILE_MANAGEMENT, DB_BLOCK_CHECKSUM etc. It also enables FLASHBACK and ARCHIVELOG for the database and creates the Standby Redo […]

Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility

This note describes the process of upgrading an Oracle 12c Release 2 Non-Container Database to Oracle 19c and also converting the Non-CDB database to a Pluggable Database (PDB). The entire upgrade process is automated using the latest Oracle autoupgrade utility – autoupgrade.jar which is part of the new Oracle 12c database software release as well […]

Oracle 21c AutoUpgrade (Part 2)

This note describes the steps used to upgrade an Oracle 19c Pluggable Database (PDB) to Oracle 21c using the unplug/plug method via the new Autoupgrade utility. Source Container Database: ORCLCDB (19c ) Target Container Database: DB21C (21c ) ################################################################################################### 19c Pluggable Database ORCLPDB1 is hosted in 19c Container Database ORCLCDB ################################################################################################### [oracle@db21c ~]$ . oraenv […]

Oracle 21c AutoUpgrade (Part 1)

This note describes the steps used to upgrade an Oracle 19c database to Oracle 21c as well as convert the 19c Non-CDB database to a Pluggable Database (PDB) hosted in an Oracle 21c Container Database. Source Database: ORCL (19c Non-CDB ) Target Database: DB21C (21c CDB) ########################################################################### Create Auto Upgrade configuration file ########################################################################### [oracle@db21c ~]$ […]

GoldenGate How to handle replication with extra columns on source and target tables

Case A – Additional Column on Target Table In this example the JOBS table on the target database oradb2 has an additional IDENTITY COLUMN called ID SQL> conn demo/oracle@oradb1Connected.SQL> desc jobsName Null? Type—————————————– ——– —————————-JOB_ID NOT NULL VARCHAR2(10)JOB_TITLE NOT NULL VARCHAR2(35)MIN_SALARY NUMBER(6)MAX_SALARY NUMBER(6)SQL> conn demo/oracle@oradb2Connected.SQL> alter table jobs add (ID NUMBER GENERATED ALWAYS AS IDENTITY);Table […]

Installation and Configuration of GoldenGate 19c Microservices on RAC

In this note we will cover how to install and configure Oracle Goldengate 19c Microservices on an Oracle 19c RAC environment. We will then configure high availability for GoldenGate Microservices using Grid Infrastructure Agent XAG v10. Finally we will test the high availability by simulating a RAC node failure and verify that the GoldenGate Microservices […]

Unified Auditing – Getting Started

Introduction In previous releases of Oracle Database prior to Oracle 12c Release 1, there were separate audit trails for individual components. For example: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$ for Oracle Database Vault, Oracle Label Security, Starting with 12c Release 1, Oracle has unified all of the auditing types into […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?