Basic Unix

To grep from alert log file:

grep -in ORA-1652 -B1 -A1  /alert_TEST.log | tail -20

To view port :

netstat -anlp|grep -i 3667(process id)
netstat -an|grep -i <port no>

find:

find -name "*.tr?" -mmin +120 -exec ls -lrt {} \;
find -name "*.tr?" -mmin +120 -exec gzip -f {} \;

find -name "*.tr?" -mtime +2 -exec ls -lrt {} \;
find -name "*.tr?" -mtime +2 -exec gzip -f {} \;

find *csv* -mtime +364 -exec mv  {} /interface/PPR/D201A/archive/csv_backup \;


cron commect:

crontab -l|awk '{ if(match($0,"P100A") == 0) {print $0} else {print "###Q1FY16_TS3_Refresh_P100A_contact_mdmraza##_#"$0}}' |crontab

cd /opt/oracle/pr/orapps/P100A/
tar cvzf /share/orapp/P100A/P100A_APPL_$DATE_STAMP.tar.gz appl common ora oraInventory
tar cvzf /share/orapp/P100A/P100A_CUSTOM_$DATE_STAMP.tar.gz CUSTOM