When you do a lsnrctl status is there anything different for the instance that isn't discovered and the ones that are?
-----Original Message----- Sent: Friday, October 18, 2002 9:39 AM To: Multiple recipients of list ORACLE-L 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@;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 <[EMAIL PROTECTED]>@fatcity.com on 10/17/2002 03:10:41 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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@;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: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
