Mandar,
The change management I had in mind could be rather complex.
Quest Change manager generates both the scripts to make changes
that will put a schema in sync with another, and the scripts to back those
changes out.
Unless OEM is doing something drastically different than it did 2 years
ago, it doesn't give you access to the scripts generated by the chg mgr.
Jared
"Mandar A. Ghosalkar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/13/2002 03:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Oracle Diagnostic and Tuning Packs
Jared,
I can start OEM Change Manager 9.0 and edit a table rename script, add my
own custom code and let oem run that as a job, or copy the sql and run it
from sql*plus.
Mandar
-----Original Message-----
Sent: Monday, May 13, 2002 1:44 PM
To: [EMAIL PROTECTED]
Cc: Mandar A. Ghosalkar
> All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS
script and create ur own events scripts.
Mandar,
That may be so, but that doesn't give you access to the scripts that OEM
generates to accomplish the change.
As for writing my own TCL ( ugh ), if I have to write it myself anyway, I
don't
need OEM.
Jared
"Mandar A. Ghosalkar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/13/2002 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: RE: Oracle Diagnostic and Tuning Packs
Jared,
All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS script
and create ur own events scripts.
for eg, i have an oem job which does a logical export for my unix and
windows oracle databases and then fire a tcl script to change the export
filename to add the timestamp.
Also the change propogation is implemented as scripts which u can modify
and copy them to write ur own.
Also, Dennis, in 9i oem Performane Manager u can hv Statspack style
reports.
"The Performance Data Report collection option allows you to collect a set
of data that is similar to the Oracle STATSPACK utility."
the only drawback i found was of version compatibility. In our enterprise
(7.3,8.0,8.1,9.0) i becomes a headache sometimes maintaing the agents,
management servers and consoles.
Mandar
-----Original Message-----
Sent: Monday, May 13, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Kimberly,
The difference was that OEM gave push buttons only. If the change
operation failed, there was no access to the underlying scripts.
Quest gives you that access, which can be very important in the
case of failures. OEM is strictly a black box, or at least it was when
we looked at it. Maybe it's changed since then?
Jared
"Kimberly Smith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/12/2002 01:18 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: RE: Oracle Diagnostic and Tuning Packs
And I normally don't disagree with you Jared but in this case I must.
I evaluated both quite extensively just a month or so ago. They both
give you the same type of control really, just in a slightly different
format. OEM's was actually easier to use with no prior instruction.
Both are push button per say. Just a different look at the push buttons.
I actually would have probably used Quests in the end but their pricing
structure can at times be a little brutal, even compared to Oracle's
OEM. I would have been perfectly happy to take OEM. In the end we are
getting neither cause of budget issues. Embarcadero's was disappointing
at best. It provided very little mechanism for flexibility.
-----Original Message-----
Sent: Sunday, May 12, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
I will have to respectfully disagree with that, at least in part.
There is a big difference between change management in
OEM tools and Quest tools, Quest's tools being much better.
The OEM tools are push button, just like MicroSlush garbage.
Meaing: The OEM tools do no give you near the control
over managing change and synching schemas across
databases that Quest's tools allow.
Having said that, I don't use either. Had I a need for serious
change management though, Quest would win hands down.
Jared
On Sunday 12 May 2002 06:43, Yechiel Adar wrote:
> Hello Peter
>
> We did a comparison between quest tools and OEM.
> The bottom line was that all these tools gives you about the same
> functionality and there is no BIG difference between them.
>
> Our manager got a better deal from Oracle so we bought these packs.
>
> We hope to start implementing them this quarter.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, May 10, 2002 5:58 PM
>
> > Are these addons to OEM worth buying?
> >
> > Thanks
> > Peter Schauss
> > Northrop Grumman Corporation
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Schauss, Peter
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: Jared Still
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Kimberly Smith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mandar A. Ghosalkar
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mandar A. Ghosalkar
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
