Oracle Connection Rules and Guidelines
Consider the following rules and guidelines for an Oracle connection:
- •An Oracle table name can have maximum of 30 characters at an appropriate place.
- •When you run a task that contains an Oracle database is in the Public schema, ensure that the schema does not contain too many objects. If the schema contains too many objects, the task times out. You can remove some objects from the Oracle database or move the objects into another database schema.
- •When you run a task for an Oracle database target, ensure that the UTF-8 characters do not exceed the maximum length of the varchar or char fields. Informatica Cloud might truncate UTF-8 characters if they exceed the maximum length of the varchar or char fields.
- •When you use an Oracle 12c connection and the ojdbc12.jar driver, you might receive a connection error that says there is no matching authentication protocol.
Set the SQLNET.ALLOWED_LOGON_VERSION parameter in the sqlnet.ora file to 8.
For example,
SQLNET.ALLOWED_LOGON_VERSION=8