What Unix commands can one use when administrating a database?

Body: 

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:

Function: Sun: Sequent: HP-UX: AIX: SCO: Linux:-
Admin menu: admintool menu sam/ glance smit sysadmsh linuxconf
System Config: /usr/sbin/psrinfo -v showcfg -s ? /usr/sbin/prtconf hw ?
Trace system calls truss trace/trusstrace/ tusc /usr/bin/truss trace strace
Shared lib dependancies ldd? chatr /usr/bin/ldd ? ldd
Mount CD-Rom: non needed (automount)mount pfs_mount mount mount mount
System utilization prstat/ top top2 ? topas cpqmon top

Comments

The system utilization under AIX is topas...

AIX system admin commands:

System Config: /usr/sbin/prtconf
Trace system calls: /usr/bin/truss
Shared lib dependencies: /usr/bin/ldd

You may want to update your webpage.