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

On Wed, 27 Sep 2006 10:56:20 -0400, Evan <eehrenh_at_emory.edu> 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?
>
>Thanks again,
>
>Evan

Don't see anything wrong, though I remember a note on Metalink you shouldn't use both global_dbname and sid_name. The former will take precedence.
You should find $ORACLE_HOME/network/log/nmiconf.log and read that to find a full transcript of the discovery session.

If you don't want to use isql*plus to that box, you don't need Apache. Isql*plus requires Apache on the database server.

Hth

--
Sybrand Bakker, Senior Oracle DBA