Cloud Control Basic Installation Guide
https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/embsc/package-kernel-parameter-and-library-requirements-enterprise-manager-cloud-control.html#GUID-11F03DA1-D5A9-4C10-AAEF-CC10BD60A320
The 13.5.0.0.0 DB templates are only for 19.11 version of database
https://www.oracle.com/enterprise-manager/downloads/db-templates-13c-release5-downloads.html
여기서 only 19.11 이라는건 repository 템플릿이 19.11 버전이라는 뜻
현재 RU 버전이랑은 상관없음
EM 13.5 : Parameters for EM Repository Database Single Instance (Doc ID 2986532.1)
위 문서에 첨부되어 있는 파라미터
-EMCC_Install.docs
alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both sid='*';
alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';
alter system reset "_px_adaptive_dist_method" scope=both sid='*';
alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';
alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';
alter system reset "_optimizer_use_feedback" scope=both sid='*';
alter system reset "_optimizer_gather_feedback" scope=both sid='*';
alter system reset "_optimizer_performance_feedback" scope=both sid='*';
-Database_SQL_for_EM13_5_0_0_0.sql
alter system set shared_pool_size='600M';
alter system set db_securefile=PERMITTED sid='*';
alter system set optimizer_adaptive_statistics=FALSE scope=both sid='*';
alter system set optimizer_adaptive_plans=FALSE scope=both sid='*';
alter system reset "_optimizer_nlj_hj_adaptive_join"scope=both sid='*';
alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';
alter system reset "_px_adaptive_dist_method" scope=both sid='*';
alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';
alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';
alter system reset "_optimizer_use_feedback" scope=both sid='*';
alter system reset "_optimizer_gather_feedback" scope=both sid='*';
alter system reset "_optimizer_performance_feedback" scope=both sid='*';
alter system set "_allow_insert_with_update_check" = true;
위 파라미터를 적용시키면 기존 DB 를 Repository DB로 사용 가능
또는 오라클에서 제공하는 Repository DB용 템플릿으로 Repository 용 인스턴스 생성 가능
나는 기존 DB에 Repository 파라미터 적용