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.
;)
baby oil
ReplyDeletepan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
slippers
tire
egg
hat
cigarette
hangers
veil
strange people
crazy
dish rack
helmets
doll
shampoo
soap
bread
cake
cheese
chicken
bra
shorts
bag
book
scissors
knife
towel
cable
roof tile
flower
balm
light
car
scissors
ashtray
fan
stove
sheath
broom
duster
baby oil
pan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
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
ReplyDeletebottega veneta, ferragamo shoes, timberland boots, oakley, soccer jerseys, wedding dresses, herve leger, nike air max, chi flat iron, instyler, mcm handbags, lululemon, nike huarache, baseball bats, ralph lauren, hollister, asics running shoes, iphone cases, mac cosmetics, hollister, insanity workout, ipad cases, valentino shoes, iphone 6s cases, jimmy choo shoes, north face outlet, nfl jerseys, iphone 6 plus cases, iphone 6s plus cases, ghd, iphone 6 cases, babyliss, nike roshe, abercrombie and fitch, soccer shoes, celine handbags, north face outlet, giuseppe zanotti, nike trainers, louboutin, beats by dre, new balance, mont blanc, s5 cases, vans shoes, birkin bag, iphone 5s cases, longchamp, p90x workout, reebok shoes
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
ReplyDeleteralph lauren uk
ReplyDeletebabyliss pro
tiffany and co
lululemon outlet online
bottega veneta outlet online
michael kors uk
michael kors factory online
cheap oakley sunglasses
cheap oakley sunglasses
oakley sunglasses wholesale
ray-ban sunglasses
cheap ray ban sunglasses
ray-ban sunglasses
ray ban sunglasses
coach handbags outlet
coach outlet online
coach outlet store
coach outlet
coach outlet store
tory burch outlet online
tory burch outlet online
tory burch outlet
coach outlet store
ray ban sunglasses
christian louboutin shoes
cazal outlet
versace sunglasses on sale
louis vuitton sunglasses for women
dior outlet
gucci sunglasses uk
chrome hearts outlet
chrome hearts outlet online
police sunglasses for men
cartier sunglasses for men
cartier outlet store
lllllyuan20160601
chenlili20160627
ReplyDeletecoach factory outlet
coach outlet store online clearances
fitflops shoes
montblanc
hollister kids
adidas superstar
louis vuitton handbags
cheap toms
jordan retro 4
replica watches
kate spade outlet
cheap oakley sunglasses
coach factory outlet
tory burch shoes
toms outlet
jordan 6s
coach outlet store online
nike free run
coach factory outlet
michael kors handbags
adidas outlet store
michael kors handbags
jordan 3 retro
adidas originals
nfl jerseys
true religion jeans
instyler max
longchamp outlet
louis vuitton outlet stores
hollister outlet
air jordan 4
christian louboutin outlet
coach factory outlet online
jordan retro 13
air jordan shoes
toms shoes
asics shoes
air jordan 8
michael 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
20160914 junda
ReplyDeletechaussure louboutin
coach outlet
uggs outlet
celine outlet
polo ralph lauren
toms shoes
ugg boots
juicy couture outlet
prada outlet
ralph lauren pas cher
lebron james shoes
louis vuitton
nike blazer pas cher
true religion outlet
michael kors handbags clearance
tory burch outlet
swarovski crystal
chicago blackhawks
nike roshe
mulberry handbags
coach outlet online
fitflops sale
links of london
longchamp handbag
oakley sunglasses
nike air force 1
louis vuitton
cheap snapbacks
polo ralph lauren
longchamp handbags
louis vuitton outlet
ysl outlet
coach outlet
michael kors handbags
ugg boots
michael kors outlet
true religion uk
lacoste polo shirts
mizuno running shoes
coach outlet
north face
ReplyDeletedolphins jerseys
los angeles lakers
nike huarache
christian louboutin shoes
red valentino
los angeles lakers jerseys
ray bans
nike trainers
ralph lauren
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/شركة-تنظيف-مكيفات-بالرياض/