Life After Coffee

My book, Oracle Shell Scripting has received another 5-star review on Amazon!

A. Tucker “Rat” writes:

Oracle administrators of all levels will find benefit in this book. The author has put together the basics in shell scripting and OS fundamentals in aid of maintaining and monitoring scalable production Oracle environments. Each example is easy to read and follow and leaves the reader with room to explore and extrapolate on their own with little effort. A great lookup source for old timers and “must have” for newbies.

I highly recommend this book
-Rat

Thanks for the great review Rat!

Check out my book Oracle Shell Scripting, only $34.95 from Rampant TechPress.

Buy it now!

Finally, the solution to my mobile charging needs: the Belkin Mini Surge Protector with USB Charger.

Coming soon from Belkin this small device offers surge protection for your laptop and devices when you travel and also has two USB charging ports! You should be able to charge many cell phones (like the Razr or Blackberry) and devices like iPods right off the USB ports eliminating the need to keep your computer awake while your devices charge. This should also be nice if you want to leave the computer behind but still need a way to charge your iPod (it’s been a long time since iPods came with 110 volt chargers.)

Belkin is listing the surge protector with a modest $25 price on their site and list it as “Coming soon”. As soon as this becomes available I’ll grab one and post a review here.

via the Daily Giz Wiz podcast

Shell variables give us a place to store values for use by the system, our shell, shell scripts or by programs we run. Each session in UNIX has a set of variables that collectively are referred to as the environmental variables. These variables tell the system where to find applications and documentation, where the user’s home directory is, the current working directory and much more. You can easily view all the environmental variables in the current session with the env command:

$ env
TERM=vt102
SHELL=/bin/bash
SSH_CLIENT=192.168.2.1 54620 22
OLDPWD=/export/home/oracle
SSH_TTY=/dev/pts/1
USER=oracle
MAIL=/var/mail//oracle
PATH=/usr/bin:/usr/ucb:/etc:.
PWD=/u01
TZ=US/Eastern
PS1=$
SHLVL=1
HOME=/export/home/oracle
LOGNAME=oracle
SSH_CONNECTION=192.168.2.1 54620 192.168.2.100 22
_=/usr/bin/env

These are some of the default variables provided by the system. As Oracle users we’re also familiar with shell variables such as $ORACLE_HOME and $ORACLE_SID.

While most of the environmental variables in the output above are set by the system, variables like $ORACLE_HOME need to be set by the user. In the bourne and bash shells, environmental variables are set by giving the variable name, the equal sign (=) and then the value the variable should be set to. The variable must then be exported with the export command so it can become available to subsequent commands.

$ ORACLE_HOME=/u01/app/oracle/product/10.2.0/Db_1
$ export ORACLE_HOME
$ echo $ORACLE_HOME
/u01/app/oracle/product/10gR2/db_1

When setting variables you simply use the variable name; however, as we see in the above example we use the $ prefix to retrieve the value of a variable. You may also see the variable definition followed by the export on the same line separated by a semicolon. The semicolon marks the end of the first command allowing the commands to be executed as if they were on separate lines.

These exported environmental variables typically affect how UNIX and Linux behave or how other commands run. Though not a rule, environmental variable names are typically all uppercase. Lowercase variable names are typically used for local shell variables that are only needed in the current session or script. Local shell variables need not be exported.

$ day=Monday
$ echo $day
Monday

It’s important to remember that shell variables are specific to a session, not a user. That means if you change the environment variables in one session it will not have any effect on other active sessions.

Beyond the familiar Oracle related shell variables we’ll be using shell variables for storing date information, file and directory names, passwords and much more.

For more information like this check out my book Oracle Shell Scripting, only $34.95 from Rampant TechPress.

Buy it now!

Well, I’m glad to see that people are liking my book Oracle Shell Scripting: Linux and UNIX Programming for Oracle. Another 5-star review showed up on Amazon last week:

Jolly writes:

Great book!

A well written book. A great way to learn shell scripting. Relevant and useful examples throughout the book (downloadable code).

Thanks for the review Jolly!

For more information like this check out my book Oracle Shell Scripting, only $34.95 from Rampant TechPress.

Buy it now!

When you connect to a system, whether directly on the system’s keyboard or through a remote connection you will automatically start in your default shell. The default shell was originally assigned to you when your account was created.

To find out what shell you are currently using we can use the echo command:

$ echo $SHELL
/bin/bash

In this command we are using the echo command to examine the value of the environment variable $SHELL. This variable was set by the system when we started this command line session and shows the full path to the shell we were assigned at login. Here are some common shells you might see:

• /bin/sh – Bourne shell
• /bin/bash – Bourne Again shell
• /bin/csh – C shell
• /bin/ksh – Korn shell
• /bin/tcsh – TC shell
• /bin/zsh – Z shell

Shell binaries are also commonly found in the /usr/local/bin directory. Consult your system administrator if you’re having trouble finding your shell binaries.

For more information like this check out my book Oracle Shell Scripting, only $34.95 from Rampant TechPress.

Buy it now!