linux cmd

Location of arch files in prod
cd /data/ERPP_dbarch1/database/ERPP/arch
Location of arch files in test
 cd /test/ERPP_dbarch2/database/ERPP/arch/


count of number of files

ls -l *.arc |wc -l

find files that are more than 90 days
count the size of specic files find *.arc -mtime +90
du -c -h *.arc

zip the files
gzip *.arc


ls - lrth

tail  -100f


crontab -l

free -m
cat /proc/meminfo
top -c

vmstat


strings -a $AU_TOP/forms/US/sachin_test.fmb | grep '$Header

find . -name file name

locate exact_file_name

df -h

VIEW ORACLE INSTANCE ON LINUX
ps -ef|grep pmon
echo $ORACLE_SID
export Oracle_SID=TEST

calling sqlplus in testora

. /test/TEST/testdb/tech_st/11.1.0/TEST_finprod10.env
which located in start_oratest

Kill process
cd /data/ERPP/erppdb/tech_st/11.1.0/admin/ERPP_finprod10/diag/rdbms/erpp/ERPP/trace
tail -100f  alert.log view log
/test/TEST/testdb/tech_st/11.1.0/admin/TEST_finprod10/diag/rdbms/test/TEST/trace

list oracle process
ps -ef |grep LOCAL=NO ps -ef|grep FNDLBR

command is to see oracle instance process on linux server
ps- ef | grep pmon
export ORACLE_SID=orcl

ps -ef|grep testora|grep LOCAL=NO
kill -9 PID kill pid no

kill all proesses
kill -9 ps -ef|grep LOCAL=NO|grep INSTANCE NAME|awk ‘{print $2}’`


remove files from weekly retention

on month basis

List of file in Jul Month
ls -lrth *201207*

Total size of files in Jul Month
du -c -h *201207*

Remove files in Jul Month
rm -f *201207*

rm -f *20120701*

`