Friday, 20 July 2018

Big Data Analytics on Current Data

Typical big data applications have a load phase, where a snapshot of data is extracted from operational systems, transformed and cleaned, and then loaded into your big data appliance. Analysts and data scientists can then execute business analytics (BI) queries against the data store in search of patterns and potential marketing opportunities and cost savings. One disadvantage of this architecture is that your appliance becomes more like a large data warehouse, in that it does not contain the most up-to-date data.

Wednesday, 18 July 2018

Oracle Database 12c: Delights the Productivity of the DBA

The architecture of this version is characterized by the concept of containers and database instances that connects and disconnects those containers on the fly, aims to go further than Oracle 11g architecture for consolidation.

Monday, 16 July 2018

Oracle's ASCIISTR() and Unicode Characters

Oracle provides an interesting function, ASCIISTR(), to return ASCII strings from a VARCHAR2 or CLOB column, and in general it does an admirable job. There are non-printing characters however, that 'put a spanner in the works', returning HEX strings instead of characters. Since each HEX string is five bytes long, such strings can significantly increase the overall length of the text so that it won't 'fit' in the allocated buffer space. Let's look at one of those 'annoying' characters, look at its source and provide a possible solution.

Friday, 13 July 2018

Difference between mongoDB and Oracle

Before starting out with the difference between mongoDB and Oracle let us go through about both the databases in brief.

Oracle


Oracle is an object-relational database system that comprises of table-column-row (TCR) structure. The data in oracle database is stored logically in tables. These tables are then logically grouped in tablespaces. Oracle database physically stores data in data files. Tablespaces contain segments. These segments are made of one or more extents. An extent is the collection of contiguous data blocks. Thus data blocks are basic units of data storage in Oracle.

Monday, 9 July 2018

MySQL vs Oracle – The Complete Comparison

Choosing the right database system makes a difference. Some work on specific operating systems, while others don’t. Looking at a comparison between MySQL vs. Oracle will help provide the information necessary to make the right decision.

Friday, 6 July 2018

What Is The Advantages of using Oracle Database?

The following are the advantages of choosing Oracle Database.

Portability


Oracle is ported to more platforms than any of its competition, running on more than 100 hardware platforms and 20 networking protocols. This makes writing an Oracle application fairly safe from changes of direction in hardware and operating system, and therefore a safe bet. One caveat, however, is that applications using some constructs (such as field level triggers) may have to be reworked when porting them to a block mode environment. You can also develop a fairly fully featured application with little knowledge of the underlying OS. Personally, I have developed applications on OS systems barely knowing how to copy and edit text files.

Wednesday, 4 July 2018

Creating a Database Connection with Oracle SQL Developer 4.0

Introduction


Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created.

Monday, 2 July 2018

Difference Between Oracle and SQL Server

Among many Relational Database Management System (RDBMS), the two most popular and widely used are Oracle and SQL Server. There are many fundamental differences between Oracle and SQL Server one of the most important differences between them is the language they use. Oracle uses PL/SQL (Procedure Language SQL), and SQL Server uses T-SQL i.e. Transact-SQL.

Friday, 29 June 2018

Overview of SQL Statements

All operations performed on the information in an Oracle database are run using SQL statements. A SQL statement is a computer program or instruction that consists of identifiers, parameters, variables, names, data types, and SQL reserved words.

A SQL statement must be the equivalent of a complete SQL sentence, such as:

Wednesday, 27 June 2018

JSON Support Enhancements in Oracle Database 18c

Oracle 18c includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on others.

Monday, 25 June 2018

How to Create and Manage Views in Oracle

Views


Views are known as logical tables. They represent the data of one of more tables. A view derives its data from the tables on which it is based. These tables are called base tables. Views can be based on actual tables or another view also.

Friday, 22 June 2018

GDPR for the DBA

The General Data Protection Regulation (GDPR) went into effect worldwide on May 25, 2018. In response, companies throughout the world increased their data security awareness, appointed data protection officers and updated their privacy policies.

Wednesday, 20 June 2018

Handling PL/SQL Errors

In PL/SQL, an error condition is called an exception. Exceptions can be internally defined (by the runtime system) or user defined. Examples of internally defined exceptions include division by zero and out of memory.

Monday, 18 June 2018

PL/SQL Subprograms

Subprograms are named PL/SQL blocks that can be called with a set of parameters. PL/SQL has two types of subprograms, procedures and functions.

