RE: Auto Start listener

Hi,  

    I start my listener in the same script where I start the database and it is run in the boot process. Why would there be a problem? The part of my script that does it is below:  

lsnrctl start lsn_SNWR
sleep 3
proccnt=`ps -fu oracle | grep -v grep | grep -c 'tnslsnr lsn_SNWR'` if [ $proccnt -eq 1 ]
then

    echo "Oracle listener started successfully" else

    echo "Oracle listener did not come up. Contact DBMG." fi  

Bill

-----Original Message-----
From: Don Dealy II [mailto:dondealy_at_teleport.com] Sent: Thursday, August 17, 2000 10:48 AM To: Multiple recipients of list ORACLE-L Subject: Auto Start listener

Oracle install docs fully discuss the issue of init.d / rcx.d startup of the db on UNIX. However, there is total silence on the startup of the listener. In chatting with Oracle tech support, they claim that starting / stopping the listener during reboot is not support.  

Well, I say "hogwash".  

Does anybody have Unix scripts that they would share which will run from rcx.d, to start the listener. I'd like the script to check that at least one db is up and running before trying to start the listener.  

another script I'd like is some kind of check script that would run in a loop, waking up now and then to be sure that the listener is still running. Received on Thu Aug 17 2000 - 12:59:05 CDT