Loading....

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 ~]$ […]

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 […]

Oracle 12c Release 2 Partitioning New Features

A number of enhancements to the Oracle database Partitioning option have been introduced in Oracle Database 12c Release 2. These include: Automatic List Partitioning Multi-Column List Partitioning Read-only Partitions Filtered Partition maintenance operations Online conversion of non-partitioned to partitioned table Partitioned External Tables   Similar to the interval partitioning method which was introduced in Oracle […]

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 ?