ORACLEで作ったデフォルトデータベースにつながらない、と勘違いした問題。

Introduction

SQLPLUSはつながるのに、SQL DeveloperやJetBrains DataGripから上述のエラーが出てしまった。

※上の設定はSIDを間違っています。正しくはORCL これが原因でした。ORCLにすれば問題なかったです。後述の共有サーバーモードに変更する必要もないです。

How to resolve?

間違っていますが…途中までの経過を。

調べた結果、Database Configuration Assistantを起動し、問題のデータベースの設定を変更するとよいらしい。
共有サーバーモードにするらしい。


完了を押下して続行するも、再構成途中で下記のエラーで落ちる。


なんかemora.keyがないとかどうとかなので、EMリポジトリを作れと。
指示に従い、 

1
c:\Oracle\product\11.2.0\dbhome_1\BIN\emca.bat -repos create

とするもエラー。
指示に従いログを見ると…

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Check if repos user already exists.

旧   6:    WHERE username=UPPER('&EM_REPOS_USER');
新   6:    WHERE username=UPPER('SYSMAN');
旧   8:   IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
新   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN
旧  11:       raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
新  11:       raise_application_error(-20000, 'SYSMAN does not exists..');
旧  14:   ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
新  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
旧  17:       raise_application_error(-20001, '&EM_REPOS_USER already exists..');
新  17:       raise_application_error(-20001, 'SYSMAN already exists..');
旧  21:       raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
新  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
DECLARE
*
行1でエラーが発生しました。:
ORA-20001: SYSMAN already exists..
ORA-06512: 行17

問題のオブジェクトを消しては、再作成を繰り返し、いい加減埒が明かないと思い、調べた。
結果、

GridControl環境構成再び・・・ - honu @ ウィキ
GridControl環境構成再び・・・ - honu @ ウィキ
https://w.atwiki.jp/honu/pages/19.html
グリッドコントロール環境構成で参考にしたサイトは以下 http://www.oracle.com/technetwork/articles/revitt-oem-096363.html#l 躓いたとこ...
blog.itpub.net
How to manually set up oracle enterprise manager_ITPUB博客
http://blog.itpub.net/7636787/viewspace-752662/
emca is used to configure enterprise manager.Please refer to http://space.itpub.net/20943428/viewspace-628782 to set up enterprise manager.Y…

