Re: Intelligent agent & OEM problem

Hi Gordon,

A reply from a fellow victim, I spent a good deal of this working day with resolving OEM problems, though not this one. I have a feeling though were the problem is. You are missing out a section in your tnsnames.ora (I'm not sure this variant of tnsnames.ora is to be located on both the database server and the OEM console). Here is - from memory- what I have extra in tnsnames.ora on the OEM console

agent_somenode.ad.klm.nl =
(address = (host = somenode.ad.klm.nl)(protocol=tcp)(port=1748))

The port number MUST be 1748, it's hardcoded and has been assigned to Oracle by IANA. Using Oracle Daemon Manager in the OEM console you should now be able to ping the intelligent agent and retry the service discovery.

In the recent past I had to sort out many OEM problems, there is much information in the OEM forum on www.oracle.com/support, there even is a separate document of the top 21 problems with OEM. My and probably your question is: If so many people all have the same problems why are they not been addressed properly by Oracle? OK, a few only are real bugs, and if it's doing what it is supposed to do, it is a tremendous product, how come the software seems to be either unstable or too difficult to configure?

Hth,

Sybrand Bakker, Oracle DBA

cyril.gordon_at_usa.net wrote:

> Dear experts,
>
> New service discovery in Oracle Ent. Manager 1.5.0 fails to find my
> Oracle 8.0.4 on Solaris 2.5.1 instance. Listener on Solaris is started
> and I can connect from my workstation using SQLPlus, I even can connect to
> the OEM repository. However, the intelligent agent seems to not work properly.
> I use lsnrctl dbsnmp_start and it starts with no error messages. dbsnmp
> creates snmp_ro.ora and snmp_rw.ora files and information in them is correct,
> I think. File services.ora looks good too. Still, OEM always fails to
> discover this node. It can discover nodes running NT. I have no clue where to
> look next, I've tried a lot. Oracle support is not too helpfull.
> I am quoting my Net8 files in a desperate hope that you might know more then
> Oracle support does. Please send me e-mail with your ideas!
>
> Thanks a megabyte!
>
> Cyril Gordon
>
> sqlnet.ora
> -----------
>
> AUTOMATIC_IPC = ON
> TRACE_LEVEL_CLIENT = OFF
> SQLNET.EXPIRE_TIME = 0
> NAMES.DEFAULT_DOMAIN = world
> name.default_zone = world
> SQLNET.AUTHENTICATION_SERVICES = (none)
>
> tnsnames.ora
> ------------
>
> OEM.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL=TCP)(Host=moby)(Port=1525))
> )
> ( CONNECT_DATA = (SID=OEM)(GLOBAL_NAME=OEM.world) )
> )
>
> listener.ora
> ------------
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= TCP)(Host= moby)(Port= 1525))
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = OEM)
> (ORACLE_HOME= /u01/app/oracle/product/8.0.4)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
>
> snmp_ro.ora
> -----------
>
> snmp.visibleservices = (LISTENER, OEM.world) snmp.shortname.LISTENER =
> LISTENER snmp.longname.LISTENER = LISTENER_moby snmp.configfile.LISTENER =
> /var/opt/oracle/listener.ora snmp.SID.OEM.world = OEM
> snmp.oraclehome.OEM.world = /u01/app/oracle/product/8.0.4
> snmp.address.OEM.world = (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
> (PROTOCOL=TCP) (Host=moby)(Port=1525)))( CONNECT_DATA =
> (SID=OEM)(GLOBAL_NAME=OEM.world) )) ifile = /var/opt/oracle/snmp_rw.ora
>
> snmp_rw.ora
> -----------
>
> snmp.contact.LISTENER = ""
> snmp.index.LISTENER = 1
> snmp.contact.moby = ""
> snmp.index.moby = 2
>
> services.ora
> ------------
>
> LISTENER_moby = (ORACLE_LISTENER, moby, (ADDRESS_LIST =(ADDRESS= (PROTOCOL=
> TCP) (Host= moby)(Port= 1525))))
>
> OEM.world = (ORACLE_DATABASE, moby, (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
> (PROTOCOL=TCP)(Host=moby)(Port=1525)))( CONNECT_DATA = (SID=OEM)
> (GLOBAL_NAME=OEM.world) )), LISTENER_moby)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 29 1998 - 12:03:49 CST