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

From: Evan <eehrenh_at_emory.edu>
Date: Wed, 27 Sep 2006 10:56:20 -0400
Message-ID: <451A9114.7090008@emory.edu>

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?

Thanks again,

Evan Received on Wed Sep 27 2006 - 09:56:20 CDT