Advanced Oracle Settings

Setting Up the OS_AUTHENT_PREFIX Parameter

This parameter handles a prefix before user names. If this parameter is set on the ORACLE server, it is required to set it in repository parameters in the Format of OS User Names box. The OS_AUTHENT_PREFIX parameter is set to default value on the server.

NOTE. Parameter values are case-sensitive.

The OS_AUTHENT_PREFIX parameter is set in the file:

S\oracle\admin\orcl\prfile\initorcl.ora,

where:

S - path to the folder with installed ORACLE.

orcl - database instance (SERVICE_NAME).

The following string must be included in the file:

OS_AUTHENT_PREFIX = "VALUE"

where:

VALUE - parameter value.

NOTE. If an empty OS_AUTHENT_PREFIX parameter is specified on the server, it should be left empty in the repository settings.

Setting Up on Domain Authentication

When integrated domain authentication is used, select the user name format in database connection settings. The format should be specified if it differs from the default one or a prefix before user names (OS_AUTHENT_PREFIX parameter) is set on the Oracle server. By default, Foresight Analytics Platform uses the following name format for domain authentication: DOMAIN\USER_NAME.

On the server determine domain authentication determined in the file:

S\oracle\ora92\network\admin\sqlnet.ora,

where:

S - path to the folder with installed ORACLE on the server.

Add the following string to the file:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

After entering the string, reload server services in the following order:

- TNSListener;
- OracleService.

After server reloading, reload the services listed above. Otherwise, problems may arise during connection under the DBMS user or the domain user.

To determine domain authentication on the client computer, add the string given for servers to the sqlnet.ora file:

S\oracle\ora92\network\admin\sqlnet.ora,

where:

S - path to the folder with installed ORACLE at the client computer.

Restart Foresight Analytics Platform.