Just a point-and-click guide to Data Guard setup using Grid Control.
Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control
Cheers
Tim…
My previous article discussed the DBFS. This article gives an overview of the PL/SQL APIs for managing and interacting with the DBFS.
Oracle Database File System (DBFS) PL/SQL APIs
There’s a lot in there, so this is just skimming the surface.
Cheers
Tim…
I’ve been having a play with the DBFS functionality in 11gR2.
Oracle Database File System (DBFS) in Oracle Database 11g Release 2
For the most part it is extremely simple. If you are working on Linux then it’s a really neat solution. On any other platform you are limited to using the dbfs_client tool, which is currently [...]
I finally got round to trying an NFS installation of 11gR2 RAC.
Oracle Database 11g Release 2 RAC On Linux Using NFS
No real surprises here. It all seems a little simpler when using NFS, but it was cronically slow on my crappy kit.
Cheers
Tim…
A couple of articles crept out of the last couple of days.
First a revamp of an old article about XML over HTTP to bring it in line with some of the stuff I’ve been presenting recently.
XML-Over-HTTP (REST Web Services) From PL/SQL
Next, something new that caught my eye to do with auditing in 11gR2.
Auditing Enhancements (DBMS_AUDIT_MGMT) [...]
There are some nice new features in the scheduler in 11gR2. I’ve written about them here:
Scheduler Enhancements in Oracle Database 11g Release 2
Remote Scheduler Agent Installation for Oracle 11g Release 2
Remember, there was already a bunch of new stuff added in llgR1, so there’s a lot of whiz-bang stuff if you are moving from 10g.
Scheduler [...]
I’ve taken my first tentative steps into 11gR2 RAC and it was a big surprise.
Oracle 11g Release 2 RAC On Linux Using VMware Server 2
11gR2 RAC feels very different to 11gR1 RAC. I can imagine quite a few people wanting to upgrade from 11gR1 thinking it will be trivial and getting a rude awakening…
The Grid [...]
I’ve been running through my demos before my PL/SQL workshop in Utrecht and I noticed a change in the behaviour of the PL/SQL Function Result Cache. In 11gR1 it was necessary to specify dependencies using the RELIES ON clause, but now Oracle 11gR2 takes care of Detection of Sources for you. Neat.
Cheers
Tim…
I’ve had my first play with 11gR2 today:
Oracle Database 11g Release 2 (11.2) Installation On Enterprise Linux 5.0
Nothing too unpredictable really.
I guess the most noticeable change is the new installer. I didn’t have an issue with the old installer, but a few friends from the Microsoft world had pointed out how dated it looked. The [...]
A certain something has been released today, so like any self respecting DBA/Developer I went straight for the manuals…
At the time of writing there are none listed on OTN or Tahiti. I tried cunningly altering existing URLs to match the new version, but to no avail.
I’m sure they will appear soon.
Cheers
Tim…
Update: Thank you [...]