RE: Multiple DBs per Server and OEM

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Tue, 12 Apr 2005 10:32:44 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E364585CF@CWYMSX04.Corp.Acxiom.net>

Howard,

That'd be cool if it worked, but I don't think you can pass parameters between multiple Tasks within a job. If I understand correctly what you're saying, I should create 2 tasks - Run DBA Script and Run OS Command. Within the first I'd SELECT instance FROM v$instance. That value would then need to be passed to the Run OS Command task. I'm pretty
new as this so I have no idea how to pass parameters between Tasks. Any clue?

P.S. Yup, cron would solve this and it's what I previously used for OEM. I guess I figured for consistency I'd try to manage everything via OEM. Apparently what makes sense to me isn't always true for Oracle. :-)

Dave

---

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com>

---

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

From: Howard Latham [mailto:howard.latham_at_rsmb.co.uk] Sent: Tuesday, April 12, 2005 9:37 AM
To: thomas.mercadante_at_labor.state.ny.us; Herring Dave - dherri; oracle-l_at_freelists.org
Subject: RE: Multiple DBs per Server and OEM

 I just tried some jobs on NT (Yes sad isn't it - no cron!) And the run DBA Script appears to connect via the SQLNET Route so you could get the SID by select name from v$database And pass that to Unix.

Howard A. Latham

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 12 2005 - 11:36:52 CDT