EMCA Fails With Error "ORA-01722: invalid number" While Configuring Database Control (Doc ID 1124418.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager Base Platform - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

Trying to configure database control for 11.1.0.7 database returns following error message in emca_2010_06_05_22_13_50.log

Jun 5, 2010 10:14:25 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to /app/oracle/cfgtoollogs/emca/ASAPE09/emca_repos_create_2010_06_05_22_14_25.log
Jun 5, 2010 10:14:25 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 5, 2010 10:21:10 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-01722: invalid number
ORA-06512: at line 28

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01722: invalid number
ORA-06512: at line 28

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)


+ ASAPE091_ora_287188.trc shows below:

Incident 22613 created, dump file: /app/oracle/diag/rdbms/asape09/ASAPE091/incident/incdir_22613/ASAPE091_ora_287188_i22613.trc
ORA-00600: internal error code, arguments: [qkshtQBGet:1], [], [], [], [], [], [], [], [], [], [], []

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