Lightweight Oracle DBA Tools
Connecting to Linux node from Mac’s Terminal.app and not seeing ANSI colors? Here’s a fix: On your target Linux node check your /etc/DIR_COLORS file (or equivalent): root:[/root]# grep TERM /etc/DIR_COLORS # Below, there should be one TERM entry for each termtype that is colorizable TERM linux TERM console TERM con132x25 TERM con132x30 TERM con132x43 TERM [...]
I just finished installing Oracle Enterprise Linux (OEL) 5 update 4 (5.4) and ran into the following issue installing oracle-validated from ULN Network: [root@hercules1 rhn]# up2date oracle-validated Fetching Obsoletes list for channel: el5_i386_latest… ######################################## Fetching Obsoletes list for channel: el5_i386_oracle… ######################################## Fetching rpm headers… ######################################## Name Version Rel ———————————————————- oracle-validated 1.0.0 [...]
Oracle has just announced a new world record TPC-C benchmark result claiming that Oracle and Sun Are Faster than IBM: Proof Now Available. What’s really interesting is that they used Solaris OS instead of Oracle EL for this benchmark, specifically: “Oracle® Database 11g running on Sun SPARC® servers with CMT technology and the Sun Solaris [...]
I don’t normally use vncserver, I prefer SSH X11 tunneling/forwarding due to it’s inherited security, but sometimes there have been issues with X11/SSH and it’s nice to know an alternative. This quick how-to is meant for an Oracle DBA looking for a quick way to run GUI tools from the Oracle stack, such as runInstaller, [...]
In case you didn’t get this via oracle.com news updates — 11gR2 is out and available for download from here …. And as I have predicted, the first distro is Linux x86 and Linux x86-64. So if you are a die-hard Solaris fan it should now be obvious (if it wasn’t already) that Linux is [...]
After running ORACLE on SUN for over 7 years and being the big proponent of it I have finally said enough is enough. Starting this summer our shop made a switch to Linux (HP) and so far I could not be happier. I just don’t get it with SUN anymore they keep digging a deeper [...]
Vitaliy Mogilevskiy - Solving ORACLE problems since 1996.
What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.
Do you have DBA questions? Head over to Ask DBA.
DBA Forums