Wednesday, 28 February 2018

UTL_CALL_STACK : Get Detailed Information About the Currently Running Subprogram in Oracle Database 12c Release 1

Oracle database 12c introduced the UTL_CALL_STACK package to allow programmatic access to the call stack and error stack, giving much greater flexibility for debugging and error handling of PL/SQL code. This is only a replacement for the existing functionality if you need the extra level of control. The existing functionality in the DBMS_UTILITY package is still available and has not been deprecated.

Tuesday, 27 February 2018

Database Triggers Overview

The CREATE TRIGGER statement has a lot of permutations, but the vast majority of the questions I'm asked relate to basic DML triggers. Of those, the majority are related to people misunderstanding the order of the timing points and how they are affected by bulk-bind operations and exceptions. This article represents the bare minimum you should understand about triggers before you consider writing one.

Friday, 23 February 2018

Data Encryption Using Always Encrypted in SQL Server

Introduction


Data security is always a matter of concern for organizations and application users. The key challenge for any developer or architect is to understand all the concerns and build a foolproof system to ensure data security.  This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. There’s a lot of room for small and mid-size organizations to take maximum advantage in this time of technology transformation. All of these small and mid-size organizations want to explore the benefits of the cloud. However, the biggest threat, Data Security, needs to be dealt with. Questions to be answered are:

Wednesday, 21 February 2018

Upgrade Oracle Enterprise Manager Cloud Control 13c Release 1 (13cR1) to 13c Release 2 (13cR2)

This article describes a simple upgrade of Enterprise Manager Cloud Control 13c Release 1 (13cR1) to 13c Release 2 (13cR2). Each upgrade potentially requires additional steps, so this is not meant as a replacement for reading the documentation.

Monday, 19 February 2018

Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) Installation on Oracle Linux 6 and 7

This article describes the installation of Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) on Oracle Linux 6 and 7. (x86_64).

◈ Software


Download the following software:

Saturday, 17 February 2018

Upgrade Oracle Enterprise Manager Cloud Control 12c Release 5 (12cR5) to 13c Release 1 (13cR1)

This article describes a simple upgrade of Enterprise Manager Cloud Control 12c Release 5 (12cR5) to 13c Release 1 (13cR1).

◈ Software


Download the following software:

Wednesday, 14 February 2018

Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7

This article describes the installation of Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) on Oracle Linux 6 and 7. (x86_64).

◈ Software


Download the following software:

Tuesday, 13 February 2018

Oracle HTTP Server (OHS) 12cR2 (12.2.1) Installation on Oracle Linux 6 and 7

This articles demonstrates how to perform an installation of Oracle HTTP Server (OHS) 12c on Oracle Linux.

◉ Software


Download the WebLogic Server and Java SE software. The examples in this article use the following.

Saturday, 10 February 2018

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

This article presents a brief overview of installing Oracle WebLogic Server (WLS) 12cR1 (12.1.1) 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.

Thursday, 8 February 2018

Static Registration and the Oracle 12.2 Listener

In earlier versions of the Listener, Oracle has been more forgiving with static registrations; with 12.2 that seems to have changed as static registrations, if not configured completely, can cause the listener to dump a core file in the directory where the listener process was started. What can make this even more confusing is that dynamic registrations are not affected. And to add to all of this, having databases down when starting the listener doesn't 'fix' the problem because the listener isn't connecting to a running database, it's trying to resolve library paths for static declarations. Let's look at how static registrations can be written to avoid this.

Friday, 2 February 2018

Oracle Database 12c Release 1 (12.1) Installation On Fedora 24 (F24)

This article describes the installation of Oracle Database 12c Release 1 (12.1) 64-bit on Fedora 24 (F24) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive.

1. Download Software


Download the Oracle software from OTN or MOS depending on your support status.

Thursday, 1 February 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: