RE: OEM can't seem to discover 1 instance

John I had the same issue recently where before the same instance had been discovered. I had deleted the node after having removed one instance from the server. Before it discovered all three and now it discovers only one of two. Go figure. I have temporarily resorted to a manual configuration for this instance for the time being.

-----Original Message-----
Sent: Thursday, October 17, 2002 5:14 PM To: Multiple recipients of list ORACLE-L

It is in the oratab. I have cycled several times....

John P Weatherman
Database Administrator
Replacements Ltd.

-----Original Message-----
Sent: Thursday, October 17, 2002 4:50 PM To: Multiple recipients of list ORACLE-L

Are there entries in your oratab for this instance? After adding this entry, if not there, recycle the IA and try again.

Phil Wilson (phil_wilson_at_smartforce.com) DBA, Operations Group
SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w)
506.447.0334(c)

-----Original Message-----
Sent: Thursday, October 17, 2002 5:11 PM To: Multiple recipients of list ORACLE-L

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: Phil Wilson (DBA)
  INET: Phil_Wilson_at_smartforce.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: Markham, Richard
  INET: RMarkham_at_hafeleamericas.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).