Friday, 15 June 2018

Azure SQL Database - Transparent Data Encryption

In one of our recent articles published on this forum, we described the main characteristics of row-level security - a new feature introduced in Azure SQL Database V12 as well as in SQL Server 2016 Community Technology Preview 2. As we pointed out, this was another sign that the trend manifested by a lack of feature parity between these two products, with the cloud service placing distant second behind its well-established on-premises counterpart is consistently declining. In this article, we will review another security-related feature known as Transparent Data Encryption, which also exemplifies this trend, although, unlike row-level security, it made its first appearance long before Azure SQL Database emerged as a potential substitute for a full-fledged SQL Server installation (more specifically, it became available starting with its 2008 version).

Wednesday, 13 June 2018

Azure SQL Database - Row-Level Security

One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings is considerably quicker access to newly developed capabilities, frequently becoming available long before they are incorporated into traditional, full-fledged products. In addition, the trend manifested by lack of feature parity between these two areas, with the cloud apps placing second behind their well-established on-premises counterparts is consistently declining and in some cases even reversing, with the cloud taking over as the dominant force in software development and implementation efforts. This trend is reflected by the number of features introduced recently in Azure SQL Database. We will focus in our article on one of them, known as row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).

Monday, 11 June 2018

PL/SQL Packages

A package is a schema object that groups logically related PL/SQL types, variables, and subprograms. Packages usually have two parts, a specification (spec) and a body; sometimes the body is unnecessary. The specification is the interface to the package. It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package. The body defines the queries for the cursors and the code for the subprograms.

Friday, 8 June 2018

Managing Pluggable Databases in Oracle 12c

Creating and Managing Pluggable Databases using SQL Statements


We can create pluggable databases by either one of the following methods

1. Creating Pluggable Database from Seed database
2. Cloning an Existing Pluggable Database
3. Unplugging and Plugging a database from one CDB to another CDB

Wednesday, 6 June 2018

Difference between SQL vs MySQL

Key difference: A conspicuous difference between SQL and MySQL is that the former is a language used in creating, compiling and maintaining database management systems like MySQL.

Monday, 4 June 2018

SQL Functions in Oracle

SQL functions are built into Oracle and are available for use in various appropriate SQL statements. You can also create your own function using PL/SQL.

Single-Row Functions


Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVING clauses.

Friday, 1 June 2018

Backup and Recovery in Oracle Database

To open the database in Archive log mode. Follow these steps:

STEP 1: Shutdown the database if it is running.

STEP 2: Take a full offline backup.

STEP 3: Set the following parameters in parameter file.

Wednesday, 30 May 2018

PL/SQL Collections and Records

PL/SQL Collections and Records


Collections and records are composite types that have internal components that can be manipulated individually, such as the elements of an array, record, or table.

Monday, 28 May 2018

Column-Level Collation and Case-Insensitive Database in Oracle Database 12c

Collation determines how strings are compared, which has a direct impact on ordering (sorting) and equality tests between strings. Oracle Database 12c Release 2 (12.2) lets you specify the collation used for columns that hold string data, allowing you to easily perform case insensitive queries, as well as control the output order of queried data.

Saturday, 26 May 2018

Adaptive Query Processing in SQL Server

Introduction


Adaptive query processing is the latest, improved query processing feature introduced in the SQL Server database engine. This method is available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database.

Thursday, 24 May 2018

JSON Data Guide Enhancements in Oracle Database 18c

This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.

1. Setup


Create and populate the following table to provide some JSON data to work with. For the data guide functionality to work the table must include the IS JSON check constraint on the column holding the JSON data.

Tuesday, 22 May 2018

Schema Only Accounts in Oracle Database 18c

Schema only accounts don't allow direct connections, so administration of their objects is done via a DBA user or a proxy user.

Friday, 18 May 2018

Introduction to Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Wednesday, 16 May 2018

Learning to be an Oracle Database Administrator (DBA)

In a recent forum discussion I wrote down a rough outline of the approach I think people should take to become a competent DBA. This article represents my thoughts on that matter. Remember, this is only an opinion.

Monday, 14 May 2018

Performing SQL Operations from PL/SQL

Overview of SQL Support in PL/SQL


