Shell scripting is an important expertise that every professional DBA must possess. Most DBAs use this coding technique to automate many critical database administration tasks such as database backups and monitoring. As part of your job, you'll be asked to maintain scripts that prior DBAs have written, and you'll also be required to write new shell scripts as unique needs arise. The better you are at scripting, the better you'll be able to perform your job.
To be effective at shell scripting, DBAs minimally need to be familiar with four types of tools:
The most common tools that map to the previous list are SQL*Plus, the
vi editor, and the Bash shell. The Bash shell ...