RE: Insight on oracle enterprise manager

The OEM submits code to target databases via OraTcl (possibly just straight Java now) and SNMP to the Oracle Agent, which then passes it to the DBSNMP account on the target database.

>From there, the DBSNMP account runs the code, be it event checks, jobs, etc.

Otherwise you have to go through SQL*Worksheet or some of the other GUI tools, I think. You might be able to shutdown and restart databases via the console or DBA Studio. First you have to log into the database by double-clicking in the navigator pane on databases that you placed there manually and configured to connect as SYSDBA. The SQL that is submitted through most of the GUI tools is just SQL via SQL*Net, it's not through SNMP and the Oracle Agent.

That's why it's important to change the DBSNMP password! If you leave the Oracle Agent running, and you ran the catsnmp.sql script, your dbsnmp account is open to the world. Check MetaLink for info on how to change dbsnmp passwords.

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

 -----Original Message-----

Sent:	Friday, April 26, 2002 9:18 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Insight on oracle enterprise manager

We don't have intelligent agent running on any of our database servers, and OEM (Solaris version) works fine. I *think* the agent is only needed for monitoring with OEM.

Bob Metelsky wrote:
>
> Hi all
>
> New to the list... beeen lurking for about a week. Ive recently
> been interested in using OEM Ive installed it on my server with one
> database, the questions is,how can I acccess the other dbs that dont
> have "intellegent agents" I cant seem to add the dbs manually
>
> thanks
> bob
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bob Metelsky
> INET: bob_at_cps92.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).