OEM Db Control configuration fails
have just upgraded from 10.1.0.3 to 10.2.0.4 and upgrade of Enterpirse Manager failed. When this occurred on the dev server, I simply used emca to recreate the repos and configure dbcontrol, so I assumed this would also work on the production server. However, just my luck it failed. When trying emca -repos recreate I got errors such as:
INFO: Creating the EM repository (this may take a while) ...
27/07/2009 16:34:31 oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-20001: SYSMAN already exists..
ORA-06512: at line 17
CONFIG: Failed to unlock mgmt_view account
oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Couldn't execute statement: ORA-01422: exact fetch returns more than requested number of rows