Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OEM can't seem to discover 1 instance

RE: OEM can't seem to discover 1 instance

From: James Howerton <jhowerton_at_uabmc.edu>
Date: Fri, 18 Oct 2002 06:49:00 -0800
Message-ID: <F001.004ED519.20021018064900@fatcity.com>


John,

Try this

On the client node:

1. Make sure all instances are in oratab & listener.ora.
2. Stop the agent.
3. rm $ORACLE_HOME/network/agent/*.q
4. rm $ORACLE_HOME/network/agent/services.ora
5. rm $ORACLE_HOME/network/admin/snmp_r*.ora
6. start the agent
7. Check the pertinent log files in $ORACLE_HOME/network/log

On the OEM console:
1. Delete the node you are trying to discover. 2. Discover the node

If you're lucky the instances will show up???

...JIM... Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services

e: jhowerton_at_uabmc.edu 
v: 205-934-9111
f: 205-934-0632


>>> john.weatherman_at_replacements.com 10/18/02 8:38:37 AM >>>
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, MP
O
>
> 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: James Howerton
  INET: jhowerton_at_uabmc.edu

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).
Received on Fri Oct 18 2002 - 09:49:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US