Re: Node discovery issue on 9.2.0.6. My node is not discovering correctly.

Evan wrote:
> Sybrand Bakker wrote:
> > On Tue, 26 Sep 2006 17:57:25 -0400, Evan <eehrenh_at_emory.edu> wrote:
> >
> >
> >>Node discovery issue on 9.2.0.6. My node is not discovering correctly.
> >>
> >>Please review the stuff below and let me know if you see any errors (in
> >>typing or thought).
> >
> > Can't see whether the instance is defined in LISTENER.ORA in the
> > SID_LIST_LISTENER section using the SID= mechanism.
> >
> > Oracle comes with Apache. If you deinstall Apache you end up with a
> > crippled OEM.
> > So yes this server MUST have Apache.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
> Sybrand,
>
> Thanks for the response.
>
> = = = Listener:
> The listener has some historic entries which we can't remove.
> It looks like this:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = fortuna.cc.emory.edu)(PORT =
> 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = fortuna.cc.emory.edu)(PORT =
> 1526))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = FMPROD.WORLD))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = FMPROD))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = FMPROD.CC.EMORY.EDU))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/920)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = FMPROD.CC.EMORY.EDU)
> (ORACLE_HOME = /u01/app/oracle/product/920)
> (SID_NAME = FMPROD)
> )
> )
>
> = = = Apache:
> This machine is only used for the database. OEM is only present in the
> sense of the Intellegent Agent. Our OEM (9i) and Grid/EM (10g) servers
> are on another box.
>
> Is there any reason to leave the apache stuff on this box

If you can't modify this listener.ora, use a second listener just for the intelligent agent. Use no SID_DESC's in it so it can use the discovery process.

jg

-- 
@home.com is bogus.
sync;sync;sync;