Tag Archives: 12c

Oracle Database File System (DBFS) Enhancements in Oracle 12c

Oracle 12c includes a really neat feature I first mentioned after Oracle OpenWorld 2012. You can now access your DBFS file systems over HTTP/HTTPS, FTP or WebDAV. I’ve been having a play with it over the last couple of days, so I thought I would write it up here. Oracle Database File System (DBFS) Enhancements [...]




Upgrading to Oracle Database 12c : First Steps…

I’ve taken my first tentative steps into upgrading to Oracle 12c. Upgrading to Oracle Database 12c This article is targeted at the type of information you are likely to need for the 12c OCP DBA exam. In reality, upgrades are too important to rely on a generic article like this. Every time I do a [...]




Oracle 12cR1 RAC Installation on Windows 2012 Using VirtualBox…

After having a play with Oracle 12c on Windows 8, I decided to give Windows Server 2012 a go. Here is the resulting virtual RAC installation. Oracle Database 12c Release 1 RAC On Windows 2012 Using VirtualBox As you would expect, much of the process is pretty similar to the 11gR2 RAC installation on Windows [...]




Implicit Statement Results and Extended Data Types in Oracle 12c…

Over the last couple of days I’ve put another couple of articles live. In this case they are both focused on easing migration from non-Oracle databases to Oracle. Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT) Extended Data Types in Oracle Database 12c Release 1 (12.1) It’s a little hard [...]




Windows Blue (8.1) and Oracle Database 12c

Inspired by this article, I decided to download Windows Blue 8.1 and install it on VirtualBox. Once Classic Shell was installed it looked almost usable. The Windows version of Oracle 12c is now available, so that seemed like the obvious thing to try next. That went really smoothly. I’m bored with Windows now, so I’m off back to Linux. [...]




Oracle Database 12c : Reality Check for Readers…

I shouldn’t really need to write this post, but recent events seem to indicate it is necessary… Oracle Database 12c is new! The people out there writing articles can be broken down into three basic groups: Those people who have been using the beta product for over a year and really pushing it hard. Those [...]




Oracle Cloud Control 12c Release 3 Installation (EM12cR3)…

With all the excitement about Oracle Database 12c being released, you may have missed the release of Cloud Control 12c Release 3. It’s available for download from OTN. All the usual ports are available. This is the version you are going to need if you want to monitor 12c databases in your organisation. I did [...]




Top-N Queries and the Multithreaded Model in Oracle 12c…

A couple of new 12c articles have rolled off the press. Both of them small, but interesting to me. Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1) Multithreaded Model using THREADED_EXECUTION in Oracle Database 12c Release 1 (12.1) These resulted in amendments to a couple of old articles. Top-N Queries [...]




WITH Clause Enhancements in Oracle 12c…

After doing a number of 12c installations, I decided it was time to write something new. I figured I’d pick something easy to start off with, so here is the first thing off the press. WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) Over the last year I’ve heard a few speakers talk [...]




Oracle Database 12c Virtual RAC Installation on Oracle Linux 6

I finally got my server problems sorted out yesterday, so I was able to do a 12c virtual RAC installation. You can see what I did here: Oracle Database 12c Release 1 (12.1.0.1) RAC On Oracle Linux 6 Using VirtualBox The setup is pretty much the same as the 11gR2 setup. So there’s no real [...]