EM13c: Transfer AWR Snapshots Step In 13c Cloud Control Fails With "ORA-24327: need explicit attach before authenticating a user"
(Doc ID 2249920.1)
Last updated on FEBRUARY 18, 2020
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.8.0 and laterInformation in this document applies to any platform.
Symptoms
In 13.2 Cloud Control, transferAWR step in uploading snapshots to AWR Warehouse, fails with following error:
=====================
conn_url: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<AWR Warehouse repository database>)(PORT=<listener port>)))(CONNECT_DATA=(SID=<AWR Warehouse repository database sid>))), user: sys, role: sysdba
Connected to database
conn_url: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=AWR Warehouse source database>)(PORT=<listener port>)))(CONNECT_DATA=(SID=<AWR Warehouse source database sid>))), user: sys, role: sysdba
Connection failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin) at /oemadminapp/agent12c/agent_13.2.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.2.1.0.0/scripts/db/transfer_awr.pl line 1119, line 21.
=====================
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 |