Unix/Linux commands for Oracle Apps DBA

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Scripts
About Me   
 
 
My Favourites

Scripts to find patch Info

Health Check 11i

11i Interview Q's

Apps JVM

Metalink Notes

Component Versions

Important Tables

Profile Options

 
     

Thanks to Sam for sharing below Unix commands with Us. If you also like to Share anything on this Site Mail Me

 

How to find the symbolic links that point to the old path in your oracle_home and appl_top.

This command is useful in cloning after restore from source to target that symbolic link are not pointing to source.

ls -al `find . -type l` | grep $OLD_PATH

 

To find all the text files that contains the old path at the UNIX level.

find . -type f -print|grep -v ":"|xargs file|grep "text"|awk '{FS=":"}{print $1}'|xargs grep -il $OLD_PATH

 

How to Sort files based on Size of file in a Directory
Useful in finding out spaces issues

ls -l | sort -nrk 5 | more

 

How to check if a Port is listening for any Service

netstat -an | grep $PORTNO

     

How to schedule a Job in Unix

Use cronjob
crontab -l ( list current jobs in cron)
crontab -e ( edit current jobs in cron )
_1_ _2_ _3_ _4_ _5_ $Job_Name
1 - Minutes (0-59)
2 - Hours ( 0-24)
3 - day of month ( 1- 31 )
4 - Month ( 1-12)
5 - A day of week ( 0- 6 ) 0 -> sunday 1-> monday
e.g. 0 0 1 * 5 Means run job at Midnight on 1st of month & every friday

 
Previous Page
   
 
Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal