Re: Is there a better way to confirm whether Conc.Managers are up and running?
- From: Naqi Mirza <naqimirza@xxxxxxxxx>
- To: vikramsingh120@xxxxxxxxx, freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2007 00:35:11 -0700 (PDT)
Apart from sql, what about the form - administer concurrent manager - from the sysadmin responsibility ----- Original Message ---- From: vikram singh <vikramsingh120@xxxxxxxxx> To: freelists <oracle-l@xxxxxxxxxxxxx> Cc: ora-apps-dba-request@xxxxxxxxxxxxx Sent: Wednesday, 28 March, 2007 7:27:51 AM Subject: Is there a better way to confirm whether Conc.Managers are up and running? Hi, There is a need for a SQL that will report if all conc.managers are up and running. The SQL should gather information about which concurrent managers are enabled, whether the 'Actual' and 'Target' values match for that conc.manager, and if they do not it should be reported. We use a shell script now something similar to ---- ps -aef | grep FNDLIBR | grep `whoami` ---- The above script has a couple of limitations like: 1. It will show whether FNDLIBR process is alive or not, but it doesn't throw light whether all the enabled concurrent managers are up and running. 2. This shows the FNDLIBRs for that current user. But in one of our setups we have more than one application attached for a single 'applmgr' account. We only source env files to work on a particular application. i.e., we "su - applmgr" to the user, then we will source the env for either InstanceA or InstanceB depending on the need. This setup makes it difficult for us to use the above shell "ps -aef | grep FNDLIBR | grep `whoami`" script as this will not report the presence of conc.managers for a particular instance. Is there a better way i can track the Conc.Managers in the application? Is there a good SQL that captures all the relevant information and which can be used within a shell script to be run periodically? I am also open to any other idea that you may have to simplify the process. Don't you think there ought to be a better idea? There might be of which i may not be aware of. Please enlighten! Regards/Vikram. ___________________________________________________________ Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html
Other related posts:
- » Is there a better way to confirm whether Conc.Managers are up and running?
- » Re: Is there a better way to confirm whether Conc.Managers are up and running?
- » RE: Is there a better way to confirm whether Conc.Managers are up and running?