credential not found guid(0) | step: checkUsedDumpSpace | Task: transferAWR | Oracle AWR Warehouse

credential not found guid(0)  | step: checkUsedDumpSpace | Task: transferAWR | Oracle AWR Warehouse.



Hi there,

Don't get this notes under consideration. Bullshit.

EM12c : AWR Warehouse - Extract process is getting failed (Doc ID 2153156.1)

EM 13c: AWR Warehouse Transfer Job in Enterprise Manager 13c Cloud Control Fails with Error: credential not found guid(0) (Doc ID 2194081.1)

&###    Quick and short in few words.

You try to cinfigure AWR warehouse, and you've got an error at TransferAWR step.

You should to keep in mind that data pump files - exported by the job, will be sent by SQLnet [ default 1521  ] port from agent host.

If You have configured Your ENV

AgentHost> OMS [ port ] - For commmunication with OMS
OMS > AgentHost[ port ] - For communication with agent
OMS > AgentHost   [port-SQLnet def 1521 ] - for database connections.

This is not enough. You need to have open port for SQLnet from all AgenHost ports.

AgentHost> OMS  [port-SQLnet def 1521 ] - probabbly for dbms_file_transfer to transfer dPumps.

This should be strongly considered. You Will have the connection from all databases to OMS.

Configuring AWR Warehouse.



step: checkUsedDumpSpace

SQL*Plus: Release 11.1.0.7.0 - Production on Tue May 17 10:38:44 2016
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SQL> SQL> BEGIN dbsnmp.mgmt_caw_extract.run_job_now; END;
*
ERROR at line 1:
ORA-02800: Requests timed out
ORA-06512: at "DBSNMP.MGMT_CAW_EXTRACT", line 528
ORA-06512: at "DBSNMP.MGMT_CAW_EXTRACT", line 572
ORA-06512: at line 1
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error from SQLPLUS: 1