Posts

Using DML with ADRCI

Image
The Oracle Database has some useful debugging and diagnostics features. One such utility called the Automatic Diagnostics Repository Command Interpreter or ADRCI, enables database and system administrators to view and analyze information including trace and log files.

In addition to the usual ADR commands, you can also issue DML-like statements. These statements are limited to the diagnostics information found in the ADR. Let's take a look at how to use ADRCI to issue DML.

Please note: DML statement issued via ADRCI don't require a termination character such as the semicolon. Also, the statements have to be on a single line.

The following DML commands are defined in ADRCI version 12.1.0.2.0
SELECT
UPDATE*
DELETE*
INSERT*
UPDATE*
QUERY*

To get a list of the commands, use the help keyword in ADRCI.



You may notice that only the SELECT statement is shown by default. To see the list of additional commands, type help extended.

Note: Commands proceeded by an asterisk are restricted for Ora…

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site. Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account
Subscription to Oracle IaaS Service

First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances.
Note: Oracle uses the term "shape" to refer to the re…

How to Get More Time to Play Golf or Faster Data Delivery with Delphix

Image
The Delphix Data Virtualization Engine allows DBAs to spend less time cloning and refreshing databases and focus on other import tasks - like golf or your favorite activity. In full disclosure, I tried golf once and was 'turrible' at it. In all seriousness, having the ability to spin up a virtual database (VDB) in a matter of minutes shaves hours or days off of manual, mundane and error prone work. This makes customers (developers, analysts) happy too. Not only can you quickly and easily create full read/write copies of their production data, they also get the time machine-like ability to go backwards and forwards with their data, which opens up a world of possibilities.

As a database administrator, I've spent way too many hours creating clones of databases for development, test and reporting purposes. Cloning or duplicating multi-terabyte databases can take a very long time. Oracle databases, in particular, can become complex depending on how the clone is being performed…

IOUG Collaborate 2017 Sessions

IOUG Collaborate 2017 will be held from April 2 - 6 2017 in Las Vegas Nevada. This will be my fifth year speaking at Collaborate, and I will have two separate sessions about data virtualization. One will be a pre-conference Hands-On lab with Kellyn Pot'Vin-Gorman, and the other will be talking about Cloud migration.  I will also be doing booth duty for Delphix. If you are around please stop by and say hello. See session details below.

April 2, 2017 9:00 AM – 1:00 PM – South Seas C Data Virtualization Hands-On Lab (pre-registration required) Presenters: Kellyn Pot’Vin-Gorman and Leighton Nelson
April 3, 2017 8:30 AM – 9:30 AM – Palm A Migration Enterprise Applications to the Cloud Presenter: Leighton Nelson
For more Data Virtualization related activities see Kellyn's blog post here.

Databases and Storage - The New Frontier

Image
Databases Storage – The New Frontier
As database and storage administrators and engineers, it is important to understand the effect that storage has on database performance.

It is important to understand that databases are an extension of your storage and requires a holistic view when designing and managing solutions that use the database.

This article gives an overview of the Oracle database storage landscape – past, present and future. It’s not meant as an in-depth technical treatment of the topic but opens the door for more discussion and engagement about database storage.
Evolution Both storage and databases continue to evolve (albeit at different paces). About a decade ago the enterprise storage of choice was the Storage Area Network or SAN array. At about the same time the current release of Oracle was 10gR1, which introduced Automatic Storage Management (ASM), which provided mirroring and striping capabilities for data files. Database sizes were typically in the hundreds of gi…

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments.

Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments.

The procedure for cloning an Oracle home in…

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum

[root@matthew ~]# yum install xfsprogs
Loaded plugins: refresh-packagekit
Setting up Install Process
public_ol6_UEKR3_latest | 1.2 kB 00:00
public_ol6_UEK_latest | 1.2 kB 00:00
public_ol6_UEK_latest/primary | 19 MB 00:02
public_ol6_UEK_latest 407/407
public_ol6_addons | 1.2 kB 00:00
public_ol6_addons/primary | 77 kB 00:00
public_ol6_addons 269/269
public_ol6_latest | 1.4 kB 00:00
public_ol6_latest/primary | 46 MB 00:05
public_ol6_latest 29302/29302
http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
Trying other mirror.
Resolving Dependencies
--> Running transaction check
---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================================================