Uncategorized exception during repository access

ODI-10182: Uncategorized exception during repository access.

Cause
The error can occur when connecting to a 12c PDB (pluggable database) using the Oracle SID in the URL, for example:

jdbc:oracle:thin:@<host>:<port>:<sid>
Solution
Connections to pluggable databases require an Oracle Service Name in the URL, such as:

jdbc:oracle:thin:@//<host>:<port>/<service_name>
or
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<Pluggable Database Service Name>)))

Alternatively an OCI based connection can be used:

jdbc:oracle:oci8:@<tns_alias>