Reason:
After DB consolidation on one host it is hard to remember how many $ORACLE_HOME and home many databases under each oracle home.
You can find some other scripts in Internet and Oracle written script also, but I prefer my script because output is simple for understanding.
After DB consolidation on one host it is hard to remember how many $ORACLE_HOME and home many databases under each oracle home.
How quickly to identify which Oracle process runs out of which $ORACLE_HOME on Linux(put this script to findhomes_bibo.sh file and execute chmod +x findhomes_bibo.sh)
echo -e "\033[1mDB_NAME\t\tORACLE_HOME\033[0m"
for ora in $(pgrep -lf _pmon_ | awk '{print $1}'); do for pid in $(pgrep -lf _pmon_ | grep $ora | awk '{print $2}' | cut -d_ -f 3); \
do echo -n $pid; done && ls -l /proc/$ora/exe | awk -F'>' '{ print $2 }' | sed 's/bin\/oracle$//'; done | sort -k2,2 | sed 's/\s/\'$'\t\t''/g'
for ora in $(pgrep -lf _pmon_ | awk '{print $1}'); do for pid in $(pgrep -lf _pmon_ | grep $ora | awk '{print $2}' | cut -d_ -f 3); \
do echo -n $pid; done && ls -l /proc/$ora/exe | awk -F'>' '{ print $2 }' | sed 's/bin\/oracle$//'; done | sort -k2,2 | sed 's/\s/\'$'\t\t''/g'
You can find some other scripts in Internet and Oracle written script also, but I prefer my script because output is simple for understanding.
cat /etc/oratab
ReplyDeletethis working if DBA is not lazy to enter 1 row in expected format if DB created manually or cloned. If created by DBCA - row will be already there.
;)
tory burch outlet, nike air max, uggs on sale, longchamp, nike air max, ray ban sunglasses, tiffany and co, tiffany jewelry, oakley sunglasses, louis vuitton, ugg boots, oakley sunglasses, ugg boots, louboutin outlet, ray ban sunglasses, prada handbags, michael kors, burberry, oakley sunglasses, nike outlet, louis vuitton outlet, louis vuitton, replica watches, michael kors outlet, michael kors outlet, michael kors outlet, nike free, kate spade outlet, chanel handbags, oakley sunglasses, longchamp outlet, longchamp outlet, polo ralph lauren outlet, replica watches, burberry outlet online, prada outlet, ugg boots, louis vuitton, gucci outlet, louboutin, michael kors outlet, louis vuitton outlet, jordan shoes, ugg boots
ReplyDeletelacoste pas cher, nike air max, vans pas cher, replica handbags, mulberry, michael kors, true religion jeans, air jordan pas cher, north face, air max, ralph lauren uk, oakley pas cher, coach outlet, north face, louboutin pas cher, tn pas cher, sac guess, michael kors, coach purses, nike roshe run, hogan, coach outlet, nike free run uk, sac longchamp, hermes, ray ban pas cher, hollister pas cher, kate spade handbags, nike free, vanessa bruno, timberland, nike air max, michael kors, ray ban uk, lululemon, ralph lauren pas cher, burberry, hollister, nike blazer, michael kors, true religion outlet, longchamp pas cher, nike roshe, true religion jeans, new balance pas cher, air force, converse pas cher, nike air max, abercrombie and fitch, true religion jeans
ReplyDeletemoncler, juicy couture outlet, thomas sabo, swarovski crystal, barbour jackets, canada goose outlet, karen millen, canada goose, replica watches, pandora jewelry, ugg,ugg australia,ugg italia, vans, marc jacobs, louis vuitton, louis vuitton, supra shoes, moncler, canada goose, barbour, bottes ugg, ugg pas cher, doudoune canada goose, links of london, moncler, ray ban, louis vuitton, coach outlet, converse outlet, moncler, montre pas cher, sac louis vuitton pas cher, hollister, moncler, lancel, canada goose outlet, pandora charms, louis vuitton, canada goose uk, hollister, moncler outlet, canada goose, doke gabbana outlet, ugg,uggs,uggs canada, pandora jewelry, moncler, moncler, gucci, ugg boots uk, juicy couture outlet, pandora charms, converse, swarovski, wedding dresses
ReplyDeletemichael kors outlet clearance
ReplyDeletenhl jerseys wholesale
true religion jeans outlet
coach outlet store
cheap nfl jerseys
pandora charms
wholesale nike shoes
nike air force black
michael kors outlet clearance
nike tn
louis vuitton borse
running shoes
fitflops shoes
michael kors outlet
nba jerseys wholesale
adidas pure boost
michael kors handbags outlet
louis vuitton purse
oakley sunglasses
yeezy boost 350
jordan pas cher
asics gel nimbus
nike store uk
yeezy boost 350 white
rolex submariner
coach outlet store online
oakley sunglasses
ray ban sunglasses
true religion uk
rolex watches uk
michael kors handbags outlet
polo ralph lauren
201678yuanyuan
michael kors uk
ReplyDeletemulberry purse
nike store
christian louboutin shoes
coach outlet
nike blazer low
ralph lauren outlet
michael kors outlet
mulberry handbags
ralph lauren
20170223caiyan
jordans for cheap
ReplyDeletemichael kors outlet
kyrie irving shoes
adidas neo
adidas superstar shoes
skechers shoes
longchamp le pliage
kobe 9
yeezy shoes
michael kors handbags
This article is interesting and useful. Thank you for sharing. And let me share an article about health that God willing will be very useful. Thank you :)
ReplyDeleteCara Mengobati Panu
Obat Penghenti Batuk Berdarah
Biaya dan Efek Samping Operasi Kista Bartholin
Penyebab dan cara Mengatasi jantung Berdebar
Cara Mengobati Pengapuran Tulang
Obat Pengapuran Otak pada Anak
ReplyDeleteافضل شركة تنظيف
https://www.alraid-sa.com/تنظيف-منازل-بجدة/
https://www.alraid-sa.com/شركة-تركيب-مكيفات-بالرياض/
https://www.alraid-sa.com/شركة-تنظيف-مكيفات-بالرياض/