Re: AWR snapshots empty - ADDM runs fail
Date: Thu, 5 Sep 2013 14:38:34 +1000
Message-Id: <170F8826-3D4E-4A37-8681-E7C1363BD289_at_burgess-consulting.com.au>
Hi Tony,
I can't locate any docs on it. Why I suspect it might be a constraint is that DBCA lets you either run local (DB Control) or centralised management (EMGC/EMCC etc) but not both. But if we take a look at the options for the emca utility it does look like both central and local management can be configured from the command line (taken from 11.2.0.3 btw):
emca -help
$ORACLE_HOME/bin/emca [operation] [mode] [dbType] [flags] [parameters]
-h | --h | -help | --help: prints this help message -version: prints the version
-config dbcontrol db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure Database Control for a database -config centralAgent (db | asm) [-cluster] [-silent] [parameters]: configure central agent management -config all db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure both Database Control and central agent management
..
Depending on how the original dbcontrol was configured you might need to -deconfig the existing dbcontrol and then run a '-config all db' to have both central and local management.
Regards,
Mark
On 05/09/2013, at 8:29 AM, De DBA <dedba_at_tpg.com.au> wrote:
> Thanks Mark,
>
> Do you happen to know where this would be documented? I did read the EMCC docs, but found nothing to indicate that this could be a problem. Indeed, I seem to remember that on this list not too long ago someone (Peter Sharman perhaps?) alluded to the fact that both could be used side-by-side, albeit that jobs defined in one will not show up in the other and similar gotchas.
>
> Cheers,
> Tony
>
> On 04/09/13 20:20, Mark Burgess wrote:
>> Hi Tony, >> >> you may have to deinstall the DB Control repository in the targets and then configure the 11.1 targets under 12c CC. From memory you can't have a target managed by both DB Control and EMGC/CC - but I maybe wrong. Even if you do have to deinstall this should still preserve the AWR data. >> >> Regards, >> >> Mark >>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 05 2013 - 06:38:34 CEST