Home » RDBMS Server » Server Administration » dbstart/dbstop named listener (oracle 11.2 0.2 solaris 2.10)
dbstart/dbstop named listener [message #561993] Thu, 26 July 2012 12:19 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I have listeners that are setup like LSNR_$ORACLE_SID.


LSNR_T1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1651))
      )
    )
  )

..
...



While reviwing dbstart/dbshut I see that ORACLE does not
take in a name for the listener. Therefore my lister will
not stop/start automatically.

Is anybody else setup like this and what did you do to overcome
this problem, modify the standard dbstart/dbstop scripts?




# Stop Oracle Net Listener
  if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
    echo "$0: Stoping Oracle Net Listener" >> $LOG 2>&1
    $ORACLE_HOME_LISTNER/bin/lsnrctl stop  >> $LOG 2>&1 &
  else
    echo "Failed to auto-stop Oracle Net Listener using $ORACLE_HOME_LISTNER/bin/tnslsnr"
  fi

#
# Would need a line like this to make it work
#
# $ORACLE_HOME_LISTNER/bin/lsnrctl stop [b][i][u]T1[/u][/i][/b] >> $LOG 2>&1 &



Re: dbstart/dbstop named listener [message #561994 is a reply to message #561993] Thu, 26 July 2012 12:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59408
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
modify the standard dbstart/dbstop scripts?


Yes.

Regards
Michel
Re: dbstart/dbstop named listener [message #561995 is a reply to message #561993] Thu, 26 July 2012 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
only ONE listener is needed to support as many instances, in many ORACLE_HOME & even multiple IP#s & ports.

what is rationalization for having more than ONE listener?
Re: dbstart/dbstop named listener [message #561998 is a reply to message #561995] Thu, 26 July 2012 13:07 Go to previous messageGo to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I agree with you 100% that is how I usually set things up. This ENV was setup already and I was trying to find the path of least resistance.

Instead of hacking Oracle default scripts, I will just change the lister name to the default (LISTENER) and everything will fall into place nicely.
Re: dbstart/dbstop named listener [message #562015 is a reply to message #561998] Fri, 27 July 2012 01:05 Go to previous message
Michel Cadot
Messages: 59408
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I will just change the lister name to the default (LISTENER)


It is not a good thing from security point of view to keep things to their default value.
It is better to modify (or copy and modify) Oracle scripts which are, in this case, just examples just like the listener.ora or tnsnames.ora files they provide (and you modified).

Regards
Michel
Previous Topic: can not audit entry in adump
Next Topic: How can use the LV to create a ASM disk
Goto Forum:
  


Current Time: Tue Oct 21 10:35:43 CDT 2014

Total time taken to generate the page: 0.08982 seconds