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

Last updated on JUNE 26, 2016

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: etradedb
Service name: etradedb
Listener port number: 1521
Listener ORACLE_HOME [ /u001/app/11.2.0/grid ]:
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 [ /u001/app/11.2.0/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u001/app/oracle/product/11.2.0/dbhome_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u001/app/11.2.0/grid
Listener port number ................ 1521
Cluster name ................ crs
Database unique name ................ etradedb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u001/app/11.2.0/grid
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 /u001/app/oracle/cfgtoollogs/emca/etradedb/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 "oracle123"

[main] [ 2016-05-03 12:49:42.360 AST ] [SQLEngine.initialize:366]  Starting Reader Thread...

[main] [ 2016-05-03 12:49:42.360 AST ] [SQLEngine.initialize:366]  Starting Reader Thread...
[Finalizer] [ 2016-05-03 12:49:42.340 AST ] [Util.finalize:126]  Util: finalized called for oracle.ops.mgmt.has.Util@32955cd5
[main] [ 2016-05-03 12:49:42.347 AST ] [OsUtilsBase.getBaseFromOrabase:669]  baseLocation from orabase /u001/app/oracle
[main] [ 2016-05-03 12:49:42.348 AST ] [OsUtilsBase.getBaseFromOrabase:694]   orabaseLocation= /u001/app/oracle
[main] [ 2016-05-03 12:49:42.349 AST ] [SQLEngine.getEnvParams:559]  Unable to get NLS_LANG from LocaleMapper: oracle.i18n.util.LocaleMapper
[main] [ 2016-05-03 12:49:42.349 AST ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...
[main] [ 2016-05-03 12:49:42.359 AST ] [SQLEngine.initialize:362]  m_bReaderStarted: false
[main] [ 2016-05-03 12:49:42.360 AST ] [SQLEngine.initialize:366]  Starting Reader Thread...
.....
May 3, 2016 12:49:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine connecting with Service Name: etradedb, oracleHome: /u001/app/oracle/product/11.2.0/dbhome_1, and user: SYS host: ruhs1dbs02 port: 1521
May 3, 2016 12:49:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms