My Oracle Support Banner

emca Create Repository Fails 'SEVERE: Dbcontrol Repository already exists' (Doc ID 2138104.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Database is upgraded from 10g RAC database to 11.2.0.4.
DBControl configuration is failing after database upgrade with following exception

$ORACLE_HOME/bin/emca -config dbcontrol db -repos create -cluster

STARTED EMCA at May 1, 2016 4:47:04 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: <name>
Service name: <name>
Listener port number: 1521
Listener ORACLE_HOME [ <DIR>]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: crs
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ <DIR> ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ <DIR>

Database instance hostname ................ Listener ORACLE_HOME ................ <DIR>
Listener port number ................ 1521
Cluster name ................ crs
Database unique name ................ <name>
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ <DIR>
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
May 1, 2016 4:48:22 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at DB_HOME/cfgtoollogs/emca/<SID>/emca_2016_05_01_16_47_04.log.
May 1, 2016 4:48:24 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.

From $ORACLE_HOME/cfgtoollogs/emca/emca_2016_05_01_16_47_04.log

May 1, 2016 4:48:24 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: false
May 1, 2016 4:48:24 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: false. Connecting to database instance remotely.
May 1, 2016 4:48:24 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine created successfully and connected
May 1, 2016 4:48:24 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.

Create only repository and configure later faild with ORA-01017

$ORACL_HOME/bin/emca -repos create -cluster -PORT 1521 -SYS_PWD "<Password>"

May 3, 2016 12:49:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine connecting with Service Name: <Name>, oracleHome: DB_HOME, and user: SYS host: <HostName> port: 1521
May 3, 2016 12:49:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.