Or in other words how to use namespace based on the “new” method (Oracle 10.2 and above) or the method that can be used on older versions (and newer of course). This post is just a reminder, because this is always a hassle (and I never can remember when I need to). The post is …
Monthly Archive: November 2007
Nov 27 2007
I saw the following example on the XMLDB forum. I can imagine that this can be applied for good use. Thanks “michaels”. http://forums.oracle.com/forums/thread.jspa?messageID=2214026 Related posts: Mastering XML DB – Unexpected side effect of updateXML Rule based in Oracle 10g HOWTO: Query via Xpath position function How to be stupid – Learning from your Mistakes (aka …
Nov 26 2007
A long long time ago (during my Oracle 7 days), I once needed to update base table SYS.PROPS$. This action was needed to change the database NLS characterset of US7ASCII to a characterset that would support GERMAN. Based on a metalink note, updating the SYS.PROPS$ base table, was the only way to achieve this (or completely rebuild the environment).
Since those days, I always lookup NLS settings via a quick select on that table. The last time I did this, was a long time ago and to my surprise, while looking up settings, I noticed that this table does contain more data then only NLS parameters these days…
Output of a full (demo) clean database Oracle 11g installation gives:
Nov 23 2007
Yesterday my Comodo Firewall (version 2.4) alerted me that there was a new update for the software. Until know I was very happy with this free (lifetime) software package, until I updated the software…
It upgraded itself to Comodo Firewall Pro 3 (firewall software plus intrusion detection software). Great I thought and during installation it asked if I wanted to set it to, for instance “learning” mode. I liked this in the former version, so I did it again. After a reboot, hell broke loose.
Nov 21 2007
This is a bummer and then again it is not. I am thinking lately a lot about how to bring the conceptual XML(DB) world into the Oracle Relational world, or in other words “what is needed to make XML fast – given an Oracle database 11g atmosphere”. One my ramblings was: OK given the XML free format, how do I a create an environment that’s very high selective based on indexing and or breaking up XML fragments in physical segments (therefore hopefully being more selective) that can be handled more easily by the Oracle Optimizer (even given items like, creation solutions for, XML deficiencies like data redundancy etc).
Nov 15 2007
Little bit cynical or not?
Anyway after downloading it, unzipping it, it was installed in a breeze. It is delivered as a ISO so I mounted the ISO under the CD ROM. The guest I used was a VMware Server guest based on RedHat 4 (32b).
I used the following:
- RedHat Enterprise Linux 4 host (32b)
- 1.5 Gb RAM
- 20 Gb extensible HD
- Network: NAT
Mounted the ISO under the virtual CDROM. I kept all the defaults except manual TCP/IP setting to 10.1.1.100, because I use NAT on a 10.1.1.1 range. Funny stuff that passed the installation window. OCFS2 is apparently used. The core OS (in my situation – 32 bit install) is 2.6.18-22.214.171.124.18.el5xen SMP. So in other words, it is based on Oracle Enterprise Linux V5 (XEN).
I also already downloaded Oracle VM Manager, but because this has to be installed on Oracle Enterprise Linux, this has to wait… I don’t have a VM host ready and the software is somewhere a the office. To much hassle to download the ISO’s again, so this is maybe something for tomorrow if I have the time (also have to do some normal DBA work during the day ).
Here are some first pictures of the Oracle VM 2.1 Server
Nov 14 2007
As Justin Kestelyn just announced it, it can now be downloaded. Apparently there will be guest appliances as well soon. Have a look here: http://www.oracle.com/technology/tech/virtualization/index.html http://edelivery.oracle.com/oraclevm (direct download via Oracle E-Delivery) I am so going to enjoy this (at least I hope). Lets see what it can do. Related posts: Oracle Open World 2006 – …
Nov 12 2007
This is great news! Is this great news? Missing out of being there (SF), I wonder what the VM core of Oracle is. Is it based on Xen. As can be read on, probably a lot of the oracle blogger community sites, Oracle is going virtual. It looks like it is a “bare metal” environment (it can be installed out of the box on HW), which also sounds like something from years ago (the “raw iron” project). In that sense I only can jubilate…
I am a great fan of virtual machines as can be read on this blog site. I revived Oracle 4.1 and Oracle 5.1 on VMware, doing almost all my testing on VM environments. Until now I always had some resistance regarding deploying project environments on VM’s because of Oracle’s licensing strategies and support regarding production environments. At least you are now able to choose for a licensed and supported package. If it will be a good deal, only the future can tell.
Nov 05 2007
Tomorrows presentation at AMIS, will be my first test run for my UKOUG presentation in December, Birmingham. It took me a while to get the red herring from my braincells onto a Powerpoint presentation. To be honest, I am still not really pleased with it. It lacks some coherency, but I almost now for sure that it will be there when I start of and introduce my audience into the wonderful (sometimes confusing) world of XMLDB.
I will address a lot of DBA viewpoints on to the matter.
Nov 01 2007