By extending SQL, PL/SQL offers a unique combination of power and ease of use. You can manipulate Oracle data flexibly and safely because PL/SQL fully supports all SQL data manipulation statements (except EXPLAIN PLAN), transaction control statements, functions, pseudocolumns, and operators. PL/SQL also conforms to the current ANSI/ISO SQL standard.

Saturday, 12 May 2018

SODA for PL/SQL in Oracle Database 18c

The Simple Oracle Document Access (SODA) functionality was introduced with Oracle REST Data Services (ORDS) against Oracle 12.1. Oracle 18c introduced a PL/SQL API for interacting directly with SODA collections and documents. This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

Tuesday, 8 May 2018

Oracle PL/SQL Language Elements

Assignment Statement


An assignment statement sets the current value of a variable, field, parameter, or element. The statement consists of an assignment target followed by the assignment operator and an expression. When the statement is executed, the expression is evaluated and the resulting value is stored in the target.

Friday, 4 May 2018

Oracle DB: Performance and Tuning

Monitoring for performance issues and doing the regular maintenance against the database will keep the database tuned and running faster.

Tuesday, 1 May 2018

Oracle DBA: Oracle Installation

Operating Systems


A 64-bit Linux version of Oracle will not install on a 32-bit Linux or Windows 64-bit system, for example. The Oracle release notes provide information about where to find the compatibility matrix and the system requirements for the server.

Thursday, 26 April 2018

Oracle DBA: Real Application Clusters (RAC)

1. Options for High Availability


Oracle has a Maximum Availability Architecture (MAA), which includes a combination of the options with Data Guard and RAC environments.

Monday, 23 April 2018

PL/SQL Control Structures

PL/SQL Control Structures


Procedural computer programs use the basic control structures.

Saturday, 21 April 2018

Database Backup, Restore, and Recovery

A backup is a copy of data from your database that can be used to reconstruct that data. Backups can be divided into physical backups and logical backups. Physical backups are backups of the physical files used in storing and recovering your database, such as datafiles, control files, and archived redo logs.

Thursday, 19 April 2018

SQL and PL/SQL Database

Structured Query Language (SQL)


SQL is a very simple, yet powerful, database access language. SQL is a non-procedural language; users describe in SQL what they want done, and the SQL language compiler automatically generates a procedure to navigate the database and perform the desired task.

Tuesday, 17 April 2018

PL/SQL Introduction

PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracle engine all at once which increases processing speed and decreases the traffic.

Saturday, 14 April 2018

What is SQL Developer?

Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack.

Wednesday, 11 April 2018

Introduction to Oracle SQL

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. This chapter provides background information on SQL as used by most database systems.

Tuesday, 10 April 2018

Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES)

Invoker rights procedures and functions can present a security risk by allowing privilege escalation if the contents of the procedure and functions are not checked for malicious code.

◈ The Problem


The following represents a scenario where a sneaky developer takes advantage of invoker rights to escalate their privileges.

Saturday, 7 April 2018

What is a NoSQL (Not Only SQL) Database?

A NoSQL database environment is, simply put, a non-relational and largely distributed database system that enables rapid, ad-hoc organization and analysis of extremely high-volume, disparate data types. NoSQL databases are sometimes referred to as cloud databases, non-relational databases, Big Data databases and a myriad of other terms and were developed in response to the sheer volume of data being generated, stored and analyzed by modern users (user-generated data) and their applications (machine-generated data).

Wednesday, 4 April 2018

Approximate Top-N Query Processing (APPROX_RANK, APPROX_SUM, APPROX_COUNT) In Oracle Database 18c

The APPROX_RANK, APPROX_SUM and APPROX_COUNT functions were introduced in Oracle 18c to allow approximate top-n query processing. This extends the approximate query processing that was introduced in the previous two releases (12cR1 and 12cR2).

Tuesday, 3 April 2018

Getting started with Oracle Database In-Memory Part III - Querying The IM Column Store

In my previous blog posts, I described how to install, enable, and populate the In-Memory column store (IM column store). This weeks post focuses on how data is accessed within the IM column store.

Let’s take a simple query “What is the most expensive air-mail order we have received to date?”

SELECT Max(lo_ordtotalprice) most_expensive_order

Saturday, 31 March 2018

Getting started with Oracle Database In-Memory Part II - In-Memory Population

In part two of this series on getting started with Oracle Database In-Memory I’ll explain how and when objects are populated into the In-Memory column store (IM column store) and exactly how you can control it.

