Re: OEM can't seem to discover 1 instance

I believe that it needs to be in oratab, listener.ora, and services.ora

The services.ora is the one that gave me problems last week.

Tim Boles
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 17, 2002 1:10 PM

> Anybody seen anything like this? I am running 9.2.0.1 OEM auto discovery.
> The Intelligent Agent is running on the target node. For some reason, it
> seems unable to discover 1 instance, the other 3 on that node are found.
> TNS seems ok, I can connect to the instance from other boxes without any
> difficulty. I have removed the snmp_ro.ora and recycled the IA,
Management
> Server, etc. Still can't find this instance. It is finding 9i (r1 and
r2)
> instances. This is an 8i instance (8.1.7.4) but I don't think that's it,
> as the development version on another node is found just fine.
>
> TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -----Original Message-----
> Sent: Thursday, October 17, 2002 2:47 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Yes, there is. You might notice that someone has issued a
> "create database" command because all of your data will be
> gone fishing. When the noise level reaches 500 decibels,
> someone has issued "CREATE DATABASE" command on your production
> database, which, of course, no longer exists.
> System accounting should be able to tell you who has logged in as
> "oracle" and from which PC. Then you go and publicly execute that
> person by beating him to the pulp with a baseball bat (so called "Soprano
> method")
>
> > -----Original Message-----
> > From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
> > Sent: Thursday, October 17, 2002 12:42 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: auditing CREATE DATABASE
> >
> >
> > Is there a way of capturing info on people who issue CREATE DATABASE
> > statements?
> >
> > My Oracle Support technician says auditing won't catch this,
> > only catches
> > successful attempts.
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > Technology Services | Services technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO | Région des Maritimes, MPO
> >
> > E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Boivin, Patrice J
> > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: john.weatherman_at_replacements.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Timothy Boles
  INET: timboles_at_citynet.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).