Migrating Oracle Database 12cR1 from File System to ASM using RMAN. There are many ways which can be used to migrate Oracle Database from File System to ASM. ‘RMAN backup as copy’ is one of the methods of migrating database from File System to ASM. In this demonstration Oracle RDBMS version is 12.1.0.2 and Grid Infrastructure is also 12.1.0.2. Here I’m assuming you already have up and running ASM instance with +DATA and +FRA ASM diskgroups. If you haven’t created […]

Installation of Oracle Database 18cR1 & Oracle Grid Infrastructure 18cR1 on Oracle Linux 6.7(Not an Exadata). I’ve already covered a topic on 18c in my previous post which is on Upgrading Grid Infrastructure from 12cR2 to 18cR1. And the complete step-by-step guide on how you can download Oracle Grid Infrastructure 18c on your On-Premises system, though it is only available for Exadata machines. So from the same post you can get insight on how to download Oracle Database 18c on Non-Exadata

Installation of Oracle Database 18cR1 & Oracle Grid Infrastructure 18cR1 on Oracle Linux 6.7 (without GUI)Read More »

Upgrading Oracle Grid Infrastructure 12cR2 to Oracle Grid Infrastructure 18cR1 – With Little Hack (Including how you can get it). Though 18c is not yet officially available for On-Premises except for Exadata, we will going to do it with little hack, and let’s see if it works. 1. Download Oracle Grid Infrastructure 18c setup from Oracle e-Delivery. Visit Oracle Software Delivery Cloud and click on Sign In. Enter your credentials and Sign In or Create an Account if you don’t have

Upgrading Oracle Grid Infrastructure 12cR2 to Oracle Grid Infrastructure 18cR1 – With Little Hack (Including how you can get it).Read More »

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 »