Two Oracle user group events in California this week

Donald Burleson points out two Oracle user group events happening in California this week. There’s the Northern California Oracle Users Group Spring Conference and the Los Angeles Oracle Users Group Spring Conference.

Unfortunately I’m on the wrong coast to take advantage of these, but if you are in or near California check it out. It’s important to take advantage of these conferences when they’re close to home!

dba, database administration, database, oracle, conference

Map of online communities according to xkcd

Partial online community mapxkcd has posted an amusing and interestingly representative map of online communities. Make sure you click through to the large version, otherwise you won’t be able to see Google’s volcano fortress. It’s a shame there isn’t an even larger version as there are still some things I can’t make out.

Update: Steve (who has a really cool blog) points out that a 24″ x 25″ print of this map can be pre-ordered from the XKCD store. Thanks for pointing that out Steve!


funny, fun, humor, online communities, social networking, web20

More Linux and UNIX find command options

Like many Linux and UNIX commands, the find command supports a long list of options. I covered several of the options in a previous article but there are even more useful options. Here are some of them:

Doing things with what we find

The –exec option gives find the powerful ability to execute commands on the files found. The syntax is a little tricky but an example is usually all it takes to get it right.

Before using the -exec option, especially with a powerful command like rm I recommend performing the same find without the –exec. By doing this you will see exactly which files you will be affecting when you run the final command.

The following is a practical example that finds files less than three days old with the .txt extension and deletes them.

Finding .txt Files < 3 Days Old and Delete Them

$ find . -name '*.txt' -mtime -3 -exec rm {} \;
$ ls –lt
total 8
-rw-r--r-- 1 tclark authors 2229 Jan 13 21:35 declaration.txt
-rw-rw-r-- 1 tclark presidents 1310 Jan 13 17:48 gettysburg.txt

The –exec option allows you to put any command after it. Here we have used rm but it is often useful to use this option with cp or chmod. Within the command to be run there must be two curly brackets {}. find will execute the command for each file it finds substituting the file name (and path) where the curly brackets are. Finally the end of the –exec option is signaled by an escaped semicolon (\;). The –exec option should always be the last option given in a find command.

The find command is great for finding files and directories but next we’ll look at some options for finding other things on the system.

Dealing with “Permission denied” in find

If you use find a lot (and you probably will) you will sometimes run into the problem where you get just pages and pages of output like this:

$ find / -name '*.txt'
find: /var/lib/dav: Permission denied
find: /var/lib/nfs/statd: Permission denied
find: /var/lib/dhcpv6: Permission denied
find: /var/lib/slocate: Permission denied
find: /var/lib/xdm/authdir: Permission denied
find: /var/lib/php/session: Permission denied
find: /var/log/samba: Permission denied
find: /var/log/ppp: Permission denied
find: /var/log/audit: Permission denied
find: /var/log/squid: Permission denied
...

This is find telling you there are certain directories you don’t have permissions to search. This can make it very difficult to find the useful output of the find as it can be mixed in with the permissions errors.

To ignore these (and any other) errors and just get the results of what you can find we can use a special redirect at the end of the command. Redirecting output will be covered in more detail in the chapter on shell scripting, but suffice it to say that in this command 2>/dev/null is redirecting the error output to nowhere.

$ find / -name '*.txt' 2>/dev/null
/var/www/icons/small/README.txt
/usr/X11R6/lib/X11/rgb.txt
/usr/X11R6/lib/X11/doc/Xprint_FAQ.txt
/usr/lib/4Suite/tests/Xml/Core/count.txt
...

While it would not be a good idea to redirect the error output all the time (usually you want to know when something has gone wrong) in this case of the find command it can be very useful.

Easy Linux CommandsFor more tips like this check out my book Easy Linux Commands, only $19.95 from Rampant TechPress.

Buy it now!


find, search, unix, linux, system administration, sysadmin

Shell Scripting Presentation at the Green Mountain Oracle User Group

GMOUGNext Tuesday, May 8th I will be presenting at the Green Mountain Oracle User Group annual meeting in South Burlington, Vermont. The topics will be Shell Scripting for the Oracle Professional and SQL Tuning.

This event is $20 for members (which includes breakfast and lunch) but non-members can pay $90 for the registration fee and 2007 dues. The event also includes the annual meeting of the GMOUG so it would be a great time to join and meet some of the members!

The event is in South Burlington, Vermont and will run from 8:15 AM to 4:00 PM. See the GMOUG website for a full agenda and RSVP information.

vermont, technology, oracle, information technology, unix

Some great things to ask when interviewing for a job.

Now that I’ve had a nice break from writing after finishing my book Oracle Shell Scripting (on shelves this summer, stay tuned for details) it’s time to catch up on the backlog of blog topics I’ve been meaning to write about.

Last month Alexander Kjerulf posted this great article on some killer questions to ask in your next job interview. Alexander puts a lot of emphasis on finding out how other’s experience at the company has been. Believe me, if it’s the type of place that is fun and exciting to work at they will be more than happy to tell you all about it!

Asking questions in interviews does more than help you learn about your perspective employer. Asking informed, intelligent questions will show that you are serious about the job and know your field. Ask about the work environment both socially and technically, but don’t hesitate to talk about the office culture, recent corporate milestones and more.

Check out Alexander’s full article for some great interview tips. As Alexander points out asking positive questions will give people a positive impression of you. That alone can be enough to make you stand out from other candidates and get you the job!

interview, job, job search, interview questions