Unix and Oracle

Find Out Invalid Database Objects The following finds out invalid database objects: #####################################################################          ## invalid_object_alert.sh ## #####################################################################  … Read more

Check Tablespace Usage This scripts checks for tablespace usage. If tablespace is 10 percent free,  it will send an alert e-mail. ##################################################################### ## ck_tbsp.sh ## ###############################################… Read more

Analyze Tables and Indexes (for Better Performance)   Below, I have shown an example on how to pass parameters to a script: #################################################################### ## analyze_table.sh ## ##############################################… Read more

Clean Up Old Archived Logs The following script cleans up old archive logs if the log file system  reaches 90-percent capacity: $ df -k | grep arch Filesystem                kbytes   used     avail    capacity  Mounted on /dev/vx/dsk/proddg/archive 71123968 302102… Read more

Check Alert Logs (ORA-XXXXX) Some of the environment variables used by each script can be put into one  profile: ####################################################################### ## oracle.profile ## ##########################################################… Read more

Check Oracle Listener's Availability   A similar script checks for the Oracle listener. If the listener is down, the  script will restart the listener: ####################################################################### ## cklsnr.sh                      … Read more

Check Oracle Instance Availability The oratab file lists all the databases on a server: $ cat /var/opt/oracle/oratab ################################################################### ## /var/opt/oracle/oratab                                        ## ##########… Read more

UNIX Basics for the DBA   UNIX Basics for the DBA Basic UNIX Command The following is a list of commonly used Unix command: ps - Show process grep - Search files for text patterns mailx - Read or send mail cat - Join files or display them cut - Select col… Read more

click below link--------------- http://www.oracle.com/technetwork/articles/linux/saternos-scripting-088882.html Read more

How to run SQL in shell script   #!/bin/ksh variable1 = $ ( echo "set feed off set pages 0 select count(*) from table; exit " | sqlplus - s username / password@oracle_instance ) echo "found count = $variable1"   -----------------------… Read more

Count Number of Files in a Directory open link ............... http://www.shellhacks.com/en/HowTo-Count-Number-of-Files-in-a-Directory Read more

Count files and directories using shell script open link ............... http://stackoverflow.com/questions/13727069/count-files-and-directories-using-shell-script Read more

Top DBA Shell Scripts for Monitoring the Database open below link ............................................ https://communities.bmc.com/docs/DOC-9942 Read more

open below link............. http://www.dbanotes.com/general/basic-unix-commands-for-the-dba/ Read more

open below link............... http://www.thegeekstuff.com/2010/11/50-linux-commands/ Read more

Please open below link.................... http://www.orafaq.com/faq/what_unix_commands_can_one_use_when_administrating_a_database Read more

please open below link ...................... http://oracle-base.com/articles/misc/unix-for-dbas.php Read more

'please open below link .......................... https://www.linkedin.com/grp/post/83332-5920854215424491520 Read more

open and read.... https://www.youtube.com/watch?v=HTB96gQ5uM0 Read more