JamesKoopmann.com header image 4

Entries from October 2007

Oracle alert log scraper in Windows .BAT

October 24th, 2007 · 1 Comment

Scraping the Oracle alert log in Windows
thecheapdba has been combing the net for scripts to scrape the Oracle alert log for the last few days. Ok, you have me here! It didn’t take long for this cheapdba to quickly realize that 99% of the scripts out there are for Unix type machines. AND I didn’t [...]

[Read more →]

Tags: Oracle

.BAT script argument processing

October 16th, 2007 · No Comments

Ever have the need to process arguments passed into a .BAT scripts incrementally? In the past I have easily just assigned and used the internal variables %1,%2,%3..etc.. to take them as given. But often times you might want to process them individually at the beginning of a script so that you can validate what has [...]

[Read more →]

Tags: Oracle

Date and Timestamps in vi

October 14th, 2007 · 1 Comment

This isn’t really a database topic but I find it very helpful. ths particular post shows you how to put a date and timestamp into a text document as you are editing with vi. of course you can change these procedures to do anything you want to shorten your keystrokes.
Being somewhat of a command line [...]

[Read more →]

Tags: Oracle

VBScript for Sending Email with LOCAL or REMOTE SMTP Server

October 1st, 2007 · 17 Comments

After our last post, I am sure you were wondering if you really needed to install a local SMTP server to send email from Windows. Well here is a VBScript that allows you to send to a remote SMTP server.
Also, there is some code here that allows you to send authentication information (username/password) to the [...]

[Read more →]

Tags: Oracle