Oracle Database 12c: Oracle XMLDB is now Mandatory!

Marco Gralike
0 0
Read Time:2 Minute, 16 Second

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 the new feature section of the Oracle XMLDB Developers Guide for Oracle 12c:

Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and there is no option not to include it when you create Oracle Database. It is automatically installed when you create a new database or (if not existing already) when you upgrade an existing database to Oracle Database 12c Release 1 (12.1.0.1).

…and a bit further on…

Automatic Installation of Oracle XML DB

If Oracle XML DB is not already installed in your database prior to an upgrade to Oracle Database 12c Release 1 (12.1.0.1) or later, then it is automatically installed in tablespace SYSAUX during the upgrade.

If Oracle XML DB has thus been automatically installed, and if you want to use Oracle XML DB, then, after the upgrade operation, you must set the database compatibility to at least 12.1.0.1. If the compatibility is less than 12.1.0.1 then an error is raised when you try to use Oracle XML DB.

If Oracle XML DB was automatically installed during an upgrade and the current compatibility level is less than 12.1.0.1, then Oracle DB is automatically uninstalled during any downgrade to a prior release.

As a database administrator, I like “lean and mean”, so therefore my mixed feelings about this change. As the Oracle ACE Director for this functionality, I think it was inevitable, seen the changes over the years.

You might not realize it, but a lot of Oracle XMLDB functionality has been used and implemented over the years from Oracle 11.1 and onwards. It is used in area’s like dictionary views, packages like DBMS_METADATA, datapump utilities, APEX (PL/SQL Gateway servlet in the XDB Protocol Server environment), Data and Audit vault, enhanced security or DBFS.

Now with pluggable databases in the mix for 12c, it has become an intrinsic part of the database. The new DB Express, the replacement for DB Console in the database, is depending on some of the core XMLDB repository functions.

So database administrators alike, beware, $ORACLE_HOME/rdbms/admin/catqm.sql, is probably a good thing to get acquainted with. I advised my colleagues to start installing it, during new installations and/or upgrades to 11.2.x and onwards, so they get a feeling for the wonders and quirks of this database functionality and life gets a little bit easier when upgrading in the future to the latest Oracle 12c release.

Marco

About Post Author

Marco Gralike

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %
Next Post

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 of what is called the “XDB Protocol Server”, which among others supports the Oracle APEX standalone PL/SQL Gateway. For people who […]
%d bloggers like this: