Unable to add database to EM
From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Fri, 6 May 2022 15:10:47 +0000
Message-ID: <DM6PR09MB467795936E7F527A19C41E29DFC59_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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.
Date: Fri, 6 May 2022 15:10:47 +0000
Message-ID: <DM6PR09MB467795936E7F527A19C41E29DFC59_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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:10:47 CEST