Posted on:
December 30, 2011
Category Archive: Old Stuff
Posted on:
December 30, 2011
Jan 16 2008
Does anyone remember nCube?
Yesterday I got the strangest feeling. I scrawled the internet and then the name nCube pupped up in my mind. “In the old days” this was really a machine on which I wanted to have the privileges to work on (Oracle database wise). In those days I had the luck to work on a Oracle …
Nov 26 2007
Content of base table SYS.PROPS$
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:
Read more…
Oct 12 2007
Going the Total Retro – Solving SQLPME V1.2.1 Problems with Oracle V5.1.17.4 on MSDOS
Did it. At last I managed to install Oracle V5.1.17.4 on MSDOS 6.22 under VMware Server 1.04. You probably think I am nuts. As someone said on our way home from Miracle Open World: “I would spend my time learning Oracle 11g”. Maybe. The person who said it, by the way, is an Oracle trainer, so what would I expect…
I / we (Bert Jan Meinders, an old colleague of mine) did our first attempt almost 1, 1 1/2 years ago. Our first attempt was based on VMware GSX software after we succesfully installed Oracle 4.1 on MSDOS. This was the first time (and until now the last time) I saw a total crash of VMware software. Oracle V5 was shipped under DOS with a memory manager called SQLPME (SQL Protected Mode Executive) V1.2.1.
This memory manager made extended memory available for use of Oracle software (database, forms etc), this way it could cross the 640 Kb boundary of conventional memory.
SQLPME was aggressive enough with its peeking and poking in memory that it crashed the VMware GSX environment at the time. Under VMware Server 1.04 it just hung itself up / nothing happened.
Click on the image to enlarge
Read more…
Oct 15 2006
With double quotes (almost) everything goes…
After you have read the blog posts the websites of Sergio Leunissen, Eddie Awad or the “Ask Mr. Ed” website, you may wonder, if that was all you could do with those “magic” double quotes… Probably not, I know of at least one other neat “trick” you can do with it… Ever tried the following? …
Apr 11 2006
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 implement an environment which would be almost undoable nowadays to realize, a virtual machine environment was demonstrated with Oracle 4.1 installed based on DOS. Thanks to …
May 12 2005
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 least in those days I worked with Oracle 7.0 /7.1. So I tried It out on Oracle database version 10.1.0.4 and it still works… Maybe it …
Recent Comments