A short guide to networking in Virtual Box with Oracle Linux inside.
This post is intended to be a dummy guide, best practices, or whatever you call it… about setting up a network while working with virtual boxes on a desk- …
Category: Oracle 12
Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes
December 30, 2013
AMIS, Architecture, Database, DBA Oracle, Oracle, Oracle 12, Virtualization and Oracle VM
No Comments
To build an Oracle 12C RAC database – on Virtual Boxes – there’s at least shared storage needed for ASM, and a DNS-server for the SCAN-addresses. Several methods can …
Where is my wallet – loosing the encryption master key in 11g db, compatibility in 12c
A while ago I configured an encrypted column in a table for a customer in database 11g. To achieve this, a wallet had to be created outside the database. …
The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy …
JavaOne 2013: Java Mission Control
October 6, 2013
AMIS, Development Tools, Java, Oracle, Oracle 12, Oracle WebLogic Server, Software Development, Software Engineering, Tools, Web HTML5 CSS3, Web/Java
1 Comment
The convergence project between Oracle’s JVMs JRockit and Hotspot is making significant progress. Included in the latest Java 7 JDK update (‘7u40’) is a new powerful monitor tool: Java Mission …
OOW13: summarizing one week and 2000 sessions in 3 hours and a bit – the yearly AMIS OOW Review session – 10th October
On Thursday 10th of October, the 12 man strong AMIS delegation at Oracle OpenWorld and JavaOne 2013 will present its findings in a 3 hour session at AMIS HQ …
OOW13: What questions to get answered and plans to see evolved at this year at Oracle OpenWorld Conference
As I am about to start my ninth Oracle OpenWorld Conference, I am wondering what this year’s conference will have in store for me. My schedule is largely filled …
Oracle OpenWorld & JavaOne Review bijeenkomst – 10 oktober
September 6, 2013
AMIS, Cloud, Development Tools, Java, Mobile, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, SOA, Tools, Web HTML5 CSS3, WebCenter
No Comments
Op 22 september begint in San Francisco de Oracle OpenWorld: hét internationale evenement waar Oracle haar productstrategie presenteert en Oracle-specialisten ervaringen uitwisselen. Naast Oracle OpenWorld wordt ook de JavaOne …
Oracle Database SQL – Recursive Subquery to inspect events in football matches – find the MVP
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot patterns in records and derive results from those patterns. …
Oracle Database 12c: Find most valuable player using MATCH_RECOGNIZE in SQL
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a facility for spotting patterns in records. This allows us …
Oracle Database 12c: Flashback Moving Forward
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up of a mechanism that has been at the core …
Oracle Database 12c: quickly create a virtual machine with OEL 6.4 and Oracle Database 12c (for dummies)
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than about command line. I have always been a little …
Oracle Database 12c: How to create a Virtual Box VM with Oracle Enterprise Linux inside – A dummy guide
I have a confession to make. I have not been into Linux very much. When I started my career at Oracle, back in 1994, I had to do a …
Oracle Database 12c: In-Database Archiving to deal with logically discarded records
When a record is no longer active – it is logically discarded – you may want to delete it. However, the record may still be required – for compliancy …
Oracle Database 12c: XMLIndex Support for Hash Partitioning
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH …
Oracle Database 12c: PGA_AGGREGATE_LIMIT
There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle… 😉 From the Oracle 12c Reference manual PGA_AGGREGATE_LIMIT: PGA_AGGREGATE_LIMIT PGA_AGGREGATE_LIMIT …
Oracle Database 12c: XQuery Full Text
New in Oracle 12c and one of the big new features in XMLDB is the XQuery Full Text functionality and, as mentioned in the post about XQuery Update, is …
Oracle Database 12c: XQuery Update
New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 11.2.0.3.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT …
Oracle Database 12c: Pattern Matching through MATCH_RECOGNIZE in SQL
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one …
Oracle Database 12c: joining and outer joining with collections
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by …
Oracle Database 12c: Export by View
A small enhancement, but what a golden nugget! At least that’s what I think. 😉 It is now possible in Oracle 12c to export data via a view. I …
Oracle Database 12c: PL/SQL package UTL_CALL_STACK for programmatically inspecting the PL/SQL Call Stack
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
Oracle Database 12c: DB Express – Sneak Peek
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a …
Oracle Database 12c: Getting Started with DB Express
Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use …
Oracle Database 12c: Oracle XMLDB is now Mandatory!
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in …
Oracle Database 12c: In Line PL/SQL Functions in SQL queries
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …
OOW 2012: Is PL/SQL still alive?
![OOW 2012: Is PL/SQL still alive?]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "OOW 2012: Is PL/SQL still alive?")
Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”. The room was packed. For the upcoming release of …
OOW 2012 – And was there news on the XMLDB front…?
Just finished my Birds of a Feather XMLDB panel session in the Marriott Hotel and now looking back on a event full day. It all started of with a …
OOW 2012 – Larry Ellison’s Keynote Announcements: Exa, Cloud, Database
Last night, Oracle Open World 2012 kicked off with the keynote session by Larry Ellison. In just under one hour, and with a novelty for Larry watchers (no more …