Re: Unable to add database to EM
Date: Fri, 6 May 2022 15:48:42 +0000
Message-ID: <DM6PR15MB4108397ABDF4C6E1893757A7C5C59_at_DM6PR15MB4108.namprd15.prod.outlook.com>
Jeffrey,
Take a look at the “Auto Discovery Results” in Enterprise Manager at Setup -> Add Target -> Auto Discovery Results. If you see the database targets listed there, then I recommend either promoting the auto discovered database targets, or deleting the auto discovered targets and adding the new targets manually.
Michael J Pecoraro
Database Administrator | Enterprise Infrastructure Services
University at Buffalo Information Technology (UBIT)
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Friday, May 6, 2022 at 11:10 AM
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org>
Subject: Unable to add database to EM
Some background:
Upgrading 11g database to 19c. Created a CDB using DBCA. DBCA would NOT talk to the agent. Database support analyst stated DBCA was looking for lower case host name and agent upper case. Analyst stated to skip registering with EM during DBCA. During DBUA upgrade of the database, did the same. Finally converted upgraded database to multitenant in the CDB. Since done with upgrade, attempted to add CDB to EM. That's when it complains already exists - however it does not show up in database list. No idea how could already exist since just trying to add it now.
When we query sysman.em_manageable_entities for cdb01t06, we do se below entries….
ENTITY_NAME ENTITY_TYPE HOST_NAME MANAGE_STATUS PROMOTE_STATUS CREATION_DATE
------------------------------ ------------------------------ -------------------- ------------- -------------- -------------------
cdb01t06 oracle_database xxxxxxxxx.rta 1 1 05/03/2022 10:59:29
CDB01T06_xxxxxxxxx.RTA oracle_listener xxxxxxxxx.rta 1 1 05/03/2022 10:59:30 cdb01t06_CDBROOT oracle_pdb xxxxxxxxx.rta 1 1 05/05/2022 10:59:34 cdb01t06_or13 oracle_pdb xxxxxxxxx.rta 1 1 05/05/2022 10:59:34Any suggestions on how to clean EM so can add the database?
Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 06 2022 - 17:48:42 CEST