Category: 11gR1, 11gR2
September 3

Oracle 11g: Peeking into Protocol Server functionality – orarep and DBMS_REPORT

It is undocumented. At least I couldn’t find references. In the XMLDB Protocol Server there is an extra service called orarep, and of course, everything which is undocumented interests me to pieces.

The xdbconfig.xml XMLDB Protocol Server configuration file has the following content ( “<>” has been replaced by “[ ]”):

[servlet-mapping]
  [servlet-pattern]/orarep/* [/servlet-pattern]
  [servlet-name] ReportFmwkServlet [/servlet-name]
[/servlet-mapping]

If you try something like http://localhost:8080/orarep/ something like the following will show up.

Read the postOracle 11g: Peeking into Protocol Server functionality – orarep and DBMS_REPORT
August 28

How to be stupid – Learning from your Mistakes (aka Referencing Namespaces)

Sometimes I forget the stuff I have learned… And sometimes someone, I am lucky enough (in this case on the OTN XMLDB Forum), is so friendly to point out how silly I am 😉

Last Friday I was testing Binary XMLType Tables in combination with use of an XMLIndex; Both using / being based on an XML Schema. The objects both used namespace references to the, for binary use, registered XML Schema. Whatever I did, it didn’t react as was described in the manuals.

It doesn’t help, that I know now that I should have been more observing to see what XMLSpy had generated as an example XML Instance document, nor the fact that I pinpointed to much on syntax and storage statements.

Luckily, in my mind, always conspicuous on stuff related to namespaces, I was so “smart” to not create a Oracle Support Request, but addressed it via the XMLDB OTN Forum… I was very embarrassed to read about (and afterwards had a good laugh about my mistake) as “Chandra” showed me my failure to see the simplest mistake…

Read the postHow to be stupid – Learning from your Mistakes (aka Referencing Namespaces)
August 28

About Moving, DeDuplication, SecureFile Storage and Encryption of Binary XMLType Tables

In this post I wanted to share some methods you can use while manipulating XML data. My XMLType Table example is based on my last posts about XMLIndex and (binary) XML Storage. So if you want some more information I suggest reading up on those as well.

Triggered by a great example from Jonathan Gennick (“Faster, Safer, and Smaller LOBs”) in the September issue of Oracle Magazine.

I used this as a base, manipulating XMLType tables and see what happens if I would do the same, but now on XML objects.

Read the postAbout Moving, DeDuplication, SecureFile Storage and Encryption of Binary XMLType Tables