Submitted by dmann on Wed, 01/02/2008 - 22:56
I haven't look at Oracle's Remote Diagnostic Agent (RDA) tool in a couple of years. Back when we ran our systems on Windows I remember using a clunky version of RDA that looked like it was cobbled together with batch files and VB code.
What is RDA? From the Oracle website:
Submitted by dmann on Thu, 11/15/2007 - 18:18
Want to use SubVersion but only have access to a box via SSH? Maybe you've got a cheap web hosting account and the host hasn't gotten with the program to officially offer SubVersion as a feature?
This post outlines a way to install SubVersion server and have your client access the repositories via SSH.
- If you've got SSH access and rights to compile some code, you can get SubVersion running. I was able to do this on a cheap Bluehost.com account.
Submitted by dmann on Wed, 11/14/2007 - 18:03
So I have mentioned before about the replication product that we use that is based on Archived Redo Logs (Golden Gate). Well sometimes the replication process abends before the RMAN backup. Since there is no communication between the two processes, RMAN happily removes archived logs that the replication process might need the next time it starts up.
Because of this we usually like to keep a few hours worth of archived logs hanging around.
Does this suck up disk space? Yes.
Is it worth it sacrifice some disk space in order to save us some DBA time? Absolutely.
Submitted by dmann on Wed, 11/07/2007 - 17:25
I colleague turned me on to a helpful command the other night.
Where I work we have an archived log based replication system. It was way behind on processing and the replication process doesn't give any indication of what log its currently chewing on.
/sbin/fuser to the rescue!
- 1) 'cd' to a directory where you want to check the files
- 2) run '/sbin/fuser *' to discover what processes are touching files in the directory
[oracle@test /] cd /u01/app/oracle/oradata/TEST
[oracle@test TEST] ls redo*
Submitted by dmann on Wed, 10/10/2007 - 22:49
Submitted by dmann on Wed, 10/03/2007 - 23:49
I've been using TextPad for writing Perl programs forever. TextPad is a pretty lightweight editor with a lot of decent features. Its nice because you can set up a PL document class with a syntax file to enable highlighting whenever you edit a *.pl file.
But today I'm working on a more complicated script with multiple functions. My main requirement is that there be an outline view so I can quickly jump between functions.
Submitted by dmann on Sun, 09/23/2007 - 15:13
Allrighty, this is awesome. One of my main reasons I like to work in the office instead of at home is how my environment is set up. Things are kind of slow over the VPN so its easiest to just use Microsoft Remote Desktop Connection (mstsc.exe) to connect to my work PC. But the big issue was the display. I like having a lot of screen realestate. I've got 2 21" monitors at work, and I've got the same setup at home.
Well with the latest version of mstsc.exe you can create a huge desktop session that spans both monitors!
Submitted by dmann on Sat, 09/08/2007 - 16:35
Submitted by dmann on Wed, 09/05/2007 - 15:51
I know using Perl backticks call I can execute an OS command and easily get the output.
I know using Perl system() call I can execute an OS command and easily get the return value.
Today I found out a way to get both.
Submitted by dmann on Sat, 07/28/2007 - 13:22
A friend of mine just turned me on to Pentaho.
From the site: