While using Oracle Destination, the following error message was encountered.:
'Could not create a managed connection manager'
Most probably the required Oracle ODAC package is not installed on the machine where it fails. See the Oracle Destination documentation.