上記記事のコマンドを足し合わせた下記のコマンドをSQLPLUSで実行。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
DROP USER SYSMAN CASCADE;
DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;
DROP ROLE MGMT_USER;
DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
DROP USER MGMT_VIEW;
DROP USER SYSMAN CASCADE;
DROP ROLE MGMT_USER;
DROP USER MGMT_VIEW CASCADE;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;
DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;
DROP PUBLIC SYNONYM MGMT_VIEW_UTIL;
DROP PUBLIC SYNONYM MGMT_USER;
DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
DROP PUBLIC SYNONYM MGMT_TARGETS;
DROP PUBLIC SYNONYM MGMT_TARGET;
DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;
DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;
DROP PUBLIC SYNONYM MGMT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_PREFERENCES;
DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST;
DROP PUBLIC SYNONYM MGMT_PAF_JOBS;
DROP PUBLIC SYNONYM MGMT_PAF$STATES;
DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES;
DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES;
DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS;
DROP PUBLIC SYNONYM MGMT_NAME_VALUES;
DROP PUBLIC SYNONYM MGMT_NAME_VALUE;
DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS;
DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS;
DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR;
DROP PUBLIC SYNONYM MGMT_METRICS_1DAY;
DROP PUBLIC SYNONYM MGMT_METRICS;
DROP PUBLIC SYNONYM MGMT_MESSAGES;
DROP PUBLIC SYNONYM MGMT_LONG_TEXT;
DROP PUBLIC SYNONYM MGMT_LOG;
DROP PUBLIC SYNONYM MGMT_JOB_TARGET;
DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;
DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;
DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;
DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY;
DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;
DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;
DROP PUBLIC SYNONYM MGMT_JOBS;
DROP PUBLIC SYNONYM MGMT_JOB;
DROP PUBLIC SYNONYM MGMT_IP_TGT_GUID_ARRAY;
DROP PUBLIC SYNONYM MGMT_GUID_OBJ;
DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;
DROP PUBLIC SYNONYM MGMT_GLOBAL;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;
DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_IDS;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;
DROP PUBLIC SYNONYM MGMT_DELTA;
DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS;
DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_CREDENTIAL;
DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_ADMIN;
DROP PUBLIC SYNONYM MGMT$TXN_PERF_RAW;
DROP PUBLIC SYNONYM MGMT$TXN_PERF_HOUR;
DROP PUBLIC SYNONYM MGMT$TXN_PERF_DAY;
DROP PUBLIC SYNONYM MGMT$TEMPLATE_POLICY_SETTINGS;
DROP PUBLIC SYNONYM MGMT$TEMPLATE_METRIC_SETTINGS;
DROP PUBLIC SYNONYM MGMT$TEMPLATE_METRICCOLLECTION;
DROP PUBLIC SYNONYM MGMT$TEMPLATES;
DROP PUBLIC SYNONYM MGMT$TARGET_TYPE_PROPERTIES;
DROP PUBLIC SYNONYM MGMT$TARGET_TYPE_DEF;
DROP PUBLIC SYNONYM MGMT$TARGET_TYPE;
DROP PUBLIC SYNONYM MGMT$TARGET_PROPERTIES;
DROP PUBLIC SYNONYM MGMT$TARGET_POLICY_SETTINGS;
DROP PUBLIC SYNONYM MGMT$TARGET_POLICY_EVAL_SUMM;
DROP PUBLIC SYNONYM MGMT$TARGET_POLICIES;
DROP PUBLIC SYNONYM MGMT$TARGET_METRIC_SETTINGS;
DROP PUBLIC SYNONYM MGMT$TARGET_METRIC_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT$TARGET_MEMBERS;
DROP PUBLIC SYNONYM MGMT$TARGET_FLAT_MEMBERS;
DROP PUBLIC SYNONYM MGMT$TARGET_COMPOSITE;
DROP PUBLIC SYNONYM MGMT$TARGET_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$TARGET_ASSOCIATIONS;
DROP PUBLIC SYNONYM MGMT$TARGET;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_VOLUME;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_PATHS;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_NFS;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_LOCALFS;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_KEYS;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_ISSUES;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_DISK;
DROP PUBLIC SYNONYM MGMT$STORAGE_REPORT_DATA;
DROP PUBLIC SYNONYM MGMT$STEP_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT$STEP_METRICS_HOURLY;
DROP PUBLIC SYNONYM MGMT$STEP_METRICS_DAILY;
DROP PUBLIC SYNONYM MGMT$STEP_GROUPS;
DROP PUBLIC SYNONYM MGMT$STEPS;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_PATCHSETS;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_PATCHES_IN_HOMES;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_OTHERS;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_ONEOFF_PATCHES;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_HOME_PROPERTIES;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_HOMES;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_DEPENDENCIES;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_COMP_PATCHSET;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_COMPONENT_ONEOFF;
DROP PUBLIC SYNONYM MGMT$SOFTWARE_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$RACDB_INTERCONNECTS;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOL_NOTIF_LOG;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOL_ANNOTATIONS;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOLATION_HISTORY;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOLATION_CURRENT;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOLATION_CTXT;
DROP PUBLIC SYNONYM MGMT$POLICY_VIOLATION_CONTEXT;
DROP PUBLIC SYNONYM MGMT$POLICY_PARAMETERS;
DROP PUBLIC SYNONYM MGMT$POLICIES;
DROP PUBLIC SYNONYM MGMT$PATCH_ADVISORIES;
DROP PUBLIC SYNONYM MGMT$OS_SUMMARY;
DROP PUBLIC SYNONYM MGMT$OS_PROPERTIES;
DROP PUBLIC SYNONYM MGMT$OS_PATCHES;
DROP PUBLIC SYNONYM MGMT$OS_KERNEL_PARAMS;
DROP PUBLIC SYNONYM MGMT$OS_HW_SUMMARY;
DROP PUBLIC SYNONYM MGMT$OS_FS_MOUNT;
DROP PUBLIC SYNONYM MGMT$OS_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$ORACLE_SW_GRP_TARGETS;
DROP PUBLIC SYNONYM MGMT$ORACLE_SW_GRP_INSTALL;
DROP PUBLIC SYNONYM MGMT$ORACLE_SW_ENT_TARGETS;
DROP PUBLIC SYNONYM MGMT$ORACLE_SW_ENT_INSTALL;
DROP PUBLIC SYNONYM MGMT$MISSING_TARGETS_IN_GROUPS;
DROP PUBLIC SYNONYM MGMT$MISSING_TARGETS;
DROP PUBLIC SYNONYM MGMT$METRIC_HOURLY;
DROP PUBLIC SYNONYM MGMT$METRIC_ERROR_HISTORY;
DROP PUBLIC SYNONYM MGMT$METRIC_ERROR_CURRENT;
DROP PUBLIC SYNONYM MGMT$METRIC_DETAILS;
DROP PUBLIC SYNONYM MGMT$METRIC_DAILY;
DROP PUBLIC SYNONYM MGMT$METRIC_CURRENT;
DROP PUBLIC SYNONYM MGMT$METRIC_COLLECTION;
DROP PUBLIC SYNONYM MGMT$METRIC_CATEGORIES;
DROP PUBLIC SYNONYM MGMT$MESSAGES;
DROP PUBLIC SYNONYM MGMT$JOB_TARGETS;
DROP PUBLIC SYNONYM MGMT$JOB_STEP_HISTORY;
DROP PUBLIC SYNONYM MGMT$JOB_NOTIFICATION_LOG;
DROP PUBLIC SYNONYM MGMT$JOB_EXECUTION_HISTORY;
DROP PUBLIC SYNONYM MGMT$JOB_ANNOTATIONS;
DROP PUBLIC SYNONYM MGMT$JOBS;
DROP PUBLIC SYNONYM MGMT$INTERFACE_STATS;
DROP PUBLIC SYNONYM MGMT$HW_NIC;
DROP PUBLIC SYNONYM MGMT$HOSTPATCH_HOST_COMPL;
DROP PUBLIC SYNONYM MGMT$HOSTPATCH_HOSTS;
DROP PUBLIC SYNONYM MGMT$HOSTPATCH_GRP_COMPL_HIST;
DROP PUBLIC SYNONYM MGMT$HOSTPATCH_GROUPS;
DROP PUBLIC SYNONYM MGMT$HOMES_AFFECTED;
DROP PUBLIC SYNONYM MGMT$HA_RMAN_CONFIG_ALL;
DROP PUBLIC SYNONYM MGMT$HA_RMAN_CONFIG;
DROP PUBLIC SYNONYM MGMT$HA_MTTR;
DROP PUBLIC SYNONYM MGMT$HA_INIT_PARAMS_ALL;
DROP PUBLIC SYNONYM MGMT$HA_INIT_PARAMS;
DROP PUBLIC SYNONYM MGMT$HA_INFO_ALL;
DROP PUBLIC SYNONYM MGMT$HA_INFO;
DROP PUBLIC SYNONYM MGMT$HA_FILES_ALL;
DROP PUBLIC SYNONYM MGMT$HA_FILES;
DROP PUBLIC SYNONYM MGMT$HA_BACKUP;
DROP PUBLIC SYNONYM MGMT$GRP_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT$GRP_METRICS_HOURLY;
DROP PUBLIC SYNONYM MGMT$GRP_METRICS_DAILY;
DROP PUBLIC SYNONYM MGMT$GROUP_MEMBERS;
DROP PUBLIC SYNONYM MGMT$GROUP_FLAT_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT$GROUP_DERIVED_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT$ESA_WITH_GRANT_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_WITH_ADMIN_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_TRC_AUD_PERM_REP_NT;
DROP PUBLIC SYNONYM MGMT$ESA_TRC_AUD_PERM_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_TABSP_OWNERS_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_SYS_PUB_PKG_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_PUB_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_POWER_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_OH_PERMISSION_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_OH_OWNERSHIP_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_KEY_OBJECTS_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_EXMPT_ACCESS_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_DIRECT_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_DBA_ROLE_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_DBA_GROUP_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_CREATE_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_CONN_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_CATALOG_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_BECOME_USER_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_AUDIT_SYSTEM_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_ANY_PRIV_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_ANY_DICT_REPORT;
DROP PUBLIC SYNONYM MGMT$ESA_ALL_PRIVS_REPORT;
DROP PUBLIC SYNONYM MGMT$EM_HOMES_PLATFORM;
DROP PUBLIC SYNONYM MGMT$ECM_VISIBLE_SNAPSHOTS;
DROP PUBLIC SYNONYM MGMT$ECM_CURRENT_SNAPSHOTS;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY6;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY5;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY4;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY3;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY2;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY_KEY1;
DROP PUBLIC SYNONYM MGMT$ECM_CONFIG_HISTORY;
DROP PUBLIC SYNONYM MGMT$E2E_RAW;
DROP PUBLIC SYNONYM MGMT$E2E_HOURLY;
DROP PUBLIC SYNONYM MGMT$E2E_1DAY;
DROP PUBLIC SYNONYM MGMT$DELTA_VIEW_DETAILS;
DROP PUBLIC SYNONYM MGMT$DELTA_VIEW;
DROP PUBLIC SYNONYM MGMT$DELTA_VENDOR_SW;
DROP PUBLIC SYNONYM MGMT$DELTA_PATCHSET_DETAILS;
DROP PUBLIC SYNONYM MGMT$DELTA_PATCHSETS;
DROP PUBLIC SYNONYM MGMT$DELTA_OS_KERNEL_PARAMS;
DROP PUBLIC SYNONYM MGMT$DELTA_OS_COMP_DETAILS;
DROP PUBLIC SYNONYM MGMT$DELTA_OS_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$DELTA_ORACLE_HOME;
DROP PUBLIC SYNONYM MGMT$DELTA_ONEOFF_PATCHES;
DROP PUBLIC SYNONYM MGMT$DELTA_INIT;
DROP PUBLIC SYNONYM MGMT$DELTA_HOST_CONFIG;
DROP PUBLIC SYNONYM MGMT$DELTA_HARDWARE;
DROP PUBLIC SYNONYM MGMT$DELTA_FS_MOUNT;
DROP PUBLIC SYNONYM MGMT$DELTA_COMPONENT_DETAILS;
DROP PUBLIC SYNONYM MGMT$DELTA_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$DB_TABLESPACES_ALL;
DROP PUBLIC SYNONYM MGMT$DB_TABLESPACES;
DROP PUBLIC SYNONYM MGMT$DB_SGA_ALL;
DROP PUBLIC SYNONYM MGMT$DB_SGA;
DROP PUBLIC SYNONYM MGMT$DB_ROLLBACK_SEGS_ALL;
DROP PUBLIC SYNONYM MGMT$DB_ROLLBACK_SEGS;
DROP PUBLIC SYNONYM MGMT$DB_REDOLOGS_ALL;
DROP PUBLIC SYNONYM MGMT$DB_REDOLOGS;
DROP PUBLIC SYNONYM MGMT$DB_OPTIONS_ALL;
DROP PUBLIC SYNONYM MGMT$DB_OPTIONS;
DROP PUBLIC SYNONYM MGMT$DB_LICENSE_ALL;
DROP PUBLIC SYNONYM MGMT$DB_LICENSE;
DROP PUBLIC SYNONYM MGMT$DB_INIT_PARAMS_ALL;
DROP PUBLIC SYNONYM MGMT$DB_INIT_PARAMS;
DROP PUBLIC SYNONYM MGMT$DB_FEATUREUSAGE;
DROP PUBLIC SYNONYM MGMT$DB_DBNINSTANCEINFO_ALL;
DROP PUBLIC SYNONYM MGMT$DB_DBNINSTANCEINFO;
DROP PUBLIC SYNONYM MGMT$DB_DATAFILES_ALL;
DROP PUBLIC SYNONYM MGMT$DB_DATAFILES;
DROP PUBLIC SYNONYM MGMT$DB_CONTROLFILES_ALL;
DROP PUBLIC SYNONYM MGMT$DB_CONTROLFILES;
DROP PUBLIC SYNONYM MGMT$CS_EVAL_SUMMARY_STANDARD;
DROP PUBLIC SYNONYM MGMT$CS_EVAL_SUMMARY_RULE;
DROP PUBLIC SYNONYM MGMT$CS_CONFIG_STANDARDS;
DROP PUBLIC SYNONYM MGMT$CSM_WATCHLIST;
DROP PUBLIC SYNONYM MGMT$CSM_URL_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_URL_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_URL_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_URL_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_SUBNET_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_SUBNET_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_SUBNET_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_SUBNET_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_REGION_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_REGION_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_REGION_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_REGION_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_REGION;
DROP PUBLIC SYNONYM MGMT$CSM_MT_URL_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_URL_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_URL_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_URL_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_METRIC_DETAILS;
DROP PUBLIC SYNONYM MGMT$CSM_MT_IP_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_IP_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_IP_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_IP_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_DSR_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_DSR_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_DSR_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_MT_DSR_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_METRIC_DETAILS;
DROP PUBLIC SYNONYM MGMT$CSM_IP_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_IP_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_IP_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_IP_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_DOMAIN_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_DOMAIN_DIST_HOURLY;
DROP PUBLIC SYNONYM MGMT$CSM_DOMAIN_DIST_DAILY;
DROP PUBLIC SYNONYM MGMT$CSM_DOMAIN_DAILY;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_SW;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_RULES;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_OS_PROPERTIES;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_OS_FILESYSTEMS;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_OS_COMPONENTS;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_NICS;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_IOCARDS;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_CUSTOM;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_CPUS;
DROP PUBLIC SYNONYM MGMT$CSA_HOST_COOKIES;
DROP PUBLIC SYNONYM MGMT$CSA_FAILED;
DROP PUBLIC SYNONYM MGMT$CSA_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT$CSA_CLIENT_RULE_VIOLS;
DROP PUBLIC SYNONYM MGMT$CSA_CLIENTS;
DROP PUBLIC SYNONYM MGMT$CPF_PATCH_INFO;
DROP PUBLIC SYNONYM MGMT$CPF_PATCH_DATA;
DROP PUBLIC SYNONYM MGMT$CPF_HOMES_INFO;
DROP PUBLIC SYNONYM MGMT$CPF_ADVISORY_INFO;
DROP PUBLIC SYNONYM MGMT$CLUSTER_INTERCONNECTS;
DROP PUBLIC SYNONYM MGMT$BLACKOUT_HISTORY;
DROP PUBLIC SYNONYM MGMT$BLACKOUTS;
DROP PUBLIC SYNONYM MGMT$AVAILABILITY_HISTORY;
DROP PUBLIC SYNONYM MGMT$AVAILABILITY_CURRENT;
DROP PUBLIC SYNONYM MGMT$AUDIT_LOG;
DROP PUBLIC SYNONYM MGMT$APPL_PATCH_AND_PATCHSET;
DROP PUBLIC SYNONYM MGMT$APPLIED_PATCHSETS;
DROP PUBLIC SYNONYM MGMT$APPLIED_PATCHES;
DROP PUBLIC SYNONYM MGMT$ALERT_NOTIF_LOG;
DROP PUBLIC SYNONYM MGMT$ALERT_HISTORY;
DROP PUBLIC SYNONYM MGMT$ALERT_CURRENT;
DROP PUBLIC SYNONYM MGMT$ALERT_ANNOTATIONS;
DROP PUBLIC SYNONYM EMD_MNTR;
DROP PUBLIC SYNONYM ECM_UTIL;

そして再実行した結果。うまくいきました。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
EMCAの開始 2020/05/13 0:01:25
EM Configuration Assistant, リリース11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

次の情報を入力してください:
データベースのSID: ORCL
リスナーのポート番号: 1521
SYSユーザーのパスワード:
SYSMANユーザーのパスワード:

続行しますか。 [はい(Y)/いいえ(N)]: Y
2020/05/13 0:01:35 oracle.sysman.emcp.EMConfig perform
情報: この操作はC:\Oracle\cfgtoollogs\emca\orcl\emca_2020_05_13_00_01_25.logでロギングされています。
2020/05/13 0:01:35 oracle.sysman.emcp.EMReposConfig createRepository
情報: EMリポジトリの作成中(少し時間がかかります)...
2020/05/13 0:04:09 oracle.sysman.emcp.EMReposConfig invoke
情報: リポジトリは正常に作成されました
Enterprise Managerの構成が正常に完了しました
EMCAの終了 2020/05/13 0:04:09

Database Configuration Assistantでの設定変更も無事に成功しました。
もっとも、最初に書いたように何の意味もありませんでしたが。