What Unix commands can one use when administrating a database?

The Unix command set is so rich that we can never list them all, however, if you are a beginner, you may find the following commands useful. To get a detailed description of any command, just type man command-name.

Basic Commands:

• cd - Change the current directory. When you log in, you are in your "home" directory

• ls - List files in a directory (like the DOS DIR command)

• pwd - Print working (current) directory

• cp - Copy (duplicate) a file or directory

• rm - Remove (delete) a file. Note that rm is permanent, there is no undelete. Be careful "rm -r *" is an easy way to get fired!!!

• mv - Move or rename a file or directory. Works like cp except the old file is deleted

• mkdir - Creates a new (sub) directory

• rmdir - Remove a directory

• chmod - Change file permissions or access attributes

• man - UNIX manual pages

• du - Disk usage

• script out.log - Write everything printed on your terminal to file out.log. Hit CNTL-D to stop.
  

More advanced commands for the guru's:

• ps -ef | grep inherit - List all running Oracle Listeners

• ps -ef | grep smon - List all running Oracle Databases

• ipcs | grep oracle - Semaphores and shared memory segments belonging to oracle
  Remove with ipcrm, but be carefull!!!

• ls -la . | awk '{total += $5}; END {print total}' - Prints the total size (in bytes) of all files in the current directory

• ls -laR . | awk '{total += $5}; END {print total/1024/1024 " Meg"}' - Prints the total size of files in the current directory and subdirectories below

• ls -laR | awk '{print $5 "t" $9}' | sort -n | tail - Find the largest files in dir and subdirecotry.
  

System Admin commands: