Installation of Oracle Database 18c on Oracle Solaris 11 Database installation is one of the basic tasks for every DBA in their learning / professional career. You might have had installed Oracle Database (any version) on Oracle / Red Hat Linux. In this post we’ll see installation of Oracle Database 18c on the first ever Cloud OS (Oracle Solaris 11). If you haven’t installed Oracle Solaris 11 yet, learn how to install here. Before we proceed with the actual installation, […]

Unplug On-Premises Pluggable Database 18cR1 and Plug it in to the Container Database 18cR1 running on Oracle Cloud Here we’ll see one of the easiest way of migrating database from the On-Premises to the Cloud in multi tenancy architecture. We’ll just have to unplug a Pluggable Database from On Premises Container Database, copy the Un-plugged Database to the Cloud using Secure Copy and Plug it in to the Container Database running on the Cloud. 1. Let’s Invoke SQL*Plus on On-Premises server. [[email protected] PDB]$ sqlplus

Unplug On-Premises Pluggable Database 18cR1 and Plug it in to the Container Database 18cR1 running on Oracle CloudRead More »

Creating Database on Oracle Database 18cR1 using DBCA Gui & then Silent. Sounds tricky?, yes it is bit tricky. To create Database in Oracle Database 18cR1, we’ll need to use both dbca utility GUI as well as Silent. However it would not take a long time here. We’ll going to do it very quickly. If you haven’t installed 18c yet you may follow this guide for step by step installation. Let’s Start. 1. Check if your .bash_profile is pointing to

Creating Database on Oracle Database 18cR1 using DBCA Gui and then SilentRead More »

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 »

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

Migrating On-Premises Database 12cR2 to Oracle Cloud Database 18cR1Read More »

Getting started with (DBaaS) Oracle Database 18c on Cloud In past few months Oracle DBaaS, Oracle Cloud, Oracle Database 18c, Cloud Database and many more terms are trending in Database and IT world. Oracle DBaaS is nothing but a Database provided by Oracle as a Service (Database as a Service) in which our complete database with workloads will reside in Oracle’s cloud. And we’ll get Web based Dashboard (UI) to manage our Database Instances, backups, storage and so on. We

Oracle Database 18c on Cloud – A Complete ProcessRead More »