Friday, 19 January 2018

Oracle Cloud : Database as a Service (DBaaS) - Create Service

This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

◉ Create SSH Key

Before you start, you are going to need a key pair for authentication to your service.

$ ssh-keygen -b 2048 -t rsa -f myOracleCloudKey
$ chmod 600 myOracleCloudKey*

Wednesday, 17 January 2018

Multitenant : Proxy PDB in Oracle Database 12c Release 2 (12.2)

  • Introduction

A proxy PDB can provide a local connection point that references a remote PDB. There are a few situations where this might be of interest to you.

1. You want to relocate a PDB to a different machine or data centre, without having to change any of the existing connection details. In this case you can relocate the PDB and create a proxy PDB of the same name in the original location.

Monday, 15 January 2018

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 6 Using VirtualBox Part-2

◉ Install the Grid Infrastructure

Make sure both virtual machines are started. Install the following package from the Oracle grid media as the root user.

# cd /media/sf_12.1.0.2/grid/rpm
# rpm -Uvh cvuqdisk*

Login to "ol6-121-rac1" as the "oracle" user and start the Oracle installer.

Friday, 12 January 2018

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 6 Using VirtualBox Part-1

This article describes the installation of Oracle Database 12c release 1 (12.1 64-bit) RAC on Linux (Oracle Linux 6.5 64-bit) using VirtualBox (4.3.16) with no additional shared disk devices.

  • Introduction

One of the biggest obstacles preventing people from setting up test RAC environments is the requirement for shared storage. In a production environment, shared storage is often provided by a SAN or high-end NAS device, but both of these options are very expensive when all you want to do is get some experience installing and using RAC. A cheaper alternative is to use a FireWire disk enclosure to allow two machines to access the same disk(s), but that still costs money and requires two servers. A third option is to use virtualization to fake the shared storage.