Re: about oracle listener

On May 1, 10: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 -

Port 1521 is the default port. Apparently Oracle disregards the listener name for port 1521.
As far as I know, even if you don't configure a listener on port 1521 explicitly, you will get a listener on port 1521. You can't do anything about that.
Also every database will register itself with any listener on port 1521.
We have a situation with one infrastructure database on port 1521 and one portal database on port 1541, in different Oracle_Homes, with different listeners. However, the latter database still registers itself with the listener on port 1521.
Needless to say which Corp set that system up. You can find it on Redwood shores!

If you don't want such features, do not use port 1521 and set up the local_listene parameter in init<sid>.ora to refer to the correct listener.

--
Sybrand Bakker
Senior Oracle DBA



--
Sybrand Bakker
Senior Oracle DBA