Operating System - HP-UX
1833772 Members
2345 Online
110063 Solutions
New Discussion

Re: Orlacle Listeners and Service Guard

 
MikeL_4
Super Advisor

Orlacle Listeners and Service Guard

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.
5 REPLIES 5
Jeff_Traigle
Honored Contributor

Re: Orlacle Listeners and Service Guard

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.
--
Jeff Traigle
MikeL_4
Super Advisor

Re: Orlacle Listeners and Service Guard

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
Kent Ostby
Honored Contributor

Re: Orlacle Listeners and Service Guard

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
"Well, actually, she is a rocket scientist" -- Steve Martin in "Roxanne"
Carles Viaplana
Valued Contributor

Re: Orlacle Listeners and Service Guard

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
MikeL_4
Super Advisor

Re: Orlacle Listeners and Service Guard

Thanks