Skip to main content

Oracle Database 12c Upgrade to 19c

Oracle 12c Container/Pluggable database upgrade to 19c

In this article, we will upgrade Oracle database Container database(CDB) and Pluggable database from 12c to 19c using Database Upgrade Assistant(DBUA).
Upgrade to 19c is possible from 11.2.0.4,12.1.0.2,12.2.0.1 and 18c.

Pre-Upgrade Tasks

First of all you need to take the backup of your database before performing the upgrade task and make sure to check the application compatibility with the newer version of the Oracle Database.
Complete the pre-upgrade steps for Oracle and ensure that your system meets the installation prerequisites.

Run the 19c pre-installation package on your system to complete the all OS level pre-requisites.

yum install -y oracle-database-preinstall-19c
yum install -y

Upgrade using DBUA

Create the Oracle home directory for 19c.I am installing Oracle Database 19c on below location.

cd /app
mkdir -p ./oracle19c/product/19.3.0.0/db_1
cd ./oracle19c/product/19.3.0.0/db_1
unzip /home/software/LINUX.X64_193000_db_home.zip

Run the the installer in GUI mode.

./runInstaller

Choose Set Up Software Only option.

Pre-upgrade steps

Check for invalid objects.

select count(*) from dba_objects where status='INVALID';

Run pre-upgrade script.

/app/oracle12c/product/12.2.0.1/db_1/jdk/bin/java -jar /app/oracle19c/product/19.3.0.0/db_1/rdbms/admin/preupgrade.jar FILE DIR /home/oracle/preupgrade

View pre-upgrade logs

cat /home/oracle/preupgrade/preupgrade.log

Run Oracle Generated FIXUP SCRIPT

@/home/oracle/preupgrade/preupgrade_fixups.sql;

























Gather DICTIONARY STATS

SET ECHO ON;
SET SERVEROUTPUT ON;
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;






PURGE DBA_RECYCLEBIN;






Verify archive log dest size and Create Flashback Guaranteed Restore Point.

archive log list

alter system set db_recovery_file_dest_size=30G;
alter system set db_recovery_file_dest= '/app/oracle12c/FRA';

Create Flashback Guaranteed Restore Point

select flashback_on from v$database;
select name,open_mode,log_mode from v$database;
show parameter compatible
show parameter recovery
select * from V$restore_point;
create restore point pre_upgrade guarantee flashback database;





col name for a20
col GUARANTEE_FLASHBACK_DATABASE for a10
col TIME for a60
set lines 190
select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;

Run the DBUA

cd /app/oracle19c/product/19.3.0.0/db_1/bin/
./dbua
Labels:

Comments

Post a Comment

Popular posts from this blog

Installing Docker Desktop for Windows

Installing Docker Desktop for Windows What is Docker? Docker is a set of platform as a service products that use OS-level virtualization to deliver software in packages called containers. Docker is an open source platform that enables developers to build, deploy, run, update and manage containers—standardized, executable components that combine application source code with the operating system (OS) libraries and dependencies required to run that code in any environment. Download Docker for Windows Installer from here Install Docker Desktop on Windows Install interactively: Double-click Docker Desktop Installer.exe to run the installer. Follow the instructions on the installation wizard to authorize the installer and proceed with the install When the installation is successful, click Close to complete the installation process. ...
Post a Comment
Read more

Install Oracle Database 19c software in silent mode on Linux

Install Oracle 19c database software Install Oracle Database 19c software in silent mode on Linux This article provide the overview of installing the Oracle Database software in silent mode on Linux operating system. Usually to install database software ./runInstaller Graphical User Interface(GUI) installation is performed. Let's assume you are in customer site and you don't have access to GUI of server machine. So in such case, silent or script installation allows you to configure necessary components without using GUI. Response file can be used to provide all the required information for the installation,so no any additional user input is required. Table of Contents 1. Hardware Requirements 2. Oracle Installation Prerequisites 3. Download 19c db software 4. Unzip Software 5. Backup Response file 6. Edit Response File 7. Execute Pre-requisites Check 8. Install oracle software in Silent mode 9. Execute root.sh 10. Validation 1. Hardware Require...
Post a Comment
Read more

Building Oracle Database 21c on Docker

Building Oracle Database 21c on Docker Step by step Creating, configuring Database(Oracle21c) on Docker Container Docker is an open source platform that enables developers to build, deploy, run, update and manage containers—standardized, executable components that combine application source code with the operating system (OS) libraries and dependencies required to run that code in any environment. To install docker on windows check this blog This video explain the complete step by step Docker installation.Check it now! Pre-requisite Setup First of all make sure you have installed the docker sucessfully on your environment. The Oracle Database Server Docker Image is required. Get the oracle database docker image from docker offical github Click here for github repository. Extract the downloaded oracle docker image Download the Oracle Database 21c installer(media) files from Oracle official site Copy oralce...
Post a Comment
Read more