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 MARCH 30, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.1.0.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms