ERROR Recvlets.aq: Error Enabling User Sys For Aq Agent ORA-16000
(Doc ID 1627508.1)
Last updated on SEPTEMBER 07, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 11.1.0.1 and laterInformation in this document applies to any platform.
Symptoms
Every 5 minute the following entry is generated on emagent.trc for physical standby on open mode ' READ ONLY WITH APPLY'
SQL = "/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl"...
LOGIN = sys/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>.<DOMAIN>)(PORT=1521))(CONNECT_DATA=(SID=rpt)))
2014-01-30 06:09:40,255 Thread-1115523392 ERROR recvlets.aq: Error enabling user sys for aq agent cdptpa_bi_db__3872_rpt on BI_rpt_DG: ORA-16000: database open for read-only access
ORA-06512: at line 1
2014-01-30 06:09:40,255 Thread-1115523392 ERROR recvlets.aq: unable to create subscription on oracle_database BI_rpt_DG
2014-01-30 06:10:40,360 Thread-1115523392 WARN vpxoci: OCI Error -- ErrorCode(16000): ORA-16000: database open for read-only access
ORA-06512: at line 1
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 |
| Cause |
| Solution |