Oracle GoldenGate 18c Upgrade

This note outlines the procedure followed to upgrade GoldenGate 12.3 to the latest 18c version ( Note: If we are upgrading from Oracle GoldenGate or earlier, we also need to upgrade the Replicat checkpoint table via the GGSCI command UPGRADE CHECKPOINTTABLE [owner.table] If we are using trigger-based DDL replication support, then additional steps need […]

Minimizing downtime for Container and Pluggable Database (CDB and PDB) Upgrades

Oracle 12c Release 2 introduced a number of new features which would help reduce outages required for database upgrades. Multitenancy feature was introduced in Oracle 12.1 and these features introduced in Oracle 12.2 would help significantly in not only reducing the overall duration required for a database upgrade, but also in managing and having more […]

How to perform an Oracle 18c Container and Pluggable Database upgrade using dbupgrade

Shutdown the 12c Release 2 CDB and PDBs   [oracle@host02 bin]$ sqlplus sys as sysdba Connected to: Oracle Database 12c Enterprise Edition Release – 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO SQL> […]

Oracle 18c Grid Infrastructure Upgrade

Upgrade Oracle Grid Infrastructure to 18c Download the 18c Grid Infrastructure software (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html     Prerequisites Apply the patch 21255373 to the Grid Infrastructure software home Edit the /etc/security/limits.conf file and add the lines: oracle soft stack 10240 grid   soft stack 10240   Notes Need to have at least 10 GB of […]

Minimal Downtime Cross Platform Migration and 12c Database Upgrade using Data Guard

This note describes the procedure used to perform a minimal downtime platform migration from Windows to Linux as well as a database upgrade from Oracle to Oracle 12c ( We create a Data Guard physical standby database using the DUPLICATE FROM ACTIVE DATABASE feature, followed by a switchover and then we activate the standby […]

Upgrading from Oracle 11gR2 to Oracle 12c using Full Transportable Export and Import

The Transportable Tablespace (TTS) feature was introduced in Oracle 8i and the Cross-Platform Transportable Tablespace (XTTS) feature was introduced in Oracle 10g. Since it only involved the copy of the data files of the tablespace at the OS level and the copy (and maybe conversion) of the data files over the network, it was potentially […]

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 ?