Migrating Oracle Database 12cR2 from On-Premises to Oracle Database 18cR1 on Oracle Cloud As we’ve already done creating Oracle Database 18cR1 on Oracle Cloud in our previous post, now we’ll be migrating our On-Premises Database to our newly created Cloud Database from version 12cR2 to 18cR1. There’re several methods of migrating On-Premises Database to Cloud Database, This is one of them in which we’ll be using expdp/impdp. So this will go like, 1.  Export On-Premises Database (DEMTEST) using expdp utility. Before […]

Creating test Database with name DEMTEST manually on Oracle Database 12cR2 with Automatic Storage Management (ASM). You can create your database using GUI utility of Oracle called DBCA as well by pretty easy Next – Next wizard, However approach of creating database manually is industrial practice and the reason is that you have more control over your choices. Here we’re creating database manually but with very minimal parameters in create database script. you’ll have lots of options to fully customize your Database

Manually Database Creation on Oracle Database 12cR2 with ASMRead More »

Installation of Oracle Database 12cR2 and Oracle Grid Infrastructure 12cR2 on Oracle Enterprise Linux 6.7 (Physical Server – Not a VM). Every DBA Trainee or a Jr DBA must need to perform installation of Oracle Database on their home / test machines for practicing their DBA activities. However installation of Oracle Database is not a rocket science and pretty easy. You will find many blogs across the internet for step by step installation guide in which the demonstration will be

Oracle Database 12cR2 with ASM on Oracle Linux 6.7Read More »