RE: OEM can't seem to discover 1 instance

Is this UNIX or Windows?

Where is your oratab file located and what is your ORACLE_HOME directory? The discovery process looks in your oratab (which can be located anywhere as long as the ORATAB environment variable is defined) or the Windows registry to locate all of the ORACLE_HOMEs that are in use and gets the SIDs from the oratab. I set a GLOBAL_DBNAME in my listener.ora to uniquely identify each db. If GLOBAL_DBNAME does not exist it uses the tnsnames.ora file to determine the services to manage.

Check your tnsnames.ora file to make sure you have entries for the dbs.

HTH 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: Friday, October 18, 2002 10: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_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: 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).