Enterprise Manager 12c stores its data in a repository database.
The repository database is usually created before installation of the OMS
The database must be available before OMS is started
Repository details include the connect descriptor and the user
To list repository details use emctl. For example:
$OMS_HOME/bin/emctl config oms -list_repos_details Oracle Enterprise Manager Cloud Control 12c Release 4 Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved. Repository Connect Desriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521)))(CONNECT_DATA=(SID=EMREP))) Repository User : SYSMAN
During OMS instalation the OUI checks that the DB_SECUREFILES parameter is set to PERMITTED. This parameter can be set dynamically at any time using:
ALTER SYSTEM SET db_securefiles = PERMITTED;
This section covers common repository tables
This table contains messages for all subsystems
| Column Name | Data Type | Notes |
| MESSAGE_ID | VARCHAR(256) | |
| SUBSYSTEM | VARCHAR(64) | |
| LANGUAGE_CODE | VARCHAR(2) | |
| COUNTRY_CODE | VARCHAR(2) | |
| MESSAGE | VARCHAR2(1000) |
The following table shows the number of messages for each subsystem in EM12.1.0.4:
| Subsystem | # Messages |
| ASLM_TESTS | 100 |
| ASPROV | 8290 |
| ASPROV_SWLIB | 920 |
| BIPROV | 2366 |
| BMP | 510 |
| BPEL | Provisioning |
| BPELPROVISIONING | 1790 |
| CATEGORY | 90 |
| CFW | 80 |
| CLONE | 60 |
| COHERENCEPROV_SWLIB | 140 |
| COMMON_SWLIB | 120 |
| CONFIG_STD | 3050 |
| DBAASDP | 12 |
| DBCLEANUP | 330 |
| DBPROV | 6475 |
| DBPROVCORE | 340 |
| DBPROVSIDB | 4869 |
| DBPROVSWLIB | 4700 |
| DBPROVUPGRADE | 4468 |
| DBTEMPLATE | 20 |
| DB_CONFIG_SEARCH | 490 |
| ECM_INV_METADATA | 710 |
| ECM_METADATA | 53227 |
| EM_ECM_SEARCH | 600 |
| EM_ECM_VCPU | 650 |
| FMWCLEANUP | 140 |
| FMWCLEANUP_SWLIB | 150 |
| FMWPROFILE | 190 |
| FMWPROV_PROFILES | 60 |
| FMWPROV_SWLIB | 1500 |
| FMW_INST_MEDIA | 60 |
| GCCOMPLIANCE_CCC | 42270 |
| GOLDAGENTIMAGE | 20 |
| HA | 180 |
| INSTALLMEDIA | 20 |
| JAVAEECOMPONENT | 20 |
| JAVAEEPROV_SWLIB | 110 |
| KEYWORD | 160 |
| LICENSE | 90 |
| MONITORING_TEMPLATE | 1464 |
| MULTIOMS | 1720 |
| OHSPROVISIONING_DP | 640 |
| OHSSCALEOUT_DP | 1200 |
| OSB_PROV | 520 |
| PAF_MESSAGES | 270 |
| PATCH | 9810 |
| POLICY | 101330 |
| PREREQ_DP | 440 |
| PROFILE | 3090 |
| RACPROV | 17044 |
| REPORTS | 10660 |
| SCALEDOWN | 540 |
| SELFUPDATE | 20 |
| SIDBPROV | 4460 |
| SITEGUARD | 10 |
| SITEGUARD_SWLIB | 280 |
| SOAPROV | 4070 |
| STANDBYOMS | 1310 |
| SWLIB | 260 |
| WLSPROV | 7230 |
| WLSWSM_DP | 1850 |
| WLSWSM_SWLIB | 80 |