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.

Wednesday, 10 January 2018

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups.  If you don’t change the default location for your installation your default backups location will be “C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup”  (default location for a SQL Server 2016 installation).   Overtime you might decide you want to change the default location for database backups.   Below I provide you two different ways to change the default location for your database backups.