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.

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.

Monday, 8 January 2018

Oracle WebLogic Server (WLS) 12cR1 (12.1.3) Installation on Oracle Linux 5 and 6

This article presents a brief overview of installing Oracle WebLogic Server (WLS) 12cR1 (12.1.3) on Oracle Linux 5 and 6.

1. Assumptions


This article assumes you have an existing server (real or virtual) with either Oracle Linux 5.x or 6.x installed on it. For instruction on how to do this check out the following articles.

Friday, 5 January 2018

Oracle WebLogic Server (WLS) 12cR1 (12.1.2) Installation on Oracle Linux 5 and 6

This article presents a brief overview of installing Oracle WebLogic Server (WLS) 12cR1 (12.1.2) on Oracle Linux 5 and 6.

◈ Assumptions


This article assumes you have an existing server (real or virtual) with either Oracle Linux 5.x or 6.x installed on it. For instruction on how to do this check out the following articles.

Wednesday, 3 January 2018

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : ADF Application Development Runtime - Repository Configuration Utility (RCU)

◉ Assumptions


1. You have a database with the AL32UTF8 character set.
2. You have a WebLogic 12c (12.1.2 or 12.1.3) installation.
3. You have installed the ADF Application Development Runtime on top of the WebLogic 12c (12.1.2 or 12.1.3) installation.

Monday, 1 January 2018

WebLogic Server 11g and 12cR1 (12.1.1) : Clustered Domains

This article describes how to create a two-node clustered domain using Oracle WebLogic 11g and 12cR1 (12.1.1). The examples all relate to WebLogic 11g installations, but the process is exactly the same on WebLogic 12cR1 (12.1.1).