FAQ
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-----

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 @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
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
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).

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

People

Translate

site design / logo © 2022 Grokbase