First verify the “Distribute Transaction Coordinator” Service is running on both database server computer and client computers

1.      Go to “Administrative Tools > Services”

2.      Turn on the “Distribute Transaction Coordinator” Service if it is not running

If it is running and client application is not on the same computer as the database server, on the computer running database server

1.      Go to “Administrative Tools > Component Services”

2.      On the left navigation tree, go to 

“Component Services > Computers > My Computer”  (you may need to double click and wait as some nodes need time to expand)

3.      Right click on “My Computer”, select “Properties”

4.      Select “MSDTC” tab

5.      Click “Security Configuration”

6.      Make sure you check “Network DTC Access”, “Allow Remote Client”, “Allow Inbound/Outbound”, “Enable TIP”  (Some option may not be necessary, have a try to get your configuration)

7.      The service will restart

8.      BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN’T WORK

On your client computer use the same above procedure to open the “Security Configuration” setting, make sure you check “Network DTC Access”, “Allow Inbound/Outbound” option, restart service and computer if necessary.

On you SQL server service manager, click “Service” dropdown, select “Distribute Transaction Coordinator”, it should be also running on your server computer.

The setup routines for the Oracle ODBC client in instantclient64_12_1 could not be loaded. System error code 126: The denoted module was not found. (C:Program FilesOracleinstantclient64_12_1SQLORAS32.DLL).

Download and install the Microsoft Visual C++ 2010 Redistributable Package:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632

The problem is not with the SQLORA dlls, but the modules that those ddls refer to (missing from a default Windows installation).

http://serverfault.com/questions/555972/cannot-create-oracle-odbc-source-on-64bit-windows-7

AD User executing agent job needs to have SQLAgeUserRole in msdb and be owner of job.

https://technet.microsoft.com/en-US/library/ms188283(v=SQL.110).aspx

REM  Run as administrator

“C:\Program Files\Quest Software\pa_agent\3566\agents\bin\quest_launcher.exe” 3566 “+C:\Program Files\Quest Software\pa_agent\3566\agents” -unregister

https://support.software.dell.com/performance-analysis-for-oracle/kb/44712

Error message:

03/03/2015 12:43:09,spid28s,Unknown,An exception occurred while enqueueing a message in the target queue. Error: 15404 State: 19. Could not obtain information about Windows NT group/user 'domainsvc_name' error code 0x5.
03/03/2015 12:43:09,spid28s,Unknown,Error: 28005 Severity: 16 State: 2.


Diagnosis:

Can confirm this by executing the following SQL:


xp_logininfo 'domainsvc_name'


Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'domainsvc_name', error code 0x5.



Resolution:

A: Give the “Authenticated Users”  “Read Permissions” on the ADFS service account.

-or-

B: Add the SQL Server service account or "Authenticated Users" to the "BULTIINWindows Authorization Access Group" in AD for the domain

-or- 

C: Add the SQL Server service account or "Authenticated Users" to the "BULTIINPre-Windows 2000 Compatible Access" in AD for the domain


References:

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_6635.html

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_4905.html

http://blog.matticus.net/2009/08/windows-2008-and-xplogininfo.html

--To see if default trace is enabled
SELECT* FROM sys.configurations WHERE configuration_id = 1568


--To enable default trace
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'default trace enabled', 1;
GO
RECONFIGURE;
GO


--To query contents of default trace file
SELECT TE.*
     , T.*
  FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150)

       , ( SELECT TOP 1 f.[value]
             FROM sys.fn_trace_getinfo(NULL) f
            WHERE f.property = 2)), DEFAULT) T
  JOIN sys.trace_events TE 
    ON T.EventClass = TE.trace_event_id

More info:

http://www.databasejournal.com/features/mssql/a-few-cool-things-you-can-identify-using-the-default-trace.html

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/