Which objects are populated into the IM column store?


As I mentioned last week, only objects with the INMEMORY attribute are populated into the IM column store. The INMEMORY attribute can be specified on a tablespace, table, (sub)partition, or materialized view. In this example the INMEMORY attribute is specified on the customers.

Thursday, 29 March 2018

Getting started with Oracle Database In-Memory Part I - Installing & Enabling

Now that Oracle Database 12.1.0.2 has been officially released, I can finally start sharing more technical details on how Oracle Database In-Memory (Database In-Memory) works.

I thought we should start this series of posts right at the very beginning by answering the most fundamental question, how and when is Database In-Memory installed and enabled.

Let’s start by doing a clean install of 12.1.0.2 and allowing the installer to create a typical single instance database.

Monday, 26 March 2018

Monitor Query Performance Using Query Store in SQL Server

Introduction


There are various methods to monitor query performance in SQL Server. One of the best ways is to analyze the query execution plan and identify the queries that can cause performance bottlenecks. Sometimes, query execution plans get changed during the query execution due to certain factors of SQL Server. Then there is a need to understand this behavior, so you can review the query execution plans to identify the change and understand the overall performance. This can be done only if your system is persisting the required information for later analysis. The Query Store feature in SQL Server 2016, SQL Server 2017 and Azure SQL Database version provides the capability to store query execution plan information and gives you the opportunity to analyze it.

Saturday, 24 March 2018

Inline External Tables in Oracle Database 18c

Oracle Database 18c allows you to access data in flat files using an inline external table defined in a SELECT statement.

Oracle Database 18c, Oracle Database Certifications, Oracle Database Tutorials and Materials

Thursday, 22 March 2018

Private Temporary Tables in Oracle Database 18c

Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup.

If you've come to Oracle from a different database engine, like SQL Server, you might be confused by Oracle's idea of temporary tables. In SQL Server developers will regularly create a temporary table to do some work and drop it. In Oracle a Global Temporary Table (GTT) is a permanent metadata object that holds rows in temporary segments on a transaction-specfic or session-specific basis. It is not considered normal to create and drop GTTs on the fly. With the introduction of private temporary tables, Oracle has an option similar to that seen in other engines, where the table object itself is temporary, not just the data.

Tuesday, 20 March 2018

Qualified Expressions in PL/SQL in Oracle Database 18c

Qualified expressions provide and alternative way to define the value of complex objects, which in some cases can make the code look neater.

◈ Syntax


The basic syntax for a qualified expression is as follows

Saturday, 17 March 2018

Data Pump (expdp, impdp) Enhancements in Oracle Database 12c Release 2 (12.2)

This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 2 (12.2).

Some of these features are not listed in the expdp -help or impdp -help usage text.

1. Parallel Export/Import of Metadata


In previous releases the PARALLEL parameter was only relevant to the export/import of data, with all metadata processed serially. In Oracle 12.2 both metadata and data can be exported in parallel provided it is not a transportable tablespace operation.

Thursday, 15 March 2018

External Tables and XMLTAG to Load XML Documents in Oracle Database 12c Release 2 (12.2)

This article describes how to use the XMLTAG clause of an external table to load XML fragments from XML documents in Oracle Database 12c Release 2 (12.2).

Tuesday, 13 March 2018

Partitioned External Tables in Oracle Database 12c Realease 2 (12.2)

Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins. With the exception of hash partitioning, many partitioning and subpartitioning strategies are supported with some restrictions.

Saturday, 10 March 2018

Efficient Function Calls From SQL

This article presents a number of solutions for making calls to PL/SQL functions from SQL more efficient.

◈ The Problem


Sometimes we require functions in the select list of a query. These may be built in functions, or functions we've coded ourselves. The default action is to call the function for each row returned by the query. If the function is deterministic, for the same input parameter signature it gives the same output, and the number of unique parameter signatures used is low compared to the number of rows processed, this can represent a lot of wasted effort.

Thursday, 8 March 2018

How to Send a TDE Encrypted Backup to Someone Outside Your Organization

Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted.  If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization?

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:

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.

Saturday, 27 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.

Wednesday, 24 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.

Tuesday, 23 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.

Saturday, 20 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*

Thursday, 18 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.

Tuesday, 16 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.

Saturday, 13 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.

Thursday, 11 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.

Tuesday, 9 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.

Saturday, 6 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).