Re: about oracle listener

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-Hide quoted text -
>
> > - 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