Capacity Manager fails to handle user/password sensitivity between a 10g Repository and 11g monit (4262351)

Capacity Manager fails to handle user/password sensitivity between a 10g Repository and 11g monitored database. Running the monitored database wizard will fail with the following:

2012/4/30 02:23:20 - Creating dblink: Complete

2012/4/30 02:23:29 - Testing dblink FAILED: : ORA-01017: invalid username/password; logon denied

grant create session to "quest"

Error occurred: [1917] (ORA-01917: user or role 'quest' does not exist

Timestamp: 5/4/2012 1:13:37 PM

declare
no_object_generic exception ;
pragma exception_init (no_object_generic, -04043) ;
begin
execute immediate 'drop package "cap" .quest_cmo_collector' ;
exception
when no_object_generic then null ;
end ;

Error occurred: [1435] (ORA-01435: user does not exist
ORA-06512: at line 5

Product defect.

WORKAROUND

1. Login to the monitored database and alter the user's password to contain all uppercase. This user is the one that will be used for the dblink.
2. Add database via the Monitored Databases Wizard and supply the username and password for the dblink.
3. Once the DB has been added, login to the monitored database and alter the user's password to contain the required case.
4. Login to the repository database and recreate the dblink with the correct password used in step 3.

STATUS

Waiting for fix in a future release of Capacity Manager for Oracle.