| susk |
Posted: Mar 27, 2008 02:32:07 AM |
Total Post: 7
Joined: Jan, 2008
|
friends
plz help ....
how to get count of no of databases running at oracle server ?
& which are active/running
THnx
|
|
|
Murtuja |
| Posted: Mar 27, 2008 05:45:43 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
you can list out all databases running on that server from oratab file.
generally it located in /vat/opt/oracle folder.
you can find out oratab by this command
find / -name oratab
|
|
|
|
|
Gitesh |
| Posted: Mar 28, 2008 01:51:19 AM | |
|
Total Post: 322
Joined: May, 2005
|
In unix execute following commands.
ps -ef|grep smon|grep -v grep|wc -l
|
|
|
|
|
nettfrnd |
| Posted: Apr 02, 2008 06:28:23 AM | |
|
Total Post: 1
Joined: Mar, 2008
|
Please let me know how to do this on Windows Server OS having Oracle 10G Database....
Thanks,
Waheed.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |