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" <[EMAIL PROTECTED]> 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@;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: Timothy Boles 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).