Re: about oracle listener

On May 1, 4:50 pm, esthershe..._at_yahoo.com wrote:
> On May 1, 3:45 am, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On Apr 30, 10:34 pm, esthershe..._at_yahoo.com wrote:
>
> > > On Apr 24, 11:01 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
>
> > > > esthershe..._at_yahoo.com wrote:
> > > > > HI,
>
> > > > > I have a test environment on WindowsXP.
>
> > > > > I installed oracle server 10.2.0.1 and created one ORCL database. I
> > > > > started default listener and added another L1 listener (port is 1520 )
> > > > > by oracle net configuration assistant.
>
> > > > > the two listener started successfully. Just L1 listener started
> > > > > without any services.
>
> > > > > Then I try to use Database Configuration Assistant to create new
> > > > > database. when I tried to create the new database by clicking finish
> > > > > tab, I got error message.
>
> > > > > TNS-04404: no error caused by oracle.net.config.ConfigException:
> > > > > TNS-04414: File error caused by :
> > > > > TNS-04612: Null RHS for "srdmcsd"
>
> > > > > any suggestion is very appreciated. Thanks.
>
> > > > Most likely, you do not need two listeners. You can run two databases
> > > > just fine on the same server with one listener. Delete the second
> > > > listener and try again.
>
> > > > HTH,
> > > > Brian
>
> > > > --
> > > > ===================================================================
>
> > > > Brian Peasland
> > > > d...@nospam.peasland.nethttp://www.peasland.net
>
> > > > Remove the "nospam." from the email address to email me.
>
> > > > "I can give it to you cheap, quick, and good.
> > > > Now pick two out of the three" - Unknown
>
> > > > --
> > > > Posted via a free Usenet account fromhttp://www.teranews.com-Hidequotedtext -
>
> > > > - Show quoted text -
>
> > > Thanks for your reply.
>
> > > I tried only have one L1 listener ( on port 1521) on that machine, it
> > > seems no matter following two command, I got the same result.
>
> > > status L1
> > > status listener
>
> > > it seems as long as port is 1521, oracle think it is default listener
> > > no matter which listener name you granted.
> > > is that true?
>
> > > sorry if it make things confused..I just want to understand the
> > > listener concept.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Yes, that is true, at least on 9i.
> > I don't have a listener just called listener on port 1521 and when I
> > issue just lsnrctl stop, it works.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks. But is that mean the listener in oracle is not identified by
> name, is identified by some other internal number ?- Hide quoted text -
>
> - Show quoted text -

You can have as many listeners as you want to.

Most people prefer 1 listener even if supporting multiple different oracle homes ( preferences vary ).

When you "want to" have more than 1 listener you must make sure when you create them to use different names otherwise it gets very ugly and confusing.

The netca GUI will let you define and remove listeners.

You can use the lsnrctl utility to see what's going on ... lsnrctl status will show you status of the default listener named "listener" ... if you want status of a different one then do a lsnrctl status
name_of_other_listener_assuming_you_picked_a_different_name_for_the_second_one_etc ...

Having fun yet? Received on Tue May 01 2007 - 16:12:21 CDT