Microsoft Cluster Server anomaly
Two weeks ago I encountered a very weird issue when using Microsoft Cluster Server. What happened? We created a MS Cluster Server environment with two servers (NodeA and NodeB, the …
Category: DBA Oracle
No WinFS! – ZFS rules? – others…
Today I read a remarkable statement in the Dutch Automatiserings Gids - they claim that Windows WinFS will not only not be embedded in Windows Vista but also will …
Mastering XML DB – Unexpected side effect of updateXML
When trying to create anonymous data, I encountered an unexpected side effect of the updateXML statement while updating XML documents in an Oracle 10gR2 (10.2.0.1.0) EE database. I got …
Ohhh, thy mighty Oracle…
Ohhh, thy mighty Oracle. I had completly forgotten about him and then we where re-united. We met years and years and years ago…and I coud always ask him …
Using FNDLOAD to transfer Oracle Alert
When you use Oracle Alert, a module from the Oracle EBS, you probably work with custom alerts next to the standard alerts provided by Oracle. When working with custom …
Installing Oracle Grid Control 10 release 2 on SuSE 9.3 ES
With all those fancy plug-ins for Microsoft tools release 2 of Oracle Grid Control 10g seems to be a must-have. However, according to many postings on the internet, installation …
Find the number of descendant nodes in a SQL query – how many employees work (indirectly) for me? And what do they earn on average?
Every once in a while you run into a SQL challenge that seems extremely simple at first glance and turns out to be not so very simple when you …
Oracle and resilvering on AIX
Oracle and resilvering data on Mirrored Logical Volumes on AIX How to set up your storage with regards to Mirror Write Consistency Suppose you have or plan to implement an …
Friday afternoon – updating Oracle XE
I had nothing really to do this afternoon, so i updated Oracle XE (10.2.0.1 Beta) with the Oracle (standard database) patch 10.2.0.2, that is...only the data dictionary part. Just …
Back to the future (Oracle 4.1 VM appliance)
We had some nice KC-DBA (expertise meetings) meetings in 2005. One of them was about virtual machines (VMware basically). To show how you could use virtual machine technology to …
Oak Table Seminar – Optimizing Oracle Performance by Design by Jonathan Lewis (day 2)
Jonathan Lewis Optimizing Oak
Oracle buys Sleepycat
It becomes stranger and stranger. After bying the open source company InnoBase, Timesten, and others, Oracle now also bought SleepyCat. Oracle also released its own freeware in the form …
ASM made easy
Great article about ASM on the website of Howard Rogers: http://www.dizwell.com/oracle/articles/desktop_asm.html For both Linux and Windows.
My First Oracle XE
After the announcement of Oracle XE I got really curious about the possibilities of a free Oracle10g database. OK, it is limited to 4GB and it doesn’t allow things like …
New Release Times Ten
Oracle announces release 6 of their In Memory database, more details here. Faster, bigger, better and easier… well, let’s try it first.
Functional Partitioning
We all know partitioning for performance issues or for storing historical data. But partitioning can also be used for functional purposes such as creating a savepoint in batchrun. Such …
Steve Adams is in town – Oracle with a calculator
Today I attended the workshop that Steve Adams is giving in the Netherlands this week. We were with a group of four AMIS employees. The day started in a …
Small introduction to SQL*Net debugging [client side]
Say it's that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems. Blast!. What can you do? Once in a …
OERR – In search of Error Messages/Events
Sometimes you want to search for Oracle database messages, their meaning or you are in search of specific database event settings. For instance, a long time ago i was …
Oracle Database 10gR2 for Windows Download
Just noticed the Windows download of the Oracle 10g Release 2 database (lagging the Linux release by almost a month!). And: it is still a developer preview, not even …
Oracle Database 10g Release 2 available (only on Linux right now)
Oracle just released (or at least I just saw) the availability of the Oracle 10gR2 database, for Linux. I assume that in a few days time we will also …
TimesTen
Oracle aquired TimesTen. See here for more details. By the way “fusion middleware” is the new name for application server, collaboration suite, etc, technologies.
Using the Distributed Configuration Manager (DCM) command shell…
At first I couldn’t remember this dcm-commands and always had to type them at least twice untill… I learned about the “shell”- subcommand which is part of Oracle iAS’s …
Mastering XML DB – COUNT and SUM
May 20, 2005
AMIS, Announce / Events, Database, Databases, DBA Oracle, IT, Web HTML5 CSS3, XML
5 Comments
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to …
Old undocumented stuff – Recompiling with timestamp.
Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a "undocumented" Oracle feature popped into my mind again. Last time I used is at …
Registering non-default XMLDB HTTP/WebDAV and FTP ports on a non-default Oracle Listener port
Yesterday, I had to install XMLDB on an already very heavy used system. On this UNIX system, an old Oracle IAS is installed, OAS 10g (version 9.0.4) and an …
Missed MySQL New Toolset
I apparently completely missed the new MySQL toolset, which was announced on December the 8th 2004. The MySQL database ships now with easy-to-use visual database tools: MySQL Query Browser …
Just before X-mas
On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into the 21st century with the relational model: a technical …
Configure sendmail to forward all mails
Go to /etc/mail/ and look in the sendmail.mc file. Uncomment and change the entry define(`SMART_HOST',`forward.host.domain'). Additional info: The sendmail.cf is generally considered to be too difficult to be changed …