The Flash Insider: To POC or Not To POC?

Proof of Concept?

Guest Post

I’m excited announce another guest blog written by my good friend and funny-talking American cousin Nathan Fuzi. Like me, Nate comes from a database background but joined the all-flash storage revolution back in its infancy. Which means, like me, Nate how has a little tombstone on his résumé marked Violin Memory. But even though he has since moved up to working in THE CLOUD, Nate’s experience working for an AFA vendor is invaluable. Over six years, he worked (more...)

#Oracle cutting in inspiration and new business?

Over the many years Oracle has been leading the database world, I guess they are now taking something of a wrong turn.
Let me briefly fill you in on my thoughts.

Basically I see two “minor” shifts that are significantly indicative of this:

  1. Oracle Standard Edition 2
  2. Oracle ACE Program

Okay, so you might think I am crazy, but let me try to explain.

Oracle Standard Edition 2

Sometime last year, the long expected, (more...)

Creating a RAC cluster using Ansible (part 2)

In my previous 2 blogposts i explained how to setup a Vagrantfile that deploys 2 virtualbox machines that can be used as a basis for a RAC cluster and how you could use Ansible to deploy RAC on those VM’s. In this post i want to dive a bit deeper into how i setup Ansible and why, keep in mind that this just one way of doing this.

The Github repository containing all the files (more...)

#DOAG2016, definitely a crazy week.

#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!

In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)

Associating Oracle Database 12c Databases with Compliance Standards

In my last post, I walked you through the first part of installing the Oracle Database 12c STIG compliance standards sample code. The next step to using these compliance standards is to associate your Oracle Database 12c databases with these standards. You may recall there are two separate standards in the sample code, one for multitenant databases and the other for conventional architecture databases. The process of associating the databases is the same in (more...)

OTN Appreciation Day: PL/SQL

We are posting these blog posts today as part of the OTN Appreciation Day, a celebration for the Oracle Technology Network as suggested by Tim Hall, inspired by Debra Lilley.

The mission was not too hard: write about your favorite bit of Oracle Technology.

As a developer and a core-tech DBA and APEX enthusiast… the choice was easy! PL/SQL (apart from how it is pronounced or even written ;-)!

Why? Easy!

Not just because (more...)

Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others

For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.

For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)

clckwrk Design Blueprint: Peoplesoft Campus Solutions on AWS

Higher eduction establishments around the world use Peoplesoft Campus Solutions from Oracle to manage their key business processes. 

In this reference architecture we look at the key requirements for Campus Solutions and the technical solutions that can be deployed on the Amazon Web Services Cloud. 




Availability: Campus solutions needs a high availability infrastructure to ensure that both the administrative and student users can access data at all times. This solution uses multiple web and (more...)

clckwrk Quick Guide: Run your DR solution for the cost of a backup – ERP in the AWS Cloud

In this blog we're looking at a cost effective method for disaster recovery in the AWS cloud. The key here is that the cloud gives you on-demand infrastructure so there is no need to have any servers, storage or networking kit patiently waiting for the DR button to be pushed, instead you can hold just the definition of the technology and a recent backup of your data and build the necessary infrastructure just when it is needed. 

(more...)

Slashing the costs of your databases … choosing your PaaS or Next Gen Database Platform

Do you want to lower the costs of your database estate? Are you trying to stay inside the license purchases you’ve made? Maybe looking to simplify the admin across servers, storage, networks and DBA?

It’s a question we get asked over and over in a world where there are great advantages in adopting the next generation of Platform as a Service (PaaS) and Next Generation database platforms. Seeing AWS park its tanks on Oracles lawn (more...)

clckwrk Quick Guide: Backing up Oracle databases on AWS using snapshots

Did you take a backup first? Of course you did.

In this post we look at one way to simply back up your Oracle database in the AWS cloud. We're planning on making this the first in a series of Quick Guides for working with Oracle and public cloud. We hope you like it, please follow, comment or like if we're hitting the spot!


This example uses a self managed database, rather than RDS, so (more...)

Protecting your data in Oracle – now you see it, now you don’t!

In this article Peter Berry from clckwrk shows how smart use of Oracle and AWS functionality can secure sensitive data in production and and automatically obfuscate when that data leaves the server.

Data security is a key concern for all businesses. Ensuring your data is secure in your production system and that data leakage is controlled is typically addressed by encryption and obfuscation respectively. Encryption can be difficult to deploy and costly while obfuscation can (more...)

New Installation Cookbook: Oracle Linux 6.7 with Oracle 11.2.0.4 RAC

cookbookI’ve updated my install cookbooks page to include a new cookbook for installation of Oracle 11.2.0.4 Real Application Clusters on Oracle Linux 6.7.

This is also the first one I’ve published since I left the employment of Violin Memory to work for Kaminario, so this install uses a Kaminario K2 All Flash Array. However, it applies very well to any Oracle RAC installation which uses relatively capable storage.

Enjoy:

https://flashdba.com/install-cookbooks/oracle-linux-6-7-with-oracle-11-2-0-4-rac/


Filed (more...)

When should you use Oracle RAC?

Over the past years we've worked on many Oracle projects, some with RAC, some without, some which intended to implement RAC and failed, and some which implemented poorly and ripped it out at the last minute. 

For those new to Oracle, RAC is the Real Application Cluster option for the database which lets you cluster the database servers. The main reason for using for RAC is that it brings resilience to a system, it (more...)

What DBAs need to know about Amazon RDS

We’re looking at many customers who are considering moving from on-premise  databases to cloud hosted  instances running Oracle. This is a pretty well trodden path in cloud terms and also in Oracle terms - you go through the same process with Oracle as you would have if you moved from one piece of hardware to another in the past - it’s a platform migration and sometimes you’ll upgrade the database as you go. After that (more...)

Configuring VNCR for 11.2.0.4 Oracle RAC

By default on an Oracle RAC installation, the listeners are configured to allow any database to register with them.  There is no security out of the box to determine which databases may register.  While this makes it easy to create new databases without worrying about listener registration, this can cause potential problems in a real environment.

This can be dangerous working with RAC environments where the database registers with both a local and remote listener.  The (more...)

Oracle Apex 5.0 and APEX_JSON

How many lines of code does it take to make a web service call? Answer: 39

That is how many lines of PL/SQL I had to write in Oracle Apex 5.0 to make a web service call to an external API.

I used Adzuna's REST API to retrieve the latitude and longitude and the price of 2 bed properties for rent in a specific location in UK. The API returns JSON which the APEX_JSON (more...)

Restoring a Database to a New Diskgroup

I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me.  As DBAs, we back up databases all the time, but the restores are performed much less frequently.  In the case of this rack, there were several databases across multiple ASM diskgroups.  One of the goals of the rebuild was to consolidate all of the databases into a (more...)

Query existing HBase tables with SQL using Apache Phoenix

Spending a bit more time with Apache Phoenix and reading again my previous post I realised that you can use it to query existing HBase tables. That is NOT tables created using Apache Phoenix, but HBase - the columnar NoSQL database in Hadoop.

I think this is cool as it gives you the ability to use SQL on an HBase table.

To test this, let's say you login to HBase and you create an HBase (more...)

HAIP and Exadata

If you’ve run an exachk report, y0u may have seen the following message with regard to your databases:

Status Type Message Status On Details
FAIL Database Check Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value db01:dbm011, db02:dbm012 View

This check is commonly seen when a database is created on Exadata without using the custom “Exadata” templates included with the database creation assistant.  These customized templates include a multitude of recommended parameter settings found in (more...)