topic Re: Orlacle Listeners and Service Guard in Operating System - HP-UX

Orlacle Listeners and Service Guard

MikeL_4 — Tue, 02 May 2006 12:16:13 GMT

When we start our Oracle Databases and Listeners all of the databases start but only the first listener starts, all others give message that listener was already started.

I've attached a copy of the scripts that starts the databases and listeners, not being a DBA I'm not sure why they aren't starting.

Re: Orlacle Listeners and Service Guard

Jeff_Traigle — Tue, 02 May 2006 12:32:57 GMT

I may be showing my ignorance of how Oracle does things now, but, back in the 7.X and 8.X days, only one listener ran. You configured it via listener.ora so it knew which database instances it was supposed to listen for. If that's still the case, for your control script, you'd take the listener startup and move it outside the for loop.

Re: Orlacle Listeners and Service Guard

MikeL_4 — Tue, 02 May 2006 12:45:23 GMT

I'm not a DBA but I know they started up the others and we have multiple Listeners running:
ps -ef | grep tnslsnr |grep -v grep
oracle 1440 1 0 Apr 30 ? 0:06 /u01/oracle/product/9.2.0/bin/tnslsnr listener_esgwyp -inherit
oracle 1375 1 0 Apr 30 ? 0:06 /u01/oracle/product/9.2.0/bin/tnslsnr listener_vogwyp -inherit
oracle 102 1 0 Apr 30 ? 1:21 /u01/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit
oracle 1426 1 0 Apr 30 ? 0:05 /u01/oracle/product/9.2.0/bin/tnslsnr listener_spgwyp -inherit
oracle 1400 1 0 Apr 30 ? 0:09 /u01/oracle/product/9.2.0/bin/tnslsnr listener_dsngwyp -inherit

Re: Orlacle Listeners and Service Guard

Kent Ostby — Tue, 02 May 2006 13:16:56 GMT

The problem that I see is that you don't ever change the value of LISTENER so after you start the first one, the following check is run:

if [ "`lsnrctl status $LISTENER | grep -i 'NO listener'`" != "" ]

FAILS because you already started $LISTENER

So you drop here:

else
_LogMsg "(OL_startListener): Listener is already started."
##_LogMsg "(OL_startListener): Listener for \"$ORACLE_SID\" is already started."
return 0

Re: Orlacle Listeners and Service Guard

Carles Viaplana — Wed, 10 May 2006 03:07:50 GMT

Hello Mike,

I assume you have just 1 oracle installed with some databases running.

If I'm right, to start listener once for all databases is enough.

listener is just the Oracle's ear and into listener.ora file (check $ORACLE_HOME/network/admin/) there're all Oracle databases.

Have you tried to execute lsnrctl start just once?

Regards,

Carles

Re: Orlacle Listeners and Service Guard

MikeL_4 — Wed, 10 May 2006 06:40:31 GMT

Thanks