Pertinent Issues in Manual Installation of XML DB on Oracle 11g

image 2

XML database is one of the most outstanding features of the Oracle database and for good reason. It is a data management solution that is primed on high-performance and retrieval technology, which are features every business needs.

As data persistence software, it enables the DBA to store data in XML, and can then be queried, serialized or exported in the desired formats. The benefits are immense, including enhancing efficiency and reduced conversion costs.

Oracle XML absorbs W3C XML data model while providing the DBA with new standard access methods to help in querying XML. In other words, Oracle XML DB offers a double-prong advantage of a relational database and the unique advantages of XML.

Oracle XML DB provides your business with a powerful tool for managing complex data including storage, manipulation and retrieval.  You also get different storage options namely:

  • Unstructured storage: This offers you the best insertion times by storing documents in large formats. However, this option consumes a lot of space and can only be applicable where disc space is not a big issue.
  • Binary storage: This is a new addition to Oracle 11g and offers the best alternative to unstructured storage. It offers an XML schema-aware option, better disc utilization and enhanced query performance.
  • Structured data storage: This option uses an object-relational model to store XML documents. It is the optimal option if you are looking for enhanced efficiency and relational access. If you are handling complex large files this is the best storage alternative. The only downside is the large overhead during file insertion.

Oracle XML DB Installation

Installation can be done with or without a database configuration assistant (DBCA). In a situation where you are upgrading an existing installation, you will not use a DBCA. Instead, you will have to do manual installation.  Here are some pertinent factors to consider in the process:

  1. Confirm XML DB is not already installed by checking the database users. The username XML should return no zero rows.
  2. Perform the XML installation from the system. One factor to remember at this point is the impact of the Oracle Bug 9818995, which prevents a complete build if catqm.sql script is run.
  3. Once installation is complete, you should grant necessary permissions to the XDM user.
  4. Next, ensure there are no invalid objects which will hamper loading at later stages.
  5. Configure the XDB dispatcher.
  6. Check and repair missing contents caused by the Oracle Bug 9818995.
  7. Check invalid objects once again.
  8. Once SYS confirms XDB is fully installed, restart the database and listener to allow the Oracle XML DB protocol access.

There is no denying that the whole process is overwhelming if you don’t have the right skills. This is where remote database administration services come in handy. These experts have the right skills, experience and resources to ensure your database enjoys Oracle database solutions such as XML among others.

With improved performance through numerous enhancements and scalability options, XML DB is a wise investment in your business. Just make sure you have a technical expert to guide you through the process.

BIO

Mike Chan is a remote database administration services provider who has been in the industry for over 9 years. The Chicago-based DBA evangelist writes prolifically on industry trends and you can catch him on his blog.