RE: OEM can't seem to discover 1 instance

Er, what I meant to say in my last email is to delete the node from OEM and
then rediscover all of the databases on it fresh.

Mike

>From: John Weatherman <john.weatherman_at_replacements.com>>Reply-To: ORACLE-L_at_fatcity.com>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>>Subject: RE: OEM can't seem to discover 1 instance>Date: Fri, 18 Oct 2002 05:38:37 -0800>>Hmm, thanks to all who are replying. It looks like the instance is not>making>it into either snmp_rw.ora, snmp_ro.ora or the services.ora. I have>manually>edited them, but when I restart the agent, it wipes out the manual entries>in>the snmp_ro.ora and the services.ora.>>The oratab and listener look fine.>>Any more good advice?>>TIA,>>John P Weatherman>Database Administrator>Replacements Ltd.>>>>-----Original Message----->[mailto:Reginald.W.Bailey_at_jpmorgan.com]>Sent: Friday, October 18, 2002 5:14 AM>To: Multiple recipients of list ORACLE-L>>>>The instance should be listed in the oratab file, the listener.ora file and>the snmp_rw.ora file. It is automatically added to the snmp_ro.ora file at>agent start up.>Ensure that the Intelligent Agent is running. If any changes need to be>made to any of the previously mentioned files, stop and restart the agent>after making the change.> Then try to discover the node.>>Reginald W. Bailey>DBA, Consultant and MOKF>>>>>John Weatherman <john.weatherman_at_replacements.com>@fatcity.com on>10/17/2002 03:10:41 PM>>Please respond to ORACLE-L_at_fatcity.com>>>>Sent by: root_at_fatcity.com>>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>>cc:>>>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:> INET: Reginald.W.Bailey_at_jpmorgan.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: Mike Killough
INET: mwkillough_at_hotmail.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).