Oracle Considerations

For Oracle databases, the value of the MDM_SCHEMA macro must be specified with uppercase characters. Failure to specify MDM_SCHEMA in uppercase can cause some data to be inaccessible through Data Management Studio, Data Management Server, and SAS MDM.

With Oracle 11g databases, you might experience poor performance during bulk loads, which can be improved by altering the operation of the optimizer.

To alter optimizer operation:

If you want to use a pluggable database under Oracle 12c, you must use a service name instead of an SID when configuring database connections. This includes DSNs, server.xml for the application server, and the jobs that use database utilities such as sqlplus and sqlldr.

You must also edit the sqlnet.ora file used by the database. This file is typically located in the following directory: $ORACLE_BASE/product/version_number/$ORACLE_HOME/NETWORK/ADMIN.

Edit the file as follows:

SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8