ORA-00001: Unique Constraint (SYS.WRH$_SERVICE_NAME_PK) Violated
(Doc ID 2973353.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.16.0.0.0 version, gathering awr snapshot getting the following error
ORA-00001: unique constraint (SYS.WRH$_SERVICE_NAME_PK) violated
in trace files :
*** KEUUXS - encountered error: (ORA-00001: unique constraint (SYS.WRH$_SERVICE_NAME_PK) violated
)
*** SQLSTR: total-len=411, dump-len=411,
SQLSTR={insert into wrh$_service_name (dbid, per_pdb, con_dbid, snap_id, service_name_hash, service_name ) select :dbid, t1.con_id, con_id_to_dbid(t1.con_id) con_dbid, :lah_snap_id, t2.name_hash, t2.name FROM x$kewrattrnew t1, v$active_services t2 WHERE (1 = 1) AND ( t1.con_id < 4099 ) AND (t2.con_id IS NULL OR (t1.con_id = t2.con_id)) and t1.num1_kewrattr = t2.name_hash and t2.name is not null}
*** kewrftecpc-3: Error=13509 encountered by kewrftecpc
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |