Re: Oracle 10g kills 8i listener

Hello Howard,

   Why don't you concentrate on technical advice.

   Otherwise you just ridicule yourself by clinging to the words (not to the meaning) which can be interpreted either way (as you did with all my other posts),

  If you'd check metalink (if you have access to it), you'd find out that this is exact recommendation made by oracle.

  If I am guilty of providing the same advice that Oracle does - so be it.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:402ec281$0$28870$afc38c87_at_news.optusnet.com.au...
>
> "Xuequn Xu" <xux_at_informa.bio.caltech.edu> wrote in message
> news:c0ka6g$cke$1_at_naig.caltech.edu...
> > More specifically, the local_listener parameter needs to be set
> > to a tnsname alias (defined in tnsnames.ora) that resolves to
> > the listener that listens to that different port - read my
> > original post :-).
>
>
> Don't worry about it. Ron 'knows the Oracle code base' well, having been a
> DBA for 15 years -according to himself at any rate. The fact that he
thinks
> local_listener actually *disables* instance registration is however just
> another example of the muddle-headed nonsense he's been spouting for the
> past few days, and proof-positive that he wouldn't know a bit of Oracle
code
> if it came up and hit him in the face. Your original post was technically
> enlightening and said all that needed to be said -so, thanks again for it.
>
> Regards
> HJR
> --
> --------------------------------------------
> Oracle Insights: www.dizwell.com
> --------------------------------------------
>
>
>
>
>
>
> > Ron (support_at_dbainfopower.com) wrote:
> >
> > : Hello Xu,
> >
> > : I believe you can to disable automatic 10g service registration.
> >
> > : To do this, you must set the init.ora parameter local_listener to
use
> a
> > : TCP port other than the one defined in your listener.ora file.
> >
> > : Regards,
> >
> > : Ron
> > : DBA Infopower
> > : http://www.dbainfopower.com
> > : Standard disclaimer:
> > : http://www.dbainfopower.com/dbaip_advice_disclaimer.html
> >
> >
> >
> >
> >
> > : "Xuequn Xu" <xux_at_informa.bio.caltech.edu> wrote in message
> > : news:c0jff3$3sv$1_at_naig.caltech.edu...
> > : > Just want to share some intersting experience and observations:
> > : >
> > : > I installed Oracle 10g on Solaris 5.8, and on the same box there is
> > : > another Oracle 8i instance installed and running, with a separate
> > : > ORACLE_HOME (8.1.7.4). I found that the moment I startup the 10g
> instance
> > : > the 8i listener stopped responding. Further testing showed that this
> > : > only happens when the 10g database is about to open (i.e. startup
> nomount
> > : > and startup mount does NOT make this happen). The 8i listener is
> running
> > : > at port 1521. This must be that the 10g instance cannot do service
> > : > registration with an 8i listener. Had to resolve this by running
10g's
> > : > own listener at another port (in my case 1526), and specify the
> > : > LOCAL_LISTENER parameter in 10g, pointing to a tnsnames.ora entry
> > : > that resolves the new listener.
> > : >
> >
> >
>
>
Received on Sat Feb 14 2004 - 19:48:22 CST