Important Settings for Oracle Database

System Variable

When Oracle Database is used a Windows System Environment variable named AMT_ORACLE_WRAPPER needs to be added. This variable should point to the ORACLE Wrapper Core dll using the fully qualified path. We advice to use the newest wrapper that is compatible with the Oracle Database version used.

The ORACLE wrapper is intended to be used along side the corresponding ODP.NET Core (ODAC) version and as such has been tested with that ODP.NET Core version.

Note: the ORACLE Wrapper Core should be installed locally and have a System Variable set on all the machines running a Lion controller or service. And also on machines which will run the Lion Developer Studio, even if they run the developer remotely.

For example:

Where the 'Variable value:' is pointing to the following file:

<AMT Installation Directory>\AmtTools\OracleWrapper\Asysco.Amt.AmtOracleWrapper.dll

From AMT 86 onwards the .NET Framework versions of the ORACLE wrapper are no longer supported, the previously used AMT_ORACLE_WRAPPERCORE variable is also obsolete from that AMT version.

Recommended database collation and characterset

NLS_CHARACTERSET      : WE8MSWIN1252
NLS_NCHAR_CHARACTERSET : AL16UTF16
NLS_SORT               : BINARY
NLS_COMP               : BINARY

SQL statement to check the database character sets:
SELECT * FROM NLS_DATABASE_PARAMETERS;