Wednesday, 31 January 2018

How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server

In this article, we will discuss how we can use these built in functions to mask the data based on different data patterns, like social security number, credit card number, date of birth, email address, name, etc.

Data Masking Functions


SQL Server provides four built in functions to mask data in SQL tables. These functions are as follows:

Monday, 29 January 2018

Oracle Database 12c Release 1 (12.1.) RAC on Oracle Linux 6 Using NFS

This article describes the installation of Oracle Database 12c Release 2 (12.1 64-bit) RAC on Oracle Linux 6.7 64-bit using NFS to provide the shared storage.

  • Introduction

NFS is an abbreviation of Network File System, a platform independent technology created by Sun Microsystems that allows shared access to files stored on computers via an interface called the Virtual File System (VFS) that runs on top of TCP/IP. Computers that share files are considered NFS servers, while those that access shared files are considered NFS clients. An individual computer can be either an NFS server, a NFS client or both.

Friday, 26 January 2018

Upgrade Oracle Enterprise Manager Cloud Control 12c Release 4 (12cR4) to Release 5 (12cR5)

This article describes a simple upgrade of Enterprise Manager Cloud Control 12c Release 4 (12cR4) to Release 5 (12cR5). Each upgrade potentially requires additional steps, so this is not meant as a replacement for reading the documentation.

Tuesday, 23 January 2018

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

One of the main benefits of DBaaS is it should simplify day-to-day maintenance using automation and tooling. This article provides a run through of patching a DBaaS service on the Oracle Cloud.

1. Navigate to Service


Log into your Oracle Cloud and navigate to the Oracle Database Cloud Service console. Click on the service you want to patch.

Monday, 22 January 2018

Oracle Database 12c Release 1 (12.1) Installation On Fedora 25 (F25)

This article describes the installation of Oracle Database 12c Release 1 (12.1) 64-bit on Fedora 25 (F25) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here.

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).