Introduction
Last week I have been investigating the XML DB basic demo at OTN (http://www.oracle.com/technology/tech/xml/xmldb/9.2.0.2.0/index.html, Downloadable Demo). Unfortunately there is also a similar but older demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html (Oracle9i R2 XML DB Demonstration).
The demo shows a lot of XML DB stuff. It is quite comprehensive with a few installation quirks. Those quirks may have been caused by using a brand new Windows XP laptop and an Oracle 10g database.
Installation
Follow the instructions in the basicDemo.pdf with the following remarks:
- The HTTP page for the Microsoft XML parser has been moved to http://msdn.microsoft.com/XML/XMLDownloads/default.aspx.
- Modify the script install.vbs to replace the following lines.
If not isNULL(iconPath) then oShellLink.IconLocation = iconPath End if
by
If not isNULL(iconPath) then If (iconPath <> "") then oShellLink.IconLocation = iconPath End if End if - Unlock the Oracle scott account:
alter user scott account unlock;
- Grant unlimited access on the default tablespace for scott:
alter user scott quota unlimited on users;
- OracleSID in installParameters.xml is actually the TNS entry and not the ORACLE SID.
- Be sure to execute step 0.2 (Reset Demo)!
Demo
All examples run without any problems. The demo describes the following features of XML DB:
- Storage of structured (XML schema) documents as well as non structured documents.
- Access to the database via Internet Explorer (using the Webdav protocol).
- Editing XML documents using Microsoft Word (using the Webdav protocol).
- XPath, SQL and Oracle Text access.
- XML stylesheet transformations (XSLT).
Conclusion
I think every Oracle developer/architect should run the demo. It gives a good overview of XML DB which enables developers/architects to decide whether XML DB can be useful in their projects. For me XML DB seems not only useful for storing XML but also for (simple) management content systems due to the support of the WEBDAV and FTP protocols.
I clicked on the 0.1 (initial setup) and 0.2 (reset demo) icons in the folder created in my desktop. But both of them prompt
user name and password (entered scott/tiger) and nothing happened Are any scripts are associated with those icons?
Hello,
Thanks sooo much for your comments. I was running into the same errors.
One question to you if I may ask. How do you evaluate XML DB performance wise?
I am also using 10g and had the comple problem. I used your code fix, and now it works.
Thanks so much!
select * from dba_errors gives…?
How did you get the xdb.xdb_configuration
package to compile ? am also using a 10g db on xp and am getting
comiplation errs on this package ,, however sho err doesn not show
what the error is !
I tried this demo on my 10 g db in my laptop.
I could not get to compile the xdb.xdb_configuration pkg .
Sho err doesnt shows no errors ! Not sure whats going on