Multiple DBs per Server and OEM

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Tue, 12 Apr 2005 08:28:46 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36458582@CWYMSX04.Corp.Acxiom.net>

Does anyone use OEM to run jobs against a server that contains multiple DBs? I have a server that has 2 databases on it and a need to run a job via OEM against both databases. The job is a mixture of O/S commands and SQL, so I created a ksh script to perform the work, then created a job within OEM as a database job, assigned both databases to it, under "Tasks" I chose "Run OS Command" and under "Parameters" I listed out the ksh script in the command section. My thought was that the job in OEM would run twice, with $ORACLE_SID set differently based on the database assigned.

The problem is that at the OS level, $ORACLE_SID stays the same. It appears the only way to work with different databases automatically is the use "Run SQL Command" or "Run DBA Command". Is this true? Is there some way for a ksh script, called via an OEM Job, to know what database its being asked to run against, such as some parameter from OEM?

Any help would be appreciated.

Dave

Dave Herring, DBA

Acxiom Corporation

3333 Finley

Downers Grove, IL 60515

wk: 630.944.4762

< <mailto:dherri_at_acxiom.com> mailto:dherri_at_acxiom.com>

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 - 09:33:17 CDT