Tag Archives: database

Warning: Problems with 9.2 clients connecting to databases patched to 11.2.0.4…

I mentioned this a couple of days ago on Twitter, but I’ve only just go round to posting here… I recently had to back out some 11.2.0.4 patches because the patch seems to cause problems with Oracle 9.2 client connections where 11.2.0.3 worked fine. I’m not sure how widespread the problem is. All I can […]

Cloud Control 12c Database Backup Jobs (Continued)

I’ve been rather critical of the way Cloud Control handles database backup jobs, as can be seen in these two previous posts. I love Cloud Control 12c, but the job management is really annoying! Oracle Cloud Control EMCLI : First Thoughts Yesterday I found out I schedule database backups in Cloud Control the “wrong way”… […]

Quick Pluggable Database (PDB) Update…

I’ve been playing around with using SQL Developer and Cloud Control 12cR3 for managing pluggable databases (PDBs) this morning. I’ve added a couple of quick references to my PDB article. Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) If you understand the DBCA and SQL*Plus approach, the […]

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 […]

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. […]

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 […]

How can we make Oracle Database 12cR2 the best release ever?

Oracle will be releasing Oracle Database 12cR1 at some point this year. Many companies will avoid this release, opting to wait for 12cR2, their reasoning being it will be more stable and, as a terminal release, will have a longer support life-cycle. Since 12cR2 is what most businesses care about, what can we do to make […]

Oracle Database on Oracle Linux 6.1…

I mentioned the day before Open World I put a Virtual RAC on Oracle Linux 6.1 article live. Although the procedure was complete, some of the screen shots were from an old article as I didn’t have time to redo them before my flight. I’ve just run through the procedure again and taken new screen […]

Oracle Database 11gR2 on OL6 / RHEL6: Certified or Not?

There seems to be a little confusion out there about the certification status of Oracle Database 11gR2, especially with the release of the 11.2.0.3 patchset which fixes all the issues associated with RAC installs on OL/RHEL 6.1. Currently, 11gR2 is *NOT* certified on OL6 or RHEL6. How do I know? My Oracle Support says so! […]