SA-DBA:

July, 2009

1

July 14, 2009  1:52 PM

TWO_TASK… an oldie but a goodie…

Richard Evans Richard Evans Profile: Richard Evans

TWO_TASK is a very useful but often forgotten environment variable. We actually just used it again the other day and we're always scratching our head saying "ok, I remember there is this variable we can set to do that... umm... it's... hmm, let me google and I'll get right back to you." Because...

July 14, 2009  1:40 PM

Environmental consistency .. is that even a real phrase?

Richard Evans Richard Evans Profile: Richard Evans

Whether it is or isn't doesn't really matter... what I mean by environmental consistency is basically just making your life easier by installing, configuring, testing, developing, etc, the same way. This is one of the reasons why I love Response Files in Oracle. Another thing we do pretty well...


July 10, 2009  7:17 PM

Grid Control OS Command Job and a problem…

Richard Evans Richard Evans Profile: Richard Evans

If you're an avid user of Grid Control, like me, then you've probably fallen in love with the ability to run OS commands on multiple machines from GC.  It's a great tool! For example, I often want to know how much space my Archive Logs are taking up - easy!  Since we have a very uniform...


July 10, 2009  4:45 PM

A win for us and the customers…

Richard Evans Richard Evans Profile: Richard Evans

Today we demonstrated the capabilities of Oracle Data Guard. I've implemented it at a couple other locations and absolutely love it. I'd still consider myself a DG newbie, but it's so straight forward and easy to manage at this point (10gR2) you don't have to be an expert. I've read that it gets...


July 10, 2009  4:06 PM

Piggybacking on VI’s importance…

Richard Evans Richard Evans Profile: Richard Evans

As a guy who uses Solaris for 99% of his administration I've gone from fearing vi to loving and respecting it and seriously considering buying it a valentine's day present every year. That's probably best reserved for a different blog all together:-) This is a good write-up on why VI is such a...


July 10, 2009  12:04 AM

Grid Control Job to Excel Worksheet

Richard Evans Richard Evans Profile: Richard Evans

Often times I'm asked to run a report that requires querying multiple databases. I suppose I could just setup DB Links and use a UNION ALL but why, when I have Grid Control? :-) First thing I do is setup a SQL Script job in Grid Control that looks like this. In addition to the user...


July 9, 2009  9:21 PM

Preventing MS Word from formatting your code…

Richard Evans Richard Evans Profile: Richard Evans

This is probably a problem that was solved years ago but I figured it out recently. Hopefully it helps someone! The Problem When I'm in Word and I'm creating or modifying documentation that involves code, Word wants to automatically replace certain characters with characters...


July 9, 2009  8:47 PM

Inaccessible UNIX filenames…

Richard Evans Richard Evans Profile: Richard Evans

I goofed up earlier and somehow managed to give my file a name. To fix this I was able to rename it by using ctl+v followed by ctl+h to generate the ^H character. The Problem When I saved it in vi I somehow messed up my :wq! And I it saved it with this name: "^H"...


July 9, 2009  4:31 PM

Silent Install of Oracle EM Agent 10.2.0.4

Richard Evans Richard Evans Profile: Richard Evans

I install a lot of Oracle EM Agents... it's time consuming and I never seem to do it quite the same way. So I decided to do what any lazy computer guy would do and spend a day configuring various response files so I don't ever have to work again! Well, at least so I don't have to manually install...


July 9, 2009  12:00 AM

select user from dual…

ITKE ITKE Profile: ITKE

SQL> select user from dual; USER ------------------------------ Rich :-)   Hi, My name is Rich and I've started yet another Oracle blog for you to keep track of (use Google Reader, it rocks!). Will this one be better than the rest? Different from them? How about at...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: