To ensure that the data being transferred from the Enterprise Manager Repository to the Always-On Monitoring Repository is stored and represented properly when the Always-On Monitoring Repository is on a separate instance from Enterprise Manager, it is important to ensure that the character set matches between the two databases/instances. For Enterprise Manager, the NLS_CHARACTERSET is defined as AL32UTF8..

If using Oracle Installer to manually set up the database instance that Always-On Monitoring uses, the instance will default to WE8MSWIN1252. Ensure at this point that the option AL32UTF8 is selected from the drop down box so that the correct character set is installed from the start..

To determine the character set on the Enterprise Manager Repository, run the following query:

SELECT * from nls_database_parameters where parameter='NLS_CHARACTERSET';

Run this query as well on the Always-On Monitoring Repository to ensure the character sets match. If the Always-On Monitoring Repository character set is different, the following is recommended to change the character set on the Always-On Monitoring Repository to match that of the Enterprise Manager Repository.

--Shutdown and start the database in a restricted mode.  
SHUTDOWN IMMEDIATE;  
STARTUP RESTRICT;  
 
--Set JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES to its default value i.e.0  
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;  
ALTER SYSTEM SET AQ_TM_PROCESSES=0;  
 
-- Set the required character set.  
ALTER DATABASE CHARACTER SET AL32UTF8;  
 
 -- if the above fails:  
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;  
 
--Shutdown and restart the database in normal mode.  
SHUTDOWN IMMEDIATE;  
STARTUP;  
/