Hey Maheswar, If unix user wants lsnrctl services you can write a shell script like this read sid lsnrctl <<EOF>$HOME/lis (HOME is user's HOME directiory) stat lis_a EOF grep $sid $HOME/lis 0>/dev/null if [ $? -eq 0 ] then echo "YOUR SERVICE IS UP" fi Write this shell script and write a 'C' program that executes this shell and compile it and give execute permission of a.out to that user. Whenver he wants to check he'll give oracle_sid and a.out will give him his service is up or not Forgive mr if i am wrong Cheers Ganti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
