Oracle to PostgreSQL using Ora2PG

In this article, we are going to talk about using ora2pg to migrate the database from Oracle to PostgreSQL. We are going to consider PostgreSQL in Azure VM, PostgreSQL and Azure Database for PostgreSQL as target from Oracle. Source Oracle version is 11g XE.

The website https://ora2pg.darold.net/documentation.html talks about manual installation of ora2pg which is complex, there is an easy way to install in on Linux & Windows all you have to do is download the respective scripts for Linux or Windows and run it as root or administrator.

https://github.com/microsoft/DataMigrationTeam/tree/master/IP%20and%20Scripts/PostgreSQL%20Migration%20and%20Assessment%20Tools

Once the installation is done, the very first step would be to assess your Oracle and create a report

 

Drop Database in Oracle

Steps to drop a container database in oracle

Step 1 : Connect to the database as sysdba

bash#$ sqlplus / as sysdba

Step 2 : Shutdown the database

SQL> shutdown immediate;

Step 3 : Start mount the database with exclusive restrict to avoid the database being opened

SQL> startup mount exclusive restrict;

Step 4 : Drop database

SQL> drop database;