Re: Oracle 10g kills 8i listener

"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.

> : >